Re: Client Access as NT Service ODBC Connect from IIS using ASP

Mark,

I'm not familiar with the error message that you're receiving, but I did
notice that you're trying to use ADO over ODBC. Unfortunately,  IBM's OLE/DB
driver does not support the passing of UserID or password on the connection
string. This is documented in the OLE Express Technical Reference help
file - under "Connection object support summary" in Appendix B.

HTH,

John Taylor
Canada

----- Original Message -----
From: "Mark Allen" <markallen@kellyskids.com>
To: "MIDRANGE-L" <MIDRANGE-L@midrange.com>
Sent: Friday, August 25, 2000 11:27
Subject: Client Access as NT Service ODBC Connect from IIS using ASP


> We have been attempting to get an ODBC connection to our AS/400 to run so
we
> can access AS/400 data from MS IIS.  Keep gettign the following error:
>
>
> Microsoft VBScript runtime error '800a01ad'  ActiveX component can't
create
> object  /mark/as400smp.asp, line 43
>
> Have searched both IBM's web site and the MIDRANGE-L archives and with
> everything we have read it "appears" we did everything correctly.
>
> The Asp line in question is marked below...
>
>
> Set OBJdbConnection = Server.CreateObject("ADODB.Connection")
> OBJdbConnection.Open "DSN=AS400;UID=WEBODBC;PWD=KK400MIS"     <-----THIS
IS
> LINE 43
> OBjdbConnection.CommandTimeout=0
> SQLQuery = "SELECT * FROM WEB.QCUSTCDT"
> Set RSCustomerList = OBJdbConnection.Execute(SQLQuery) +
>
>
> Any ideas on what we have MISSED!!!!
>
> Mark Allen
> IS Manager
> Kelly's Kids
> markallen@kellyskids.com


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---