plz help...

[stezz]

Im trying to connect to an access db via odbc. When I query the db for infomation, I get the following error...

Warning: SQL error: [Microsoft][ODBC Microsoft Access 97 Driver] Can't open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt., SQL state S1000 in SQLConnect in D:\WWWRoot\patterson\tblusers.php on line 7
Connection failed: Cannot connect to access database.

Is this something to do with permissions on the db file or something? Me and my teacher have checked the permissions and I have "Full Control" on them in the directory it is stored in. I am using a school network (btw).

Can anybody help?

Regards, Stezz.

[Duey]

'(unknown)' it doesnt know what database to select.
i dont know anything about odbc but
odbc_connect("DSN=DataSource;UID=UserName;PWD=Password","","");
try that.

also refer here:
http://www.php.net/manual/en/function.odbc-connect.php