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"
>
> Timocea" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> 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:[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:
> > > 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
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"
, <[EMAIL PROTECTED]>
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:[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:
> 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)
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:
> 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
