platiumky / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
0 stars 0 forks source link

Issues with Netezza #361

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. Connect to Netezza database
2. Select a NUMBER  value or a VARCHAR

What is the expected output? What do you see instead?
1. Number value should come back with the value instead comes back with invalid 
literal for Decimal: u'
2. VARCHAR value gets trimmed at the front losing 4 characters e.g. value that 
should be "foo-bar" returns "bar"

What version of the product are you using? On what operating system?
pyodbc-3.0.7-py2.6 on RHEL

Please provide any additional information below.

Original issue reported on code.google.com by mle...@gmail.com on 11 Mar 2014 at 4:45

GoogleCodeExporter commented 8 years ago
Hi, All,

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')

I can access the database from IBM Aginity workbench without any problems on 
the same desktop and laptop.

Any help would be appreciated.

thanks !

Original comment by blueAtla...@gmail.com on 22 Dec 2014 at 12:27