Hi,
-Original Message-
From: mweb [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 02, 2001 2:03 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: SQL state S1090: Almost connected to mysql via PHP/odbc
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
The problem is that, unixODBC is not able to find your MyODBC
DSN entry. This is probably due to the fact that it is not picking
the right odbc.ini file.
Did you tried by using isql -v m97 to check whether it is
really picking the .ini or not.
For more information on howto setup MyODBC, unixODBC and
MySQL, refer to the following link:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?5:mss:3657:200108:einnhiokafobjmjbmcbm
Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\___\_\___/ California, USA
___/ www.mysql.com
--
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]