Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 200003

[PHP3] ODBC_EXEC + MySQL From: Ram Rajadhyaksha (ramr <email protected>)
Date: 03/31/00

Hi. I'm trying to access a MySQL (Linux x86) server from an NT box running IIS
4 and PHP3.

Whenever I run odbc_exec() with a query, I always get a false result.

I have verified that the DSN is correctly configured and that this is not a
MySQL user privilege issue. To test this, I used the DSN to link to the MySQL
server in Access and it worked fine.

Strangely enough, the odbc_connect() call completes successfully and appears
to be working. It's just the exec statement that doensn't work.

I've tried various forms of queries, ie "SELECT * FROM <table>" and even tried
with the terminating semi-colon to see if that would make a difference.

Any ideas? I couldn't find this in the faq anywhere...

Ram Rajadhyaksha
DLZ Corporation
www.dlzcorp.com 

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>