Please help!!!! I am trying to get PHP to connect to MS Access db on a win2000 server, but only getting following errors: Warning: SQL error: , SQL state 00000 in SQLConnect in d:\websites\~nit\hello.php on line 7 Warning: Supplied argument is not a valid ODBC-Link resource in d:\websites\~nit\hello.php on line 9 Warning: Supplied argument is not a valid ODBC result resource in d:\websites\~nit\hello.php on line 12 Warning: Supplied argument is not a valid ODBC result resource in d:\websites\~nit\hello.php on line 14 Warning: Supplied argument is not a valid ODBC-Link resource in d:\websites\~nit\hello.php on line 25 I have set up this database in odbc datasources in windows (Both UserDSN and SystemDSN) and am able to access it perfectly using JSP, but will not work with PHP. This is the PHP code I'm using: <html> <body> <p align="center"> <?PHP $Link = odbc_connect("Test", "Admin", "xxxxx"); $Result = odbc_exec ($Link, "SELECT * FROM test"); print(odbc_result($Result,1) . "<br>"); while (odbc_fetch_row($Result) != 0){ print(odbc_result($Result,1) . "<br>"); } odbc_close($Link); ?> </p> </body> </html> The strange thing is that I have actually got all this working perfectly using apache, PHP on a win98 machine. I'm only new to PHP so any assistance or suggestions would be greatfully accepted. Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]