Re: Suddenly ODBC driver does not work

Rolf Rosenquist wrote:
> 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

I just noticed that you are using MySQL. I have no experience with that
database, but I have to ask, why are you using a pessimistic lock? And why
the adCmdTable? Could you not specify a sql statement that returns exactly
the columns and rows that you need and use a default forward-only cursor?

If you are planning to make data updates, you should be using DML
(UPDATE/INSERT/DELETE statements) rather than resource- and lock-intensive
cursors (recordsets). You can use transactions with MySQL, so there is no
need for pessimistic locking.

I suspect your provider needs to install a new version of the MySQL ODBC
driver if you intend to continue using these inefficient techniques. In any
event, you will likely get better suport by going to a MySQL forum or
newsgroup if any exist.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Perl-mysql
    ... sharing the error message you get when trying to connect will ... networking for mysql may not be active ... On 8/30/06, Manne, Siva Chaitanya Prasad ... machine from my Windows machine. ...
    (perl.beginners)
  • Re: connection with MySQL with Python interface
    ... > When I tried to connect with MySQL database which run on XP from shell. ... Has anyone get similar error message and provide any suggestion? ... You have to know that a client needs to have a mysql-client ...
    (comp.lang.python)
  • Re: MySQL vs. DBI/DBD
    ... A simple Google search on the error message: ... > When I run the script I get this error message: ... consider upgrading MySQL client at test.pl line 15 ...
    (perl.dbi.users)
  • Re: Suddenly ODBC driver does not work
    ... Bob with MySQL on a windows server your pretty much going to be using MyODBC ... >> Suddenly the users and I get an error message when trying to open the ... >> The page stops and shows "ODBC Drivers error '80040e21' ...
    (microsoft.public.inetserver.asp.db)
  • RE: Trouble starting MySQL
    ... >> No error message is emitted, but no running instance of mysql either. ... Computer viruses can be transmitted by e-mail. ...
    (freebsd-questions)