473,379 Members | 1,312 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,379 software developers and data experts.

PHP MsAccess ODBC Connection to database on Networked Volume

I have an IIS 6.0, 2003 Server running with PHP installed.

I have an access database with a DSN ODBC connection configured.

When this ODBC is configured to access the database locally - great,
works fine.
When configured to access a remote copy of this database I get the
following :

"....Warning: odbc_connect() [function.odbc-connect]: 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\PI\getdata.php on
line 3...."

I have tried to set permissions on the database stored on the
networked volume to allow the 'IUSR_servername' user on the web-server
to have rights but am unable. I've tried giving 'everyone' the full
rights to the database all to no avail.

Getting to the stage where I'm going to ask the end user to copy their
database permanantly to the server where the PHP page lives, and give
them a shortcut to it .... but .... it's reaally reaally annoying me
now and I'd like to sort it out properly.

Thanks for any help

Sep 20 '07 #1
4 6459

"Rodent" <de******@gmail.comwrote in message
news:11**********************@19g2000hsx.googlegro ups.com...
>I have an IIS 6.0, 2003 Server running with PHP installed.

I have an access database with a DSN ODBC connection configured.

When this ODBC is configured to access the database locally - great,
works fine.
When configured to access a remote copy of this database I get the
following :

"....Warning: odbc_connect() [function.odbc-connect]: 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\PI\getdata.php on
line 3...."

I have tried to set permissions on the database stored on the
networked volume to allow the 'IUSR_servername' user on the web-server
to have rights but am unable. I've tried giving 'everyone' the full
rights to the database all to no avail.

great! all of that *needed* to be done. however, the error message is not
related to file permissions. what you need to do now, is open up the db on
the network volume in *access*. once open, you need to set the options for
it (tools...options). next, go to the 'advanced' tab and set the 'default
open mode' to shared. close access. finally, go the the network volume where
the .mdb file is. once there, delete all .ldb files. then give it a go.

btw, afaicr, you can also massage some of that in your odbc config and/or
connection string.

i should state that you should *always* use a connection string instead of
actually creating a DSN for access. further, only use access db's when you
plan to have access provide the gui interface as well. mysql (and just about
any other db engine) beats the snot out of ms access in terms of speed,
reliability, and capacity. you'll find that out as soon as you get 2 users
simultaneously hitting it and your mdb file size gets to about 1MB.

but, that's just my 0.02 usd
Getting to the stage where I'm going to ask the end user to copy their
database permanantly to the server where the PHP page lives, and give
them a shortcut to it .... but .... it's reaally reaally annoying me
now and I'd like to sort it out properly.
that would require you to NOT use ms access. ;^)
Sep 20 '07 #2
Normally work with PHP, FreeBSD and MySQL .... any problems can
usually be solved with the aid of google and a few good people like
your self. Unfortunately the user who I'm creating a 'nice browser
based front-end' for doesn't want to migrate her database to something
strange and wonderful like that.

Unfortunately I'm stuck with access and the settings you've just
suggested still give me the same error :-)

Any other suggestions will be gratefully received.... however I'm
getting closer and closer to just copying the bloody thing onto the
server and being done with it. Amazing how 'simple' jobs take s
long :-)

Cheers

Sep 20 '07 #3

"Steve" <no****@example.comwrote in message
news:0o***********@newsfe02.lga...
>
"Rodent" <de******@gmail.comwrote in message
news:11**********************@19g2000hsx.googlegro ups.com...
>>I have an IIS 6.0, 2003 Server running with PHP installed.

I have an access database with a DSN ODBC connection configured.

When this ODBC is configured to access the database locally - great,
works fine.
When configured to access a remote copy of this database I get the
following :

"....Warning: odbc_connect() [function.odbc-connect]: 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\PI\getdata.php on
line 3...."

I have tried to set permissions on the database stored on the
networked volume to allow the 'IUSR_servername' user on the web-server
to have rights but am unable. I've tried giving 'everyone' the full
rights to the database all to no avail.


great! all of that *needed* to be done. however, the error message is not
related to file permissions. what you need to do now, is open up the db on
the network volume in *access*. once open, you need to set the options for
it (tools...options). next, go to the 'advanced' tab and set the 'default
open mode' to shared. close access. finally, go the the network volume
where the .mdb file is. once there, delete all .ldb files. then give it a
go.

btw, afaicr, you can also massage some of that in your odbc config and/or
connection string.

i should state that you should *always* use a connection string instead of
actually creating a DSN for access. further, only use access db's when you
plan to have access provide the gui interface as well. mysql (and just
about any other db engine) beats the snot out of ms access in terms of
speed, reliability, and capacity. you'll find that out as soon as you get
2 users simultaneously hitting it and your mdb file size gets to about
1MB.

but, that's just my 0.02 usd
>Getting to the stage where I'm going to ask the end user to copy their
database permanantly to the server where the PHP page lives, and give
them a shortcut to it .... but .... it's reaally reaally annoying me
now and I'd like to sort it out properly.

that would require you to NOT use ms access. ;^)
Are you specifying a UNC path to the db-file? Or do you use a network share
with drive letter?
I vaguely remember one of the 2 didnt work.
Google probably remembers better than me.

Richard.
Sep 21 '07 #4

"Richard" <root@localhostwrote in message
news:46***********************@news.euronet.nl...
>
"Steve" <no****@example.comwrote in message
news:0o***********@newsfe02.lga...
>>
"Rodent" <de******@gmail.comwrote in message
news:11**********************@19g2000hsx.googlegr oups.com...
>>>I have an IIS 6.0, 2003 Server running with PHP installed.

I have an access database with a DSN ODBC connection configured.

When this ODBC is configured to access the database locally - great,
works fine.
When configured to access a remote copy of this database I get the
following :

"....Warning: odbc_connect() [function.odbc-connect]: 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\PI\getdata.php on
line 3...."

I have tried to set permissions on the database stored on the
networked volume to allow the 'IUSR_servername' user on the web-server
to have rights but am unable. I've tried giving 'everyone' the full
rights to the database all to no avail.


great! all of that *needed* to be done. however, the error message is not
related to file permissions. what you need to do now, is open up the db
on the network volume in *access*. once open, you need to set the options
for it (tools...options). next, go to the 'advanced' tab and set the
'default open mode' to shared. close access. finally, go the the network
volume where the .mdb file is. once there, delete all .ldb files. then
give it a go.

btw, afaicr, you can also massage some of that in your odbc config and/or
connection string.

i should state that you should *always* use a connection string instead
of actually creating a DSN for access. further, only use access db's when
you plan to have access provide the gui interface as well. mysql (and
just about any other db engine) beats the snot out of ms access in terms
of speed, reliability, and capacity. you'll find that out as soon as you
get 2 users simultaneously hitting it and your mdb file size gets to
about 1MB.

but, that's just my 0.02 usd
>>Getting to the stage where I'm going to ask the end user to copy their
database permanantly to the server where the PHP page lives, and give
them a shortcut to it .... but .... it's reaally reaally annoying me
now and I'd like to sort it out properly.

that would require you to NOT use ms access. ;^)

Are you specifying a UNC path to the db-file? Or do you use a network
share with drive letter?
I vaguely remember one of the 2 didnt work.
Google probably remembers better than me.
probably me too. i always used a unc since that's one less thing i'd have
had to remember to do when i moved to production (map a drive and all).
Sep 21 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Graham | last post by:
I need a SQL Server or ODBC package for Python. Can anyone help please? Have search the Python packages under Database and there is no reference to either SQL Server or ODBC. Thanks Graham
3
by: Richard Muller | last post by:
Hi All, I've got the ASP script shown below that complains as follows: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Data source name not found and no default driver specified...
2
by: Len Kowalik | last post by:
MSAccess 2000, SQL-Server 97 I am getting a permission denied response from an attempt to execute a stored proc, which has public access revoked and app role access, on the last statement of the...
0
by: Krzysiek | last post by:
Hi, I have the application (VB6 using RDO) dealing with MSAccess database. This application use/prints reports build on CrystalReport. Report data are fetched from AS400 (via ODBC) and put in...
115
by: TheAd | last post by:
At this moment I use MsAccess and i can build about every databound application i want. Who knows about a serious open source alternative? Because Windows will be a client platform for some time, i...
5
by: Alec | last post by:
Hi All, I am currently trying to link in Access 97 to a table in a MSSQL 7 server. Initially the link is fine, however, when I close the access database and re-open it from the same network...
9
by: laredotornado | last post by:
Hello, I am tasked with converting an MsAccess db to a MySQL 4 db in a Linux environment. Can anyone recommend any good freeware/scripts to help me do this? Thanks, - Dave
6
by: odbcmsaccess | last post by:
hi i 'm writng a code using msaccess with odbc. my dsn name is htgry i want to insert data eneterd in text fields to a table named qwer on clicking a command button. code as follows ...
21
by: adjo | last post by:
I am working on an app with an Access2002 frontend and Sql2005 backend. I have to use integrated security. I want to prevent my users from altering data in another way than via the frontend. It...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.