[PHP-DB] Re: Connecting to MS Access From: David Robley (robleyd <email protected>)
Date: 06/12/02

In article <20020612162345.89280.qmail <email protected>>, wbhk <email protected> says...
> 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

Well, never used ODBC and Access, but shouldn't there be something
somewhere that defines the host on which the DSN may be found? 

-- 
David Robley
Temporary Kiwi!

Quod subigo farinam

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