Connection Error

[liquidchild]

I am having problems while trying to connect to MS access
I have the following code:

$conn = odbc_connect( 'kerrandsmith', 'admin', 'admin' );

but am getting the following error:

Warning: SQL error: , SQL state 00000 in SQLConnect in C:\Intranet\temp\odbcConn.php on line 8

Does anyone know what is being done wrong - I have set a system and user DSN called kerrandsmith.

Thanks

[bastien]

user and password data with it

try

$conn = odbc_connect( 'kerrandsmith', '', '' );