how to solve "request returned with sql-error" during odbc connection?

Answer 1

@Priyan, explain in detail what is it exactly that you were doing, the error message, your connection string, and sql command.

Answer 2

Okay, is mysql installed on the same computer where you code vb, or on another computer?

- Check if you can connect to mysql from command prompt, if you can connect from mysql CLI then check your ODBC connection, make sure all connection parameters are correct, including port number. Make sure mysql port is not blocked by firewall or antivirus software.

- If you can't even connect from mysql CLI check if mysql service is running, if it's not start the service and test connection again.

- If mysql service is running, mysql CLI can connect, but ODBC failed, uninstall mysql ODBC driver and reinstall again.

- If you can connect but still having problem check your sql command in vb code.

Good luck,

Answer 3

Can you start mysql service manually?, what version is mysql?, try to start mysql service from the service manager, and select autostart on the mysql service configuration.

If you can't start mysql service you probably have a damaged mysql installation. Make backup if you have important database then reinstall mysql.

Answer 4

You're welcome

Answer 5

i am trying to connect vb 6.0 (front end) and mysql (back end ).. during odbc connection.. "request returned sql_error" is occured!!

Answer 6

mysql is not running... it was getting stopped automatically..

Answer 7

I guess i had problem in root password..
anyways thanks for your replies