May 26, 2005 at 11:07 am
In a procedure, I want to link an Informix server :
EXEC sp_addlinkedserver
@server = '24sunix_se', -- name of the informix server
@provider = 'MSDASQL',
@datasrc = 'certif', -- name of the odbc connection
@srvproduct = 'Informix 3.33 32 bit'
EXEC sp_addlinkedsrvlogin
@rmtsrvname = '24sunix_se',
@userself = 'false',
@locallogin = 'sa',
@rmtuser = 'smc',
@rmtpassword = 'toto'
The server appear in the list of the linked server (in Security/Linked server), but I can't access to the tables :
Error 7399 : Data source name not found and no default driver specified.
[OLE/DB Provider MSDASQL 'IDVInitialize::Initialize returned 0x80004005
I don't understand the error message, the odbc connection works fine. And I can build an connection with a udl file using the connection string :
MSDQSQL.1;Security Info = false; User ID = smc; Data source = certif
What's wrong in my process ?
Thank's you for your help !
Jean-Pierre
May 26, 2005 at 11:55 pm
Did you check the following:
Is the ODBC source a System DSN, not an User DSN? Is the ODBC source on the server machine?
Hope this helps.
Erik
May 27, 2005 at 12:58 am
The ODBC source is a User DNS and the ODBC source is on the server machine with SQLServer.
Thank's for the reply
May 27, 2005 at 3:14 am
Hi,
Have you checked the settings of the linked server in Enterprise Manager under Security -> Linked Servers.
If any of the settings in here goes out, it affects all Linked Servers using this driver and if the security / login details aren't set properly, you will encounter the error you describe.......
As an aside - Informix drivers are notoriously problematic. Make sure you have exactly the same Informix ODBC driver versions installed on all machines you are using.
Have fun
Steve
We need men who can dream of things that never were.
May 27, 2005 at 3:30 am
Hello,
I also think that the ODBC source must be declared as System DSN.
There is also an error in your second T-SQL command:
EXEC sp_addlinkedsrvlogin
@rmtsrvname = '24sunix_se',
@userself = 'false', <<<<<<<<-----must be: useself = 'false'
@locallogin = 'sa',
@rmtuser = 'smc',
@rmtpassword = 'toto'
There is an example about linking a Sybase database here http://support.microsoft.com/?id=280102. May be can help you.
Hope this help
Jc
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply