I'm trying to connect to Netezza from Toad for Data Analysts 2.5.1 using ODBC. It requires a connectionstring. The connection prompt already has entries for Data source name, user, password, and database.
I have establish the connection from python to netezza database with oledb driver however there is an issue while enter the values into data base.
I have installed pyodbc driver in my system(windows 7 64 bit),How to connect to Natezza database in python by using OLEDB driver and how to create DSN for it.
I am trying to connect to a Netezza database from SharePoint 2010 using the "MS Framework for OLEDB providers" in SharePoint Designer and Netezza's OLEDB provider.