l******9
发帖数: 579 | 1 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: pypyodbc error access netezza SQL server on win7
发信站: BBS 未名空间站 (Sun Dec 21 10:15:22 2014, 美东)
I need to access IBM netezza SQL database from python on win 7. I have
installed Eclipse and python 3.2, pydev, and pypyodbc https://pypi.python.
org/pypi/pypyodbc/1.3.3). It worked well for MS SQL server.
But, it got error for IBM netezza.
import pypyodbc
conn = pypyodbc.connect("DRIVER={NetezzaSQL};SERVER={my_server_name};
DATABASE={my_database};UID=a_user;PWD=apwd")
pypyodbc.DatabaseError: ('08001', '[08001] Client unable to establish
connection')
Any help would be appreciated.
thanks ! | n*****t
发帖数: 22014 | 2 看看 odbc.ini，我瞎狗的，蒙错了别骂我
【在 l******9 的大作中提到】
: 【 以下文字转载自 Database 讨论区 】
: 发信人: light009 (light009), 信区: Database
: 标 题: pypyodbc error access netezza SQL server on win7
: 发信站: BBS 未名空间站 (Sun Dec 21 10:15:22 2014, 美东)
: I need to access IBM netezza SQL database from python on win 7. I have
: installed Eclipse and python 3.2, pydev, and pypyodbc https://pypi.python.
: org/pypi/pypyodbc/1.3.3). It worked well for MS SQL server.
: But, it got error for IBM netezza.
: import pypyodbc
: conn = pypyodbc.connect("DRIVER={NetezzaSQL};SERVER={my_server_name};
| l******9
发帖数: 579 | 3 How to check odbc.ini ?
thanks
【在 n*****t 的大作中提到】
: 看看 odbc.ini，我瞎狗的，蒙错了别骂我
|
|
