Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Angry Unanswered: Need help connecting to Informix db from win2k

    Hi all,

    Iím running around in circles trying to figure this one out. Iíve never connected to an Informix DB and am using a 3rd party vendorís code. The connection fails when trying to open it using a system DSN:

    23> SET CN = Server.CreateObject("ADODB.Connection")
    24> CN.ConnectionString="DSN=EncompassTest"
    25> CN.Open

    Result when running ASP page:

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    [INTERSOLV][ODBC Informix driver]Optional feature not implemented.
    /alarmtest/alarm_lib.asp, line 25

    As far as I know the DSN and Setnet32 are configured correctly. The Client SDK 2.81 is also installed. I can use the Ilogin Demo to successfully connect but cannot do so from the ASP application. I enabled tracing in the ODBC admin and got this:


    Processid:{3D14 728-4d8 ENTER SQLAllocConnect
    HENV 00AE18F0
    HDBC * 0202DC2C

    Processid:{3D14 728-4d8 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
    HENV 00AE18F0
    HDBC * 0x0202DC2C ( 0x00ae1998)

    Processid:{3D14 728-4d8 ENTER SQLSetConnectAttrW
    SQLHDBC 00AE1998
    SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
    SQLPOINTER 0x0000000F
    SQLINTEGER -6

    Processid:{3D14 728-4d8 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
    SQLHDBC 00AE1998
    SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
    SQLPOINTER 0x0000000F (BADMEM)
    SQLINTEGER -6

    Processid:{3D14 728-4d8 ENTER SQLDriverConnectW
    HDBC 00AE1998
    HWND 00000000
    WCHAR * 0x1F7B1D38 [ -3] "******\ 0"
    SWORD -3
    WCHAR * 0x1F7B1D38
    SWORD 8
    SWORD * 0x00000000
    UWORD 0 <SQL_DRIVER_NOPROMPT>

    Processid:{3D14 728-4d8 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
    HDBC 00AE1998
    HWND 00000000
    WCHAR * 0x1F7B1D38 [ -3] "******\ 0"
    SWORD -3
    WCHAR * 0x1F7B1D38
    SWORD 8
    SWORD * 0x00000000
    UWORD 0 <SQL_DRIVER_NOPROMPT>

    DIAG [S1C00] [INTERSOLV][ODBC Informix driver]Optional feature not implemented. (0)

    DIAG [S1000] [INTERSOLV][ODBC Informix driver][Informix]Cannot open file 'sql.iem'
    (-461)

    DIAG [IM006] [INTERSOLV][ODBC Informix driver]Driver's SQLSetConnectAttr failed. (0)

    Processid:{3D14 728-4d8 ENTER SQLGetDiagRecW
    SQLSMALLINT 2
    SQLHANDLE 00AE1998
    SQLSMALLINT 1
    SQLWCHAR * 0x0202DB74 (NYI)
    SQLINTEGER * 0x0202DB98
    SQLWCHAR * 0x0202D774 (NYI)
    SQLSMALLINT 512
    SQLSMALLINT * 0x0202DB9C

    Processid:{3D14 728-4d8 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
    SQLSMALLINT 2
    SQLHANDLE 00AE1998
    SQLSMALLINT 1
    SQLWCHAR * 0x0202DB74 (NYI)
    SQLINTEGER * 0x0202DB98 (0)
    SQLWCHAR * 0x0202D774 (NYI)
    SQLSMALLINT 512
    SQLSMALLINT * 0x0202DB9C (66)

    Processid:{3D14 728-4d8 ENTER SQLGetDiagRecW
    SQLSMALLINT 2
    SQLHANDLE 00AE1998
    SQLSMALLINT 2
    SQLWCHAR * 0x0202DB74 (NYI)
    SQLINTEGER * 0x0202DB98
    SQLWCHAR * 0x0202D774 (NYI)
    SQLSMALLINT 512
    SQLSMALLINT * 0x0202DB9C

    Processid:{3D14 728-4d8 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
    SQLSMALLINT 2
    SQLHANDLE 00AE1998
    SQLSMALLINT 2
    SQLWCHAR * 0x0202DB74 (NYI)
    SQLINTEGER * 0x0202DB98 (-461)
    SQLWCHAR * 0x0202D774 (NYI)
    SQLSMALLINT 512
    SQLSMALLINT * 0x0202DB9C (70)

    Processid:{3D14 728-4d8 ENTER SQLGetDiagRecW
    SQLSMALLINT 2
    SQLHANDLE 00AE1998
    SQLSMALLINT 3
    SQLWCHAR * 0x0202DB74 (NYI)
    SQLINTEGER * 0x0202DB98
    SQLWCHAR * 0x0202D774 (NYI)
    SQLSMALLINT 512
    SQLSMALLINT * 0x0202DB9C

    Processid:{3D14 728-4d8 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
    SQLSMALLINT 2
    SQLHANDLE 00AE1998
    SQLSMALLINT 3
    SQLWCHAR * 0x0202DB74 (NYI)
    SQLINTEGER * 0x0202DB98 (0)
    SQLWCHAR * 0x0202D774 (NYI)
    SQLSMALLINT 512
    SQLSMALLINT * 0x0202DB9C (67)

    Processid:{3D14 728-4d8 ENTER SQLGetDiagRecW
    SQLSMALLINT 2
    SQLHANDLE 00AE1998
    SQLSMALLINT 4
    SQLWCHAR * 0x0202DB74 (NYI)
    SQLINTEGER * 0x0202DB98
    SQLWCHAR * 0x0202D774 (NYI)
    SQLSMALLINT 512
    SQLSMALLINT * 0x0202DB9C

    Processid:{3D14 728-4d8 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
    SQLSMALLINT 2
    SQLHANDLE 00AE1998
    SQLSMALLINT 4
    SQLWCHAR * 0x0202DB74 (NYI)
    SQLINTEGER * 0x0202DB98
    SQLWCHAR * 0x0202D774 (NYI)
    SQLSMALLINT 512
    SQLSMALLINT * 0x0202DB9C

    Processid:{3D14 728-4d8 ENTER SQLFreeConnect
    HDBC 00AE1998

    Processid:{3D14 728-4d8 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
    HDBC 00AE1998


    The services file on the win2k machine contains the service name I'm using. Everything seems to be set up fine but it will not work!

    Any help is greatly appreciated!!!!

    David

  2. #2
    Join Date
    Mar 2004
    Posts
    3
    Here's the connection string I use to connect to Informix via ODBC (driver version 3.80). I use this in an ActiveX task in a DTS script

    sConnectString = "Provider=MSDASQL.1:Password=password;" _
    "Persist Security Info=True;User ID=userid;Data " _
    "Source=""odbc_dsn"";Initial Catalog=database_name"

    Set oConn = CreateObject("ADODB.Connection")
    oConn.Open sConnectString

  3. #3
    Join Date
    Mar 2004
    Posts
    3
    Thanks, same error with that connection string though...

  4. #4
    Join Date
    Mar 2004
    Posts
    3
    FYI - the problem turned out to be the drivers (v 3.10). After installing the new IBM Informix SDK, recreating the DSN with the new drivers and restarting the box, the problem was soved.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •