Hi,

Running VB 6 Components on a server connecting to a SQL Server database. Recently we started receiving this error.

"Requires an OLE DB Session Object, which is not supported by the current provider."

This has been working for over 8 months now and all of a sudden we started receiving this error. Could this be an ADO error?

Thanks
Robert

Don't have any answers yet, just a few question though.

Have you made any changes to your application involving calls to your database?

When does this error occur? When it is trying to connect or when you make some type of request?

Larry Asher

No changes to DB stuff. Updated references - we did move up a version in MDAC.

It happens on our first Stored Procedure call.

My thought would be either the server\client or the application is not up to date with your latest rev of the MDAC.

Initially, I would think if you installed the MDAC upgrade on the client, where your app is running, and you did not recompile your application. No harm would be done because the upgrade should backwards compatable.

But, if you installed the upgrade on your development computer and recompiled the application without upgrading MDAC on the client machine or the DB server you could have some problems. I would expect you to have problems in this case.

I would look at making sure MDAC is current on all of the machines and that your application is compiled with the current MDAC rev also.

Hope this helps.

Larry Asher