connecting to DB2

[Fredrik Hage]

Hello!

We have some problems trying to connect to DB2.
The ODBC-driver on the server is IBM DB2 ODBC DRIVER.

What is wrong with this code?

set connect = server.CreateObject("ADODB.connection&#34
connect.Open ("provider=MSDASQL;DSN=DELT;UID=EL28548;PWD=BE NGT77;DATABASE=DELT&#34

query = "select * from c00.simutsi"
set tabell = connect.Execute(query)

The messages returned are:

ISOLATIONLEVEL:4096
ATTRIBUTES:0
PROPERTIESESCRIPTION:[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
SQLSTATE:IM006
NATIVEERROR:0
DESCRIPTION:[
SQLSTATE:01S00
NATIVEERROR:-99999
connect.state : 1

Greatful for some help!!!!!!!!!!

[John]

Hi Fredrik,

I think you'll have better luck if you post this in a different forum
on this web site. This forum is dedicated to the support of ASP-db
(www.aspdb.com).

Thanks!
John


------------
Fredrik Hage at 9/9/99 9:20:40 AM

Hello!

We have some problems trying to connect to DB2.
The ODBC-driver on the server is IBM DB2 ODBC DRIVER.

What is wrong with this code?

set connect = server.CreateObject("ADODB.connection&#34
connect.Open ("provider=MSDASQL;DSN=DELT;UID=EL28548;PWD=BE NGT77;DATABASE=DELT&#34

query = "select * from c00.simutsi"
set tabell = connect.Execute(query)

The messages returned are:

ISOLATIONLEVEL:4096
ATTRIBUTES:0
PROPERTIESESCRIPTION:[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
SQLSTATE:IM006
NATIVEERROR:0
DESCRIPTION:[
SQLSTATE:01S00
NATIVEERROR:-99999
connect.state : 1

Greatful for some help!!!!!!!!!!