Arch Linux

mico

Member

From: Slovenia

Registered: 2004-02-08

Posts: 247

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

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.