Monday, July 19, 2010

Setting up Netezza OLEDB Linked server in Sql server

Open Server Objects, Linked Servers, and Providers. Right-click on the NZOLEDB provider and choose Properties. Turn on the "Allow Inprocess" option. No, this is neither as secure nor as crash resistent as not turning it on. However, working is better than not working, and it doesn't work if it's not in process.

Thanks to http://weblogs.sqlteam.com/chrism/archive/2008/11/12/Netezza-and-OLE-DB.aspx

No comments:

Post a Comment