2. ASPRunnerPro General questions
  3. IBM DB2 Error
This topic is locked

IBM DB2 Error

 		4/7/2005 9:49:09 AM
ASPRunnerPro General questions
swat author

Technical information

Error number -2147217805

Error description Format of the initialization string does not conform to the OLE DB specification.

URL /test/md/filename_list.asp

SQL query select .....,..,......,...,. From MIDS.filename[/b]
Here is the error , I have IBM DB2
Sergey Kornilov admin 4/8/2005

Hi,
please post here your connection string from include/...dbconnection.asp file.
swat author 4/12/2005

Technical information

Error number -2147217805

Error description Format of the initialization string does not conform to the OLE DB specification.

URL /myweb/test/.............._list.asp

SQL query select ........................................................

<%

strConnection = "Provider=MSDataShape;DRIVER=  {IBM DB2 ODBC DRIVER};DSN=DSN_NAME;UID=USERID;PWD=PASSWORD; MODE=SHARE;DBALIAS=DSN_NAME; TXNISOLATION=1; SCHEMALIST="'QQQQ'"; CURRENTSCHEMA=QQQQ;"

%>
Sergey Kornilov admin 4/13/2005

Hi,
I would recommend you to create an ODBC DSN for this database and connect using this DSN.
swat author 4/13/2005

I have format connection for this DB- but I am not sure how to use it with asprunner thx
Sergey Kornilov admin 4/14/2005

Hi,
to create an ODBC DSN for this database proceed to Control panel - Administrative tools - Data Sources (ODBC) - System DSN.

Click Add ... and choose DB2 ODBC driver.
After that you can connect to database in ASPRunner using this DSN.