RE: [PHP-DB] Connecting to MS Access From: Ryan Jameson (USA) (RJameson <email protected>)
Date: 06/12/02

It is the error message you get when you haven't selected the database file for your DSN. Go to your DSN, click configure, and click the SELECT button on the dsn. :-)

<>< Ryan

-----Original Message-----
From: Ryan Jameson (USA)
Sent: Wednesday, June 12, 2002 1:09 PM
To: php-db <email protected>
Subject: RE: [PHP-DB] Connecting to MS Access

I've duplicated your problem. I know I've had this working before, I'll let you know if I can figure it out. :-)

<>< Ryan

-----Original Message-----
From: Bill Hudspeth [mailto:wbhk <email protected>]
Sent: Wednesday, June 12, 2002 10:22 AM
To: php-db <email protected>
Subject: [PHP-DB] Connecting to MS Access

I am having problems connecting to an Access database. I am using Windows
2000, IIS 4, Access 2000, and PHP 4.2.1. I have created a system DSN using
the Access (.mdb) driver, and have a username and password. What's going
on?? Thanks, Bill

The code I have used is as follows:

************************************************************************

<?php

//connect to database

$connectionstring = odbc_connect("meteoritecatalog", "username",
"password");

//line 14 is immediately above

//SQL Query

$query = "SELECT sample, type FROM sample";

//execute query

$queryexe = odbc_do($connectionstring, $query);

//line 20 above

//output results to standard output

odbc_result_all($queryexe, "BORDER=1");

//line 23 above

//disconnect from the database

odbc_close($connectionstring);

//line 26 above

?>

************************************************************************

The error message I get is:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver]General error
Not enough information to connect to this DSN with SQLConnect. Use
SQLDriverConnect., SQL state S1000 in SQLConnect in
C:\inetpub\wwwroot\PHP\data_tap.php on line 14

Warning: odbc_do(): supplied argument is not a valid ODBC-Link resource in
C:\inetpub\wwwroot\PHP\data_tap.php on line 20

Warning: odbc_result_all(): supplied argument is not a valid ODBC result
resource in C:\inetpub\wwwroot\PHP\data_tap.php on line 23

Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource
in C:\inetpub\wwwroot\PHP\data_tap.php on line 26 

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