Linking an Informix server -> Error 7399

  • 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

  • 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

  • The ODBC source is a User DNS and the ODBC source is on the server machine with SQLServer.

    Thank's for the reply

  • 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.

  • 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