RE: SQL state S1090: Almost connected to mysql via PHP/odbc

Hi, > -----Original Message----- > From: mweb [mailto:mweb@inwind.it] > Sent: Sunday, December 02, 2001 2:03 PM > To: mweb@inwind.it; php-general@lists.php.net; mysql@lists.mysql.com > 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 <venu@mysql.com> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com