MySQL Forums
Forum List  »  Connector/ODBC

Delphi ODBC connection on Win7 X64
Posted by: Simon Buckman
Date: March 17, 2017 12:45PM

I have sucessfully installed ODBC 3.5.1 on my Win7 x64 machine.
I have connected and verified connectivity to the mysql database via the ODBC test, and via command line mysql command.
However, my Delphi application is failing - it is sending a connect to database with a mixed case database name.
From the ODBC log:
8e28-655c EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
[MySQL][ODBC 3.51 Driver]Access denied for user 'myuser'@'%' to database 'MyDB' (1044)
The mysql database name is all lowercase.
The same execuatable on Win7x32 does NOT fail.
.
I do not have an environment to be able to recompile the execuatable. (sad-face)!
.
So a couple of questions.
a) Is there a way to force the existing application to pass all lowercase.
b) Is there a way to force the ODBC to change the case to all lowercase.
c) Is there some setting on the server side that can allow a mixed case call to work (PS. I am not a programmer or DBA).
d) Is there a different ODBC driver that might work.

Options: ReplyQuote


Subject
Written By
Posted
Delphi ODBC connection on Win7 X64
March 17, 2017 12:45PM


Sorry, you can't reply to this topic. It has been closed.

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.