Is the UCI.config file setup on the 2nd server? Does the SQL server recognize the driver as a valid provider under linked servers? Under the linked server in properties there should be a security tab that you need to fill in with the login and password to connect to remote systems.
Jeffrey Lettau ERP Systems Manager polkaudio -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kevin King Sent: Saturday, April 03, 2010 7:31 PM To: U2 Users List Subject: [U2] [ud] Unidata as a SQL Server "Linked Server" via OLEDB I have a customer who is trying to configure a couple of SQL Server instances to access Unidata 7.1 on AIX via OLEDB by setting up Unidata as a "linked server" in SQL Server. The exact same OLEDB (and ODBC) driver is installed on both systems and is configured identically between the two. One system can access the Unidata information in a table (that has been configured via VSG) but the other cannot. The root question is "why can one server access Unidata and the other cannot, especially when the two are configured identically?". One thing I've noticed is that the linked server configuration doesn't include any authentication information for OLEDB, but clearly there has to be some authentication somewhere, right? And with the presence of "ODBC" in the SQL Server "provider string" for the linked server, does that mean that OLEDB uses the ODBC connector to access Unidata? -Kevin http://www.PrecisOnline.com _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
