X
PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 31 Jan 2007 03:17 PM by  anon
ODBC sources
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages

anon



New Member


Posts:
New Member


--
31 Jan 2007 03:17 PM
    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

    Deleted User



    New Member


    Posts:
    New Member


    --
    31 Jan 2007 03:17 PM
    Hi Riccardo ! I have the same problem when using the "x = dialog_dbconnect(objDB)", segmentation fault. If you solved this problem, can you post the solution ? Thanks a lot. André Abrantes. andreabrantes@gmail.com
    You are not authorized to post a reply.