5 Replies Latest reply on Aug 5, 2020 9:12 AM by Asmita Kesarwani

    CMN_1022 Database driver error... CMN_1022 [ [Informatica][ODBC 20101 driver][20101]Cannot open database

    New Member
    IvánDario00u15lpviqnyVeovt1d8 Jun 14, 2017 1:01 PM

      Hi Masters

       

       

      I'm tryin to conect to a target on a SQL Server 2012, and i'm getting the following error:

       

       

      ERROR 14/06/2017 02:28:26 p.m. node01_co1p49o PRE-SESS CMN_1022 Database driver error...

      CMN_1022 [

      [Informatica][ODBC 20101 driver][20101]Cannot open database "<DATABASE_NAME>" requested by the login. The login failed.[Informatica][ODBC 20101 driver][20101]Login failed for user '<DATABASE_USER>'.

      Database driver error...

      Function Name : Connect

      Database driver error...

      Function Name : Connect

      Database Error: Failed to connect to database using user [<DATABASE_USER>] and connection string [<DATABASE_ODBC_CONN>].]

       

       

      The ODBC string Connection is:

      [<DATABASE_ODBC_CONN>]

      Driver=/data/Informatica/9.6.1/ODBC7.1/lib/DWsqls27.so

      Description=Descripcion

      HostName=<SERVER_IP_ADDR>

      PortNumber=1433

      AlternateServers=

      AnsiNPW=Yes

      ConnectionRetryCount=0

      ConnectionRetryDelay=3

      Database=<DATABASE_NAME>

      FetchTSWTZasTimestamp=0

      FetchTWFSasTime=0

      LoadBalancing=0

      LogonID=

      Password=

      QuotedId=No

      ReportCodepageConversionErrors=0

      SnapshotSerializable=0

      IANAAppCodePage=1252

      charset=IGNORE-CHARSET

       

       

      The happens whit all 11 sessions to connects to that data base, we already validate the connection with the user and works fine.

       

       

      thanks for the time and the help

       

       

      Ivan Rojas