Delphi ODBC connection on Win7 X64
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.
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.