Re: PHP + ODBC

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" <stimocea@uttgm.ro> wrote in message news:20020226112934.70616.qmail@pb1.pair.com... > 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. > > >