ODBC - Web Connectivity

date posted 1st August 2000 14:59

Freelancers,
Some of you have written expressing their amiable experience with
fasthosts as their web server. I have registered a domain name and have been
trying to getthe ODBC connectivity to work with my database.

However, I get the following error:

Connection to DSN A1Council Exchange
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[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.

/scripts/asp/testconn.asp, line 16

Who is it already opened by though? I haven't changed any permissions - and
the filename is pointing correctly to the database where it has been
uploaded onto the server.

I have a feeling that this has something to do with the permissions on the
Access 2000 database. If this is the case, I cannot find in the Microsoft
help material - or through plain exploration - where the fault may lie.

The only other possibility I can gather - is that the web server does not
host Access 2000 databases - only Access '97. But, I can't see that being
the case as I have converted the database and it strill has the same
problem.

Any suggestions to get round this permissions problem would be greatly
appreciated.

Sincerely,

Stephen C Parker
[EMAIL REMOVED]
http://www.orbinternet.com
http://www.freelancers.net/scparker/index.html