ADO Connection

[Guest.Visitor]

We are have a IVR that retrieves the data off of an AS/400. To illiminate the opening and closing of a connection, we leave the ADO.Connection open during the life of the application. The problem that we are running into is that the connection during some point is closing (not programmitcally). Anyone have any suggestions as to where to look to find the problem?

[Guest.Visitor]

Sam, Have you looked at the job log for that session on the /400? It should give the reason as to why it ended. Bill

[Guest.Visitor]

Since you know about ADO and the CA OLE DB provider, can you tell me why I get the following error when I attempt to connect to the provider: "The operation requested by the application is not supported by the provider." I'm on CA v4r4m0 service pack sf60796 and I'm on MDAC 2.1. My connection string is simply: "Provider=IBMDA400; Data Source=MYAS400;"

[Guest.Visitor]

Steve, Unfortunately, I don't have an answer, but I do believe that MDAC is up to 2.5 now. One other idea might be to turn on the ODBC logging option in the Control Panel Applet. It might shed a bit more light. Bill