The test (using isql) fails, and it's not clear why. Details below... I'm wondering if the Witango people have some info or be able to help?
[EMAIL PROTECTED] etc]# isql -v folklife
[unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect
However I believe the .ini files should be right. And if I use the odbcinst -j (show config) option, it points to these files.
The libmyodbc (driver files) that are installed are: /usr/lib/libmyodbc3-3.51.06.so /usr/lib/libmyodbc3_r-3.51.06.so (the files mentioned below also exist as softlinks to these)
/usr/local/etc/odbcinst.ini: [MySQL] Description = MySQL driver Driver = /usr/lib/libmyodbc3.so Setup = /usr/lib/libmyodbc3_r.so
/usr/local/etc/odbc.ini
[ODBC Data Sources]
myodbc = MySQL ODBC 2.50 Driver DSN myodbc3 = MySQL ODBC 3.51 Driver DSN
(default ones still there plus this one I added:) [folklife] Driver = /usr/lib/libmyodbc3.so Description = MySQL ODBC 3.51 Driver DSN SERVER = localhost PORT = USER = root Password = Database = folklife OPTION = 3 SOCKET =
Also, I tried using the odbcinst program, but that's failing too. Here's the template file I have in my home dir: [MySQL-test] Description = MySQL test database Trace = Off TraceFile = stderr Driver = MySQL SERVER = localhost USER = root PASSWORD = PORT = 3306 DATABASE = test
If I run it (as root) I get this:
odbcinst -i -s -f odbctemplate
odbcinst: SQLWritePrivateProfileString failed with General error request failed.
odbcinst: SQLWritePrivateProfileString failed with General error request failed.
I couln't find anything about the error, there's no man page, and no --help option... ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
