Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

AS/400 connection with ADO, ASP and Client Access

Status
Not open for further replies.

hairless

Programmer
Feb 27, 2001
1
IT
I'm trying to connect an ASP page to an AS/400 database using IBM Client Access AS400 OLE DB.

The ASP code relative to the connection is:

'********************************************************
Set AS400Conn = Server.CreateObject("ADODB.Connection")
AS400Conn.Provider = "IBMDA400"
AS400Conn.Properties("Default Collection") = "IRIS_F"

'Open the connection
AS400Conn.Open "Data Source=S3456D34;"USERID", "PWD"
'********************************************************

The OS is Windows 2000 Professional, the Web Server is IIS 5.
The ASP page shows the following error:

Error 3709 [0xE7D]
The application requested an operation on an object with a reference to a closed or invalid Connection object.

Can you help me, please?

Thanks!

Hairless (8-[)]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top