Trouble connecting from SharePoint Designer 2010 to Netezza using OLEDB

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. I know Netezza's OLEDB provider is sound, because I can connect to Netezza using an Aginity database browser from the SharePoint application server. However, when I try to connect by defining a data source in SharePoint Designer, the connection fails, whether I use the standard Framework for OLEDB parameters or define a custom string using the ConnectionStrings.com template. Any help would be appreciated.

0 answers