RE: ODBC

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

 



No, that won't work.  You need to create a system DSN.  Here's what I did to
create one.  My PC is running Windows XP Professional and I am using Apache
1.3.27.

* opened up the control panel

* double-clicked Administrative Tools

* double-clicked Data Sources (ODBC)

* clicked on the System DSN tab

* clicked Add...

* selected Microsoft Access Driver (*.mdb) from the list

* clicked Finish

* typed mctadb in Data Source Name

* clicked on Select...

* selected the MS Access database I wanted to connect to and clicked OK

* clicked on Advance...

* typed in a Login name then clicked OK

* clicked OK in the next 2 windows


I could use some help as well.  I get connected to the database but get an
error when I try to execute a SQL statement on it.

The error message I get is:

Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in
c:\program files\apache group\apache\htdocs\test2.php on line 30
cannot prepare result


Does anyone know what might be missing?  Here's the code from test2.php:

$connection = odbc_connect("mctadb", "admin", "") || die("cannot open
database");

$sql = "SELECT * FROM Meeting";

$result = odbc_exec($connection, $sql) || die("cannot prepare result");

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


-----Original Message-----
From: Kiswa [mailto:Kiswa@telia.com]
Sent: Friday, March 07, 2003 3:24 PM
To: php-db@lists.php.net
Subject:  ODBC


Hi.
Is their anyway to connect to a Access Db using only the filesystem like

$connect = odbc_connect("\Db\Webdb.mdb", "nobody", "nobody");

thus pointing directly to the file not using drivers???



--
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