Hello,
thanks to the precious suggestions I had on this list some day ago, I have
made some progresses, or at least have something new to report.
I would like to ask now above the error mentioned in the subject, because I
have not found it inside www.,mysql.com
I have a database called m97. It *is* listed when I run "show databases" in
themysql monitor. It *shows* when I run isql -v m97.
I have modified /etc/odbc.ini and /etc/odbcinst.ini and /etc/odbc.ini as
follows:
/etc/odbc.ini
[m97]
Trace = On
TraceFile= stderr
Driver = /usr/lib/libmyodbc.so
DSN = m97
SERVER = localhost
USER = test
PASSWORD = gee
PORT = 3306
OPTIONS = 1
DATABASE= m97
SOCKET = /tmp/mysql.sock
#############################################
/etc/odbcinst.ini
# From the MyODBC package
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc.so
FileUsage = 1
In the PHP file I have:
putenv("LD_LIBRARY_PATH=/usr/lib/");
putenv("ODBCINSTINI=/etc/odbcinst.ini");
putenv("ODBCINI=/etc/odbc.ini");
$DSN="m97";
$cnx = odbc_connect( $DSN , 'test', 'gee' );
The result in netscape is still:
Warning: SQL error: [unixODBC][TCX][MyODBC]Invalid DSN specified, SQL state
S1090 in SQLConnect in
/home/mweb/public_html/test.php on line 360
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
