Dear All, I created a system DSN using Microsoft Access (named task). Then I created a PHP file which included the following lines only, --------------------------------------------------------------------------------------- <?php $connection= odbc_connect("DSN=task","fahim","fahim") or die ("Couldn't connect to the datasource."); ?> ---------------------------------------------------------------------------------------
When I try to view the page on my browser, the browser throws the following error, Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:\inetpub\wwwroot\test.php on line 2 Couldn't connect to the datasource Note: I can easily access the database when I use the DSN with ASP. I use windows 2000 advanced server and IIS is my web server. What can I do for getting rid of the error. thank you, FAhim