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
At 05:52 AM 6/26/01 -0400, [EMAIL PROTECTED] wrote:
>Thanks for the reply.
>
>When it didn't work, I downloaded and installed the mdac 2.6 and
>the up to date jet service pack. Still no joy.
>
>$DBConn is coming back as integer 1 so that seems ok.
>
>I have tested the DSN using MSQuery and it is connecting ok.
>I have also turned tracing on for the dsn and the trace says
>that it connects successfully but then nothing else.
>
>I am a bit lost after this. Anyone any suggestions?
>
>Thanks,
>
>Colum
>
>Original Message:
>-----------------
>From: [EMAIL PROTECTED] (Miles Thompson)
>Date: Mon, 25 Jun 2001 18:22:52 -0300
>To: [EMAIL PROTECTED], [EMAIL PROTECTED]
>Subject: Re: [PHP-DB] Database access using ODBC
>
>
>Colum,
>
>Did you check out www.php.net/odbc_Exec
>
>One of the solutions posted in the comments was to download and install a
>new ODBC driver from MSFT. Are you getting a valid integer returned to
>$DBConn?
>
>NOt worked with this, but I hope those are helpful suggestions - Miles
>Thompson
>
>At 08:38 AM 6/25/01 -0400, [EMAIL PROTECTED] wrote:
> >Hi,
> >
> >Long time reader, first time poster! I am new to php coming from
> >a generally MS (unfortunately) background (Access, VB, SQLServer)
> >and I am looking to branch out a bit.
> >
> >I have a client who wishes to have an internet front-end to an
> >Access database. I am using php with odbc to access this and (as
> >I am a newbie), I am having problems with the connection. After
> >I do an odbc_pConnect, when I call the odbc_exec, I get the usual
> >error, Warning: Supplied agrument is not a valid ODBC-Link resource.
> >
> >The ODBC DSN is setup as standard (no default login etc). The
> >following code is being used for db access:
> >
> >function DBRetrieve($pSQLStr)
> >{
> > global $DBConn, $DBQryID, $DBQryRows, $DBQryColumns;
> >
> > $DBDsn='PHPTEST';
> > $DBUser='Admin';
> > $DBPassword ='';
> >
> > #Open a persistent connection to the database
> > if (!$DBConn = (odbc_pConnect($DBDsn, $DBUser, $DBPassword) or
> > die("Database Execution Error: " . odbc_Error() . " " . odbc_ErrorMsg())))
> > {
> > echo "\nError connecting to database\n";
> > return false;
> > }
> >
> > #Send query to database
> > if (!$DBQryID=(odbc_Exec($DBConn, $pSQLStr) or die("Database Execution
> > Error: " . odbc_Error() . " " . odbc_ErrorMsg())))
> > {
> > echo "\nError executing database request: [ODBC_EXEC]\n";
> > DBDestroy();
> > return false;
> > }
> >
> > #Get no of rows in recordset
> > if (!$DBQryRows=(odbc_num_rows($DBQryId) or die("Database Execution
> > Error: " . odbc_Error() . " " . odbc_ErrorMsg())))
> > {
> > echo "\nError executing database request: [ODBC_NUM_ROWS]\n";
> > DBDestroy();
> > return false;
> > }
> >
> > #Get number of fields to display
> > if (!$DBQryColumns=(odbc_num_fields($DBQryId) or die("Database
> > Execution Error: " . odbc_Error() . " " . odbc_ErrorMsg())))
> > {
> > echo "\nError executing database request: [ODBC_NUM_FIELDS]\n";
> > DBDestroy();
> > return false;
> > }
> >
> > return true;
> >}
> >
> >Does this look ok to you more experienced guys? Am I missing
> >something or is there a better way?
> >
> >Thanks.
> >
> >Colum
> >
> >--------------------------------------------------------------------
> >Mail2Web - Check your email from the web at
> >http://www.mail2web.com/ .
> >
> >
> >--
> >PHP Database 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]
>
>
>--------------------------------------------------------------------
>Mail2Web - Check your email from the web at
>http://www.mail2web.com/ .
>
>
>--
>PHP Database 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]
--
PHP Database 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]