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
