I am using MySQL to simply store data entered through a VB 6.0 user interface. I am making my connection using MyODBC 3.51.
After creating the exe file, the application works flawlessly on my PC. However, when I set it up on another PC, it does retrieve data fine on the other PC but when I try to save new or modified data I receive the following message.
Run-time error '-2147217911 (80040e09)
[MySQL][ODBC 3.51 Driver][mysqld-4.0.1-alpha-max-nt] You have an error in your SQL syntax near {Select statement} at line 1
Is this some type of security issue? If it is, is it on the VB side or MySQL?
Thanks in advance for your help.
After creating the exe file, the application works flawlessly on my PC. However, when I set it up on another PC, it does retrieve data fine on the other PC but when I try to save new or modified data I receive the following message.
Run-time error '-2147217911 (80040e09)
[MySQL][ODBC 3.51 Driver][mysqld-4.0.1-alpha-max-nt] You have an error in your SQL syntax near {Select statement} at line 1
Is this some type of security issue? If it is, is it on the VB side or MySQL?
Thanks in advance for your help.
