Suddenly ODBC driver does not work

I have an application that has worked fine for more than 2 years. Suddenly
the users and I get an error message when trying to open the MySql database
for writing. The web host says that I may have a too complicated script or
anything else. So far no help from them.

The page stops and shows "ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties. "

My code here is stopping at the last line:
Dim rsProgr
Set rsProgr = Server.CreateObject("ADODB.Recordset")
rsProgr.Open "Program", objConn, adLockPessimistic, adCmdTable

After many tries with this error message, it suddenly works again as if no
fault has happened. And later, the same story again.
Anyone knows where to start?
/ Rolf



.

Relevant Pages

  • Re: SQL
    ... what drivers are you using to access the DBF file? ... ODBC drivers which result in this error the first time they are initialised. ... The fact that you error message mentions Paradox is a little weird, ...
    (microsoft.public.vb.database.dao)
  • Re: Reviewing my code. Displaying a BLOB image through a browser
    ... Ok I made that change and now I get this error message in my browser. ... Microsoft OLE DB Provider for ODBC Drivers ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Suddenly ODBC driver does not work
    ... > Suddenly the users and I get an error message when trying to open the ... > The page stops and shows "ODBC Drivers error '80040e21' ... I just noticed that you are using MySQL. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Data access
    ... I tried accessing databases like MS-Access, ... and Oracle via ODBC drivers. ... connects to the database, I have encountered "Microsoft ... error Message' which is asking me to send the report to ...
    (microsoft.public.windowsxp.general)
  • Re: Damaged ODBC Drivers
    ... >> I have received error messages stating that my ODBC drivers may be ... > When are you getting the error message? ... > you find the instructions saying to uninstall SP2? ... The solution was to copy the registry ...
    (microsoft.public.windowsxp.basics)