RE: [PHP-DB] problems in connecting Access database
Mihail, > >$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 Miles is correct with regards to using a System DSN. Other things that can cause that error include mispelling the DSN name, etc. but you don't appear to be using a DSN yet. Create one in the ODBC Administrator (the ODBC Driver Manager) using the MS Driver for Access and you should be all set. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers -- 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]
Re: [PHP-DB] problems in connecting Access database
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]
[PHP-DB] problems in connecting Access database
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]