MySQL Forums
Forum List  »  Connector/ODBC

ODBC connection 8.0 won't write to database
Posted by: Jesper Ahlers
Date: May 24, 2018 10:21AM

Hi
I'm using the following connection string on my 64 BIT Win10 pc in a ASP Classic program.

Driver={MySQL ODBC 8.0 ANSI Driver};Server=127.0.0.1;Database=my_db; User=root;Password=MyPW;Option=3;'
It works fine with reading the database, but when updating I get the following error
[MySQL][ODBC 8.0(a) Driver][mysqld-5.5.30]The number of parameter markers is not equal to he number of parameters provided

I have an old 32bit pc running ODBC driver 3.51 which works fine.

Shall I in one way or another give access to updating the database?
If so please tell me how

Thanks a lote

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.