php-db | 2001062

RE: [PHP-DB] Database access using ODBC From: Andrew Hill (ahill <email protected>)
Date: 06/27/01

Colum,

What does the ODBC trace show right after connection, and any subsequent
calls?

Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers

> -----Original Message-----
> From: Miles Thompson [mailto:milesthompson <email protected>]
> Sent: Tuesday, June 26, 2001 1:55 PM
> To: chickey <email protected>; php-db <email protected>
> Subject: Re: [PHP-DB] Database access using ODBC
>
>
> Colum,
>
> Did you try it, stripping out all of your error testing code,
> just doing a
> simple query, such as a "Select * from tablename"?
>
> You could also try searching the archives of the list for these two names:
> Andrew Hill, who works for OpenLink, a company which builds ODBC drivers.
> and
> Manuel Lemos who has developed what I believe is a fairly decent class of
> database objects.
>
> My problem is that I have no experience using ODBC within PHP, so I don't
> have any direct hints except to divide and conquer. In other
> words, if you
> are getting a connection, then try a simple query, making certain, by
> echoing it, that it looks OK. Check the error that's thrown and diagnose
> from there.
>
> Have you tried odbc_connect? Have you checked all the comments in the
> online manual against what you're doing? (I know that sounds like
> hectoring, but I once made a 180 mile round trip service call
> because I was
> too stubborn to check a piece of network cable.) :<(
>
> One thing I am certain of, the fix, when you find it, will
> probably be trivial.
>
> Keep plugging, dividing and conquering - Miles
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>