This topic is locked

Could not use '(unknown)'; file already in use.,

2/21/2008 11:15:17 AM
PHPRunner General questions
D
dunga author

odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use., SQL state S1000 in SQLConnect

.
Upon advise of the admins I decided to try out the PHP runner 4.1
and here is the problem.
I have IIS installed and working

I have installed php 5.2 working and tested("hello word!!!<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=7628&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />" runs smoothly.
I have setup simple database with 1 table:
ID -autonumber

Image - text

Description -text
I have used the PHP runner for the first time and set the follwing screens:



Database type:
MS Access ODBS (third selection on the screen)
Conect to MS Access: There I have a problem:

There are 2 ODBC data sources present and are not removable:Why are they non removable?what purpose do they serve?
I clicked add DSN and added my test.mdb
and have now
CCInternet

CCIntranet

test --my database to be tested
Clicked Refresh and go to the next screen.
Datasource Tables:

the only table i have in mdb is cheched,ok.
In the visual editor Image filed is set in the Add/Edit dialogs as FILE.

and in a view as as Image with display thumbnails checked by default.
PROBLEM:
It does not work on my IIS and gives me this error,

odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use., SQL state S1000 in SQLConnect

.

Error file F:\My Documents\phptesting\banknotes\output\include\dbconnection.php
and does not work on demo account: dispalying NOTHING at all, like I reached the end of the internet. nothing, no reactions, no action. Can you help?
sorry this was supposed to be published in the PHP runner section, I apologize, can you move it there and help me out please?

J
Jane 2/22/2008

Hi,
this error message means that database is open in another application. I recommend to close PHPRunner and Access and refresh this page in the browser.

D
dunga author 2/22/2008

h, Jane, I did what you asked and still have same problem.
BLANC page --when i am uploading to the demo account
and same error as above.

D
dunga author 2/24/2008

hi, Jane, what is wrong :
I stopped IIS.

I restarted IIS

I closed access.

I closed PHP runner.

I copied project forlder to Inetpub

I changed permissions to allow read/write/execute everything possible

PHP is WORKING on my machine : I tested it.
but when I run PHP runner project it gives me the same problem.
I opened dbconnection.php in DW and here is the line 7
$conn = odbc_connect($dsn,$uid,$pwd);
what can be wrong?????

Alexey 2/26/2008

Hi,
what operating system do you use ?

D
dunga author 2/26/2008

hi, windows XP sp2
on my localhost after trying PHPrunner 4x nothing works....<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=26362&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />(((

Alexey 2/26/2008

Hi,
there are no known problems with Access and Windows XP.

Try to publish your project on Demo Account (last tab in PHPRunner).

Does it work there ?
Try to grant Full Control permissions to Everyone on your database file and a folder where the file resides.
Contact support team directly at support@xlinesoft.com

Send your problem description there.

admin 2/26/2008

Create a new project and build it brand new directory.

If something doesn't work post your application to demo account and send the URL to support@xlinesoft.com.

D
dunga author 2/26/2008

a strange thing happened today,

I follwoed advise of the admin, and started from scratch: on DEMO account it WORKED, but
look what happened next:
I clicked open the output folder to discover that the MDB database is missing how come???

I tried to locate it, but there was none...
but second ago, when testing on the demo account it worked:
could you explain where the php runner store the daabase?

D
dunga author 2/26/2008

i think i figured out why i have a problem:
the PHP runner somehow does not generate the database file...on a local machine
but it does create one on the demo account.

how can this be corrected?