Problem with parameters

2002-12-02 Thread Gerald Norman
I sent a previous question about having problems with SQL statements using parameters not working in MySQL when they worked in Access. I am using the ODBC driver and ADO and have had no problems at all to date. Upon some further research the problem seems limited to SELECT statements. Updates

Converting Access to MySQL

2002-12-01 Thread 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 Acces