Converting Access to MySQL

[Gerald Norman]

I have an application that currently is using an Access database and am in the process of converting over to MySQL. I downloaded the ODBC driver and have been using ADO and have had no problems at all up to this point. I have a number of parameterized SQL statements that worked fine in Access, but aren't working at all with MySQL. I know that MySQL supports variables in SQL statements using the @ prefix. I've tried setting that as the prefix for the parameters but it doesn't work. I keep getting a 'unspecified error' when the SQL statement executes. Am I missing something or does MySQL not support parameters that can be set at runtime? Thanks in advance for any assistance.


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php