Connect to SQL Server Analysis Service from Python

Asked Jul 12 '14 at 12:38

Active Jul 12 '14 at 12:38

Viewed 1,351 times

I'm using PyODBC for SQL Server 2008 database engine and it works well. I can retrieve records and execute procedures and views with no problem.

My issue is I can't connect to SQL Server 2008 Analysis Server using PyODBC. Following list shows what I've tried:

cnxn = pyodbc.connect(r'Driver={SQL Server};Server=127.0.0.1;Database=DB1;Trusted_Connection=yes;')

And

cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER=127.0.0.1;DATABASE=DB1;Trusted_Connection=yes;UID=TB\\user;PWD=123123')

What's the problem? How can I address this issue?

asked Jul 12 '14 at 12:38

Afshin Mehrabani

You need to provide us with way more information than that.. error message? – Martin Konecny Jul 12 '14 at 14:26
1

What flavor of server are you on, Windows or Linux, where you are running Python? If you're on Linux, try this: – FlipperPA Jul 18 '14 at 22:14
cnxn_str = 'DRIVER={FreeTDS};SERVER=yourservername.com;PORT=1433;DATABASE=db_name;UID=db_user;PWD=db_password;TDS_Version=7.2;' – FlipperPA Jul 18 '14 at 22:15
cnxn = pyodbc.connect(cnx_str, autocommit=True) – FlipperPA Jul 18 '14 at 22:17
Let me know if that was the issue (if you're on Linux) and I will convert it to an answer. Please also note you'll have to have FreeTDS and UnixODBC installed as well. – FlipperPA Jul 18 '14 at 22:17
What is your expected output? SSAS is not an RDBMS, and doesn't support SQL queries. Are you trying to connect to the SSAS database hosted in SQL Server? – Bryan Jul 21 '14 at 12:56
Was this ever solved? – Spartako Nov 27 '14 at 17:51
@Spartako No, I rewrote the app using C#. – Afshin Mehrabani Nov 28 '14 at 09:29

0 Answers0