03-14-2013 10:02 AM
Anyone out there know how to create a linked server to a remote CITADEL5 database from SQL Server? This is attempting to connect to a Lookout 6.6 server. I assume that this would be the same for Labview users too, that there should be a way to connect to a remote citadel 5 database. I have installed the Lookout 6.6 client on the SQL server attempting to make the connection and have successfully created and tested an ODBC system DSN, which is what I am trying to use for the connection.
I have a successful ODBC connection, but when I go to create a linked server I am getting the following:
TITLE: Microsoft SQL Server Management Studio ------------------------------
The linked server has been created but failed a connection test. Do you want to keep the linked server?
------------------------------ ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LinkedServerName". OLE DB provider "MSDASQL" for linked server "LinkedServerName" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "LinkedServerName" returned message "[ATI][OpenRDA ODBC]RDA error: Resource unknown - Database Name:CITADEL5 is not valid on Server.". (Microsoft SQL Server, Error: 7303)
10-14-2013 03:08 PM
I believe my error is similar to yours, in a slightly different context. I have installed the Lookout client on my network PC, and I have successfully created an ODBC data source that points to my Citadel server by server name (connection tests o.k. from within 32-bit ODBC administrator, at least). When I try to connect to this data source in Excel, MS Query gives me "RDA error: Resource unknown - Database Name:CITADEL5 is not valid on Server."