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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
