My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 361: Issues with Netezza
1 person starred this issue and may be notified of changes. Back to list
Status:  New
Owner:  ----


 
Reported by mle...@gmail.com, Mar 10, 2014
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.


Dec 21, 2014
#1 blueAtla...@gmail.com
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 !


Powered by Google Project Hosting