odbc_connect(): SQL error: , SQL state 00000 in SQLConnect in...

[Jean-Claude MONOT]

Hi,

i have a MS Access database X, i'm using EasyPHP, ODBC is running, and my
php file contains :
$user = "root";
$pass = "";
$base = "X";
$idf = odbc_connect($base, $user, $pass);

and the result is :

Warning: odbc_connect(): SQL error: , SQL state 00000 in SQLConnect in
c:\documents and settings\...\test.php on line 16

Why ? How to correct the problem ?
Help me please.

Thanks.

Jean-Claude

[Ted Thibodeau Jr]

[[ This message was both posted and mailed: see
the "To," "Cc," and "Newsgroups" headers for details. ]]

In article <41584fae$0$726$8fcfb975@news.wanadoo.fr>, Jean-Claude MONOT
<jean-claude.monot@wanadoo.fr> wrote:

> Hi,
>
> i have a MS Access database X, i'm using EasyPHP, ODBC is running, and my
> php file contains :
> $user = "root";
> $pass = "";
> $base = "X";
> $idf = odbc_connect($base, $user, $pass);
>
> and the result is :
>
> Warning: odbc_connect(): SQL error: , SQL state 00000 in SQLConnect in
> c:\documents and settings\...\test.php on line 16
>
> Why ? How to correct the problem ?
> Help me please.
>
> Thanks.
>
> Jean-Claude

You need an ODBC DSN "X", not an MS Access DB "X".

You only need $user and $pass values if the MS Access DB has access
restrictions set up.

Good luck,

Ted

--
A: Yes. [url]http://learn.to/attribute[/url]
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?

Ted Thibodeau, Jr. // voice +1-781-273-0900 x32
Evangelism & Support // mailto:tthibodeau@openlinksw.com
OpenLink Software, Inc. // [url]http://www.openlinksw.com/[/url]
[url]http://www.openlinksw.com/weblogs/uda/[/url]
OpenLink Blogs [url]http://www.openlinksw.com/weblogs/virtuoso/[/url]
[url]http://www.openlinksw.com/blog/~kidehen/[/url]
Universal Data Access and Virtual Database Technology Providers