RE: problem connecting w/ODBC

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Problem fixed!

Thank you to David who pointed out that I had my variables switched in the
in the odbc_exec and odbc_cursor lines.  For ODBC, the connection variable
comes first (the opposite of MySQL).

Bev

----------------------
Beverly Steiner
steiner277@charter.net


-----Original Message-----
From: Beverly Steiner [mailto:steiner277@charter.net]
Sent: Tuesday, March 18, 2003 1:58 PM
To: PHPDB
Subject: FW:  problem connecting w/ODBC


Hello again,

Does anyone have suggestions about where I can get an answer to the problems
I'm having with ODBC?  I've tried using:
	$cursor = odbc_cursor($connection) || die("cannot create cursor");

and get a similar error:

Warning: odbc_cursor(): supplied resource is not a valid ODBC result
resource in c:\program files\apache group\apache\htdocs\test4.php on line 13
cannot create cursor

Any help would be greatly appreciated.  I've been trying unsuccessfully to
access to an MS Access database with PHP for weeks now.  Any ideas of where
I can get the answer?  I have posted to the PHP-INST and PHP-DB lists.

----------------------
Beverly Steiner
steiner277@charter.net


-----Original Message-----
From: Beverly Steiner [mailto:steiner277@charter.net]
Sent: Friday, March 14, 2003 7:13 PM
To: PHPDB
Subject:  problem connecting w/ODBC


Hello,

I am having problems accessing a database through ODBC.  I first sent an
email describing my problems accessing an MS Access database through PHP.
Today I installed MySQL.  I have no problems accessing my test database with
the mysql commands.  I downloaded MySQL's ODBC driver.  I get the same error
message trying to access this database w/ODBC as I did with the MS Access
database.

I am running Windows XP Professional, PHP 4.3.1, and Apache 1.3.27.

Here's my PHP code:

$connection = odbc_connect("testmysql", "", "")  or die ("Couldn't connect
to the server.");

$sql = "SELECT * FROM member";

$result = odbc_exec($sql,$connection) or die ("Couldn't execute query");

I get the following error message in my browser:

Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in
c:\program files\apache group\apache\htdocs\test4.php on line 17
Couldn't execute query

Anyone have any ideas of what I should do so I can access a database through
ODBC?

----------------------
Beverly Steiner
steiner277@charter.net



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux