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

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

Thanks, same error with that connection string though...

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.