[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
RE: [PHP] PHP + ODBC on IIS (Win2k)
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:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 9:47 AM To: [EMAIL PROTECTED] 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
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@openliPara: Sebastian Timocea [EMAIL PROTECTED], [EMAIL PROTECTED] nksw.comcc: 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:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 9:47 AM To: [EMAIL PROTECTED] 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
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 10:35 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] 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@openliPara: Sebastian Timocea [EMAIL PROTECTED], [EMAIL PROTECTED] nksw.comcc: 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:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 9:47 AM To: [EMAIL PROTECTED] 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