8 Replies Latest reply on Feb 13, 2015 2:30 AM by user162704

    Connecting to Named instance of SQL Server thru Informatica using ODBC entry

    New Member

      Hi,

       

      I'm trying to connect to the Named instance of SQL Server from informatica 9.0.1 using the ODBC Entry. While submitting the job, am getting the below error:

      SQL_Server_Error.JPG.jpg

       

      My ODBC.ini entry is as follows:   

       

          SQL_Server_ODBC.JPG.jpg     

       

      I have tried using Address=Servername\Instancename  also, am still getting the same error.  Not able to connect to the SQL server.

       

      Please help me in resolving this connectivity issue. Thanks in Advance!!