hi..!
i've been looking for the moment to start learing a bit of SQL and since i got that PDF explaining how to use OpenOffice as a gui for it, i decided that moment would be now.. however i'm having trouble making things work the way that howto says it should. i¡ve edited /etc/odbc.ini and /etc/odbcinst.ini so they both look just like the example this document, however the ODBC driver ( i guess that's where the problem is ) can't find the server ( or database? or data source? ) i've searched on google using the error i'm getting as the search query but i didn't find any useful data ( a lot of it was for MS-SQL or was simply referred to other problems, as it looks like it a very common 'newb' misconfiguration ) this is what i'm getting. [root@localhost user]# isql MySQL-test -v [unixODBC][Driver Manager]Data source name not found, and no default driver specified [ISQL]ERROR: Could not SQLConnect my .ini files are: ( the howto refers to these two files only so it looks like it should work by tweaking only these? ) i've checked that all .so files exist and are in place, too. /etc/odbc.ini [SQL-test] Description = SQL database test Driver = MySQL Server = localhost Database = test Port = 3306 Socket = Option = Stmt = /etc/odbcinst.ini [MySQL] Description = ODBC Driver for MySQL Driver = /usr/lib/libmyodbc.so Setup = /usr/lib/libodbcmyS.so FileUsage = 1 CPTimeout = CPReuse = thanks for any ideas that you may have. Damian
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
