Re: FN-FORUM Fasthosts -ODBC

date posted 1st August 2000 22:43

Problem seems to be that the script has not mapped the path to the
locationof the db?

Extract from TechNet....

Database Paths
Sometimes, when setting up paths to databases, you do need to use a mapped
drive or UNC path to point to your database. If you need to use one of these
path types and your database resides on the same machine as the Web server,
you will need to set the security settings not only for the folder that
contains the database, but also for the share that the mapped drive points
to. If you are using Anonymous Access on your Web server, IIS will use the
Internet Guest Account (usually IUSR_ServerName) to access those resources.
This account will need full control so that it can access the database and
also create the temporary files associated with an Access database. If the
Internet Guest Account does not have the proper access to the resource, an
error like the one below may occur.

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.
As a troubleshooting measure, you may want to add the following code to the
beginning of your ASP page:



When browsing the ASP page, you should see one of two things. If there is no
user listed, it means the Internet Guest Account is being used to access
your resources. However, if a user is listed, it means that NT Challenge
Response is being used to access the resource. If NT Challenge response is
being used, then you will need to give those users browsing the site access
to the resources.

If your database resides on a different machine than the Web server you will
run into problems with delegation. The article "Authentication and Security
for Internet Developers" describes in depth the security issues that are
caused by this configuration.

Essentially, the delegation issue is resolved by creating a duplicate
Internet Guest Account from the Web Server on the machine where the database
resides. This is needed because the IIS server will try accessing resources
on another machine using the Internet Guest Account. The Knowledge Base
article "HOWTO: Set Up Duplicate Anonymous Account on Separate Server" has
helpful information about setting up this configuration.

Hope this helps?

PS Are you using DNS or DNSless connection string?

Bryan

----- Original Message -----
From: Stephen C Parker [EMAIL REMOVED]
To: [EMAIL REMOVED] Net [EMAIL REMOVED]
Sent: Tuesday, August 01, 2000 11:16 AM
Subject: FN-FORUM Fasthosts -ODBC


> 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
>
>
> ============================================================
>
> * Free listing for freelancers
> * Free to advertise jobs
> * Free jobs distribution service
> * Free database of 1000 freelancers
>
> Freelancers and Freelance Jobs
> http://www.freelancers.net
>
> To post to the Forum:
> [EMAIL REMOVED]
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
> To subscribe to the digest for this list or for further information please
visit:
> http://www.freelancers.net/forum.html