The uci.config is identical on both servers. Let me look for that security tab; that may be the golden ticket right there.
On Mon, Apr 5, 2010 at 6:31 AM, Lettau, Jeff <jlet...@polkaudio.com> wrote: > 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: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] 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 > U2-Users@listserver.u2ug.org > 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 > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- -Kevin http://www.PrecisOnline.com _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
