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.

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 !