RE: [PHP] PHP + ODBC on IIS (Win2k)

Sebastian, This may be an IIS configuration issue, a database perms issue, or an NT config issue. Here are the MS knowledgebase articles that are relevant. http://support.microsoft.com/default.aspx?scid=kb;EN-US;q166029 http://support.microsoft.com/support/kb/articles/Q174/9/43.ASP http://support.microsoft.com/support/kb/articles/Q253/6/04.ASP http://support.microsoft.com/support/kb/articles/Q183/0/60.ASP Hope this helps. Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Internet Data Integration Server > -----Original Message----- > From: Sebastian Timocea [mailto:stimocea@uttgm.ro] > Sent: Wednesday, February 27, 2002 3:31 AM > To: Andrew Hill > Subject: Re: [PHP] PHP + ODBC on IIS (Win2k) > > > The major problem is that it works perfectly fine when I use the > same thing > with the Apache web server. > > I have installed both IIS and Apache on my computer (Windows 2000 Advanced > Server) and I configured PHP to work with both of them. Of course I can't > keep both web servers working in the same time and on the same port (80). > So, when I use Apache, I turn off IIS and viceversa. I have configured the > same webdirectories so I won't have problems accessing web > applications. PHP > works fine with both webservers except with connecting to ODBC. > > Running Apache this code works PERFECTLY FINE (no errors): > <?php > odbc_connect("DBTest", "", ""); > ?> > > but running IIS 5 it will give me a horrible error: > "Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] > The Microsoft > Jet database engine cannot open the file (unknown)'. It is already opened > exclusively by another user, or you need permission to view its data., SQL > state S1000 in SQLConnect in C:\inetpub\wwwroot\directory\Test.php on line > 3" > > I checked out everything and I don't have any "exclusive" settings on my > ODBC data sources. > > Sebastian Timocea. > > ----- Original Message ----- > From: "Andrew Hill" <ahill@openlinksw.com> > To: <ignacio.estrada@cfe.gob.mx>; <stimocea@uttgm.ro>; > <php-general@lists.php.net> > Sent: Tuesday, February 26, 2002 5:39 PM > Subject: RE: [PHP] PHP + ODBC on IIS (Win2k) > > > > Ignacio, > > > > He can use Access and local ODBC just fine, as he is on a Windows box. > > > > Actually, the ODBC Socket server isn't needed from Linux either, as > OpenLink > > provides Single-Tier and Multi-Tier ODBC drivers from *nix platforms to > many > > databases. > > > > Best regards, > > Andrew Hill > > Director of Technology Evangelism > > http://www.openlinksw.com/virtuoso/whatis.htm > > OpenLink Virtuoso Internet Data Integration Server > > > > > -----Original Message----- > > > From: ignacio.estrada@cfe.gob.mx [mailto:ignacio.estrada@cfe.gob.mx] > > > Sent: Tuesday, February 26, 2002 10:35 AM > > > To: stimocea@uttgm.ro; php-general@lists.php.net > > > Subject: RE: [PHP] PHP + ODBC on IIS (Win2k) > > > > > > > > > PHP will not work on that way in order to retrieve data from Access > using > > > ODBC. Check the URL: > > > > > > > > > http://www.phpbuilder.com/columns/timuckun20001207.php3 > > > > > > See you !!! > > > > > > Atte. Ignacio Estrada F. > > > Centro Nacional de Control de Energia > > > Area de Control Occidental > > > 025+6463, 025+6464, 025+6469 > > > ----- Remitido por Ignacio Estrada Fonseca/CEN/GDL/CFE con fecha > > > 02/26/2002 > > > 09:34 ----- > > > > > > > > > "Andrew Hill" > > > > > > <ahill@openli Para: "Sebastian > > > Timocea" <stimocea@uttgm.ro>, <php-general@lists.php.net> > > > nksw.com> cc: > > > > > > Asunto: RE: [PHP] > > > PHP + ODBC on IIS (Win2k) > > > 02/26/2002 > > > > > > 08:53 > > > > > > > > > > > > > > > > > > > > > > > > > > > Sebastian, > > > > > > Check your System DSN - "Options" button, and verify that you > don't have > > > "Exclusive" checked off. > > > > > > Hope this helps. > > > > > > Best regards, > > > Andrew Hill > > > Director of Technology Evangelism > > > http://www.openlinksw.com/virtuoso/whatis.htm > > > OpenLink Virtuoso Internet Data Integration Server > > > > > > > -----Original Message----- > > > > From: Sebastian Timocea [mailto:stimocea@uttgm.ro] > > > > Sent: Tuesday, February 26, 2002 9:47 AM > > > > To: php-general@lists.php.net > > > > Subject: [PHP] PHP + ODBC on IIS (Win2k) > > > > > > > > > > > > Hello! > > > > > > > > I am having a really ugly problem here and I hope somebody can > > > > help me with > > > > this. > > > > I work on > > > > - Windows 2000 Advanced Server > > > > - PHP for Windows and IIS (it works ok) > > > > > > > > I have a DBTest.mdb database (Access 2000) and an ODBC > > > connection to this > > > > database: > > > > System DSN="DBTest", no user and password to connect! I have tested > this > > > > ODBC connection with a VBasic simple application and it works just > fine. > > > > > > > > Now I create a Test.php file with this content: > > > > <?php > > > > odbc_connect("DBTest", "", ""); > > > > ?> > > > > > > > > When I open this file in the browser > > > > http://localhost/directory/Test.php? I > > > > get the next error: > > > > "Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] > > > > The Microsoft > > > > Jet database engine cannot open the file '(unknown)'. It is already > > > opened > > > > exclusively by another user, or you need permission to view > its data., > > > SQL > > > > state S1000 in SQLConnect in > C:\inetpub\wwwroot\directory\Test.php on > > > line > > > > 3" > > > > > > > > I have checked everything and the database is not opened by anybody. > > > Plus, > > > > the Security rights are set to enable Everyone and Internet > > > Guest Account > > > > (IUSR_myserver) to have Full Control ont the database. > > > > > > > > So, could anybody help me with this PLEASE?? > > > > :`-( > > > > > > > > Thank you in advance, > > > > Sebastian. > > > > > > > > > > > > -- > > > > PHP General Mailing List (http://www.php.net/) > > > > To unsubscribe, visit: > > > > http://www.php.net/unsub.php > > > > > > > > > > > > > > > > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > >