Try username="admin", password="".
Most databases start off with those u and p settings.
--
Scott Carr
OpenOffice.org
Whiteboard-Doc Maintainer
http://whiteboard.openoffice.org/doc/
Quoting Bill Hudspeth <[EMAIL PROTECTED]>:
> 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 Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
