Re: ODBC/MySQL Problem with PHP4 on Windows

Standard ODBC calls like this: $conn = odbc_connect("multi", "root", ""); $r = odbc_exec("$conn", "select * from user order by first"); $valid_row = odbc_fetch_row($r,1); All these code works on PHP3. I am just using an Access database on the local machine. The ODBC is configured the same way like before. Did not change when upgraded to PHP4. > ----- Original Message ----- > From: "Jason Bouwmeester" <jason@intervisual.com> > To: "'Weihong Hendricks'" <weihong.hendricks@wcom.com> > Sent: Wednesday, November 22, 2000 10:13 AM > Subject: RE: [PHP] ODBC/MySQL Problem with PHP4 on Windows > > > > Hmmm I have PHP4.03pl1 running on W2K with Apache and the ODBC stuff is > > working fine, I didn't upgrade from PHP3 though so my code was for PHP4 > but > > I couldn't tell you what the difference would be in code, I just used the > > ODBC commands from the PHP.net manual. That error that you are getting, is > > it a SQL error or...? What are you using for your DB, and I am assuming > you > > are connecting to a different machine? > > > > jb > > > > -----Original Message----- > > From: Weihong Hendricks [mailto:weihong.hendricks@wcom.com] > > Sent: Wednesday, November 22, 2000 10:09 AM > > To: PHP Mailing List > > Subject: [PHP] ODBC/MySQL Problem with PHP4 on Windows > > > > > > I have been using PHP 3 on Windows 98/NT with PWS and Apache using ODBC > and > > MySQL with no problem. However when I upgrade to PHP4, all my applications > > blew up, I keep getting "Warning: Supplied argument is not a valid ODBC > > result source in..." and similar messages with MySQL. The applications > won't > > run. Happens both on Apache and PWS on Windows NT and 98. > > > > The same code works on a Linux box running PHP4.03 and a DEC Alpha > machine. > > Therefore, I suspect that the PHP4 binaries (which claims to have ODBC and > > MySQL build-in) in fact has NOT built with ODBC and MySQL support. I might > > be wrong. But please help me to figure out this problem. I have followed > all > > the installation instructions I could find on the web and am stuck here! > > > > Help! I will be sincerely grateful. > > > > >