Hello, Ia m trying to implement my procedures with the ODBC connections to a mysql server.
I did it on XP but I have some problems on linux (debian)
It seems that it work, but I cannot find the right sources
here the ODBC.ini
######################
[MySQL]
DESCRIPTION = mysql driver 3.51
DRIVER = MySQL
SERVER = localhost
PORT = 3306
USER = root
Password = *****
Database = my_database
######################
and the odbcinst.ini
######################
[MySQL]
DESCRIPTION = MySQL Database connect
DRIVER = /usr/lib/odbc/libmyodbc.so
Setup = /usr/lib/odbc/libodbcmyS.so
FileUsage = 1
######################
First question is, I found several odbc.ini and odbcinst.ini, which one is the right one?
Second: when I ask idl for sources it gives me a list that do not correspond to the odbc.ini, from where it takes the values?
IDL> objDB=OBJ_NEW('IDLdbDatabase')
IDL> sources=objDB->GetDatasources()
% Loaded DLM: DATAMINER.
print,sources.datasource,format='(a)'
S1000
00000
%02u.%02u.%02u%02u
\
odbccurs.so
odbccurs.so
ODBC
DSN
DRIVER
UID
PWD
FILEDSN
SAVEFILE
APPCODEPAGE
ACP
IANAAPPCODEPAGE
IACP
DRIVERUNICODETYPE
I have a 64B computer, so I run Idl with the option -32. I cannot run the command dialog_DBconnect() because it answers me "Segmentation fault"
An "isql MySQL" command returns correct values
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>
Could you help me on connecting to the database?
Thank you
|