I am having problems to get one database running. I have a MySQL in my server, the server is running "5.5.48-MariaDB – MariaDB Server" with "UTF-8 Unicode (utf8)"
I have a MySQL ODBC 64 bits 3.51 Driver to be able to connect to this database. The ODBC is configure to use utf8 character set.
If I use for example MySQL workbench to connect to this database for example:
SELECT * FROM leomaker_prueba_01.Capacitor;
All is perfect, I get the data. Also work with:
SELECT DISTINCT PartType FROM Capacitor ORDER BY PartType
I think that this is the correct form to make query of this kind.
The problem start with my program: "OrCAD Capture Cis". This program make a connection to a Database to fetch data and use it in the program.
In the console of the program I get this error:
ODBC Error Description: State:S0001,Native:1050,Origin:[MySQL][ODBC 3.51 Driver][mysqld-5.5.48-MariaDB] SELECT DISTINCT "PartType" FROM "Capacitor" ORDER BY "PartType" ERROR(ORCIS-6245): Database Operation
Failed Please Check Session For More Details ERROR(ORCIS-6250): ODBC
Error Code: -1 Description: You have an error in your SQL syntax;
check the manual that corresponds to your MariaDB server version for
the right syntax to use near '"Capacitor" ORDER BY "PartType"' at line
1
As we see the query that it makes is
SELECT DISTINCT "PartType" FROM "Capacitor" ORDER BY "PartType"
Which is incorrect. I also try it in MySQL Workbench and i get the same kind of errors. I am sure that is problems of the " symbols.
The default database connect to a local SQL server. (but i can't see the querys)
Which could be the problem? I try to use MariaDB ODBC and i get the same error. Also if I try to change of character set.
It could be any form to change the querys to the database?
Thanks
Best Answer
Solved, the problems was the ODBC connector. I have to use the ODBC MySQL 5.1 instead of 3.5, due to my MySQL server uses 5.5.
This solve the problem with the "