MySQL odbc connection remote client
I wish to connect to MySQL using an ODBC connection and I'm using isql to test. On the server connection using isql to local host is sweet however the problem is the client. Okay my set up looks like this
On the server /etc/odbc.ini is
`
[MySQL-scopus2008]
Description = MySQL citation database
Driver = MySQL
Server = localhost
Database = scopus2008
Port = 3306
User = keir
Password = swjsykwim
Socket =
Option =
Stmt =
And the local test look like this
[root@taurinus etc]# isql MySQL-scopus2008
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>
great so far
On my client I can telnet on port 3306 and get a binary type response so I know its not firewall.
odbc.ini is
[MySQL-scopus2008]
Description = MySQL database connector
Driver = {MySQL ODBC 3.51 Driver}
Server = 172.16.176.27
Database = scopus2008
Port = 3306
User = keir
Password = secret
MySQL-scopus2008
isql -v MySQL-scopus2008
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect
strace shows that the ini file is being accessed and read
open("/etc/odbc.ini", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=182, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb764a000
read(3, "[MySQL-scopus2008]\nDescription ="..., 4096) = 182
read(3, "", 4096) = 0
close(3) = 0
munmap(0xb764a000, 4096) = 0
fstat64(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 5), ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb764a000
write(1, "[IM002][unixODBC][Driver Manager"..., 93[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
) = 93
write(2, "[ISQL]ERROR: Could not SQLConnec"..., 34[ISQL]ERROR: Could not SQLConnect
) = 34
I am fairly sure the problem is with the client machine but if anyone has done this or has some suggestions that would be much appreciated
|