This might be  a stupid answer ...

Sounds like ODBC is looking for a Data Source Name ( .DSN ) file. If you 
have MDAC installe,d you can probably right click on your desk top and add 
one. These things are text files which tell the ODBC where the database is, 
whatalias to use, etc.

But that' probably not good enough. When you went into the ODBC settings in 
control panel di you add it under the files, user or system? I'd think the 
latter would be the best bet, as file is probably too specific, user would 
want the web server user, probably "nobody".

But it's even more likely that Andrew Hill will see this and have the 
absolutely correct answer.

Sorry I can't be more helpful than this, but I've not used Access & IIS. 
This is from grubbing around with VB(yuck) .

Cheers - Miles Thompson

At 03:24 PM 11/26/2001 -0800, Mihail Bota wrote:
>Hello,
>
>I know this may be a stupid question, but I've looked everywhere for help
>and since I could not resolve the problem myself, I am asking your help.
>
>The problem is simple: i have an Access 2000 database (Windows 2000,
>IIS5.0) that
>i want to query it using php4.06.
>I've added the database at the ODBC driver, the path to it is okay, but
>when I try to run the simple thing like:
>
>$conn = odbc_connect( 'test' , ' ', ' ' );
>
>where test is the name of that database, then the output is smth. like
>
>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 11
>
>Does anybody have any idea why this thing is happening and how I can solve
>the problems?
>
>Thanks!
>Mihai
>
>
>--
>PHP Windows 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]
>
>
>
>--
>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]


-- 
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]

Reply via email to