You are not logged in.

#1 2005-03-25 13:09:19

mico
Member
From: Slovenia
Registered: 2004-02-08
Posts: 241

myodbc and DataManager

I can connect to mysql with isql or DataManager or DataManagerII, but DataManager and DataManagerII form wrong querries. They form sentence:

SELECT "id", "name" FROM table;

instead of:

SELECT id, name FROM table;

The rusult is then

+----+------+
| id | name |
+----+------+
| id | name |
| id | name |
| id | name |
| id | name |
| id | name |
| id | name |
| id | name |
| id | name |
| id | name |
| id | name |
| id | name |
+----+------+

PostgreSQL doesn't care about the quotes and you get the values as result, but MySQL just prints names of columns.

Anybody else noticed this? It seems to me like a bug in unixodbc, but could also be mysql, myodbc or just some archlinux package. Or maybe my faulty config big_smile

What other graphical tools do you use to browse databases? For create, update and insert I just write text files and pass them to server as scripts (or execute statements directly). But for viewing db, tables and rows it is nice to have something graphical.

Offline

Board footer

Powered by FluxBB