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.
"Sviss Cobazor" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I'm not sure this will help you but when I had to make some odbc_connect I
> had major trouble too. The username and password for the db I was trying
to
> reach were both = "".
> It turned out that this was the problem in my case. I had to create a
> username and a password other than "" to make it work. Like if
odbc_connect
> wanted somthing else than empty strings, beats me.
>
> ~ Sviss
>
> "Sebastian Timocea" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > 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 Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
