By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,659 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,659 IT Pros & Developers. It's quick & easy.

access database on other PC

P: n/a
Excuse me for my english, i'm Italian.
I have iis and asp page on my computer, but the databse (access database) is
on another computer in the same domain.
which connection string i must use ? can we post an example ?

thank's

Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Ciao TrinitÓ,

In a default configuration, ASP pages run under the IIS server's local
account called IUSR_computername. If this user tries to access a share on
another computer, it will be denied access to it, because the other computer
is not familiar with the account computername\IUSR_computername. What you
can do is create an account in your domain, setup your page, application, or
site to use this user instead of IUSR_computername, and then grant that user
the necessary NTFS and share permissions to the share on the other server.
At that point, you'd use a normal Access database connection string, but
you'd use a UNC path to the database, i.e.

sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\FileServerName\ShareName\DatabaseName.mdb ;"

Also, see the "If the file is within your LAN" section here for other
options. http://www.aspfaq.com/show.asp?id=2168

Ray at work

"TrinitÓ" <TrinitÓ@discussions.microsoft.com> wrote in message
news:EF**********************************@microsof t.com...
Excuse me for my english, i'm Italian.
I have iis and asp page on my computer, but the databse (access database)
is
on another computer in the same domain.
which connection string i must use ? can we post an example ?

thank's

Jul 19 '05 #2

P: n/a
"Ray Costanzo [MVP]" wrote:
Ciao Trinit├*,

In a default configuration, ASP pages run under the IIS server's local
account called IUSR_computername. If this user tries to access a share on
another computer, it will be denied access to it, because the other computer
is not familiar with the account computername\IUSR_computername. What you
can do is create an account in your domain, setup your page, application, or
site to use this user instead of IUSR_computername, and then grant that user
the necessary NTFS and share permissions to the share on the other server.
At that point, you'd use a normal Access database connection string, but
you'd use a UNC path to the database, i.e.

sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\FileServerName\ShareName\DatabaseName.mdb ;"

Also, see the "If the file is within your LAN" section here for other
options. http://www.aspfaq.com/show.asp?id=2168

Ray at work

"Trinit├*" <Trinit├*@discussions.microsoft.com> wrote in message
news:EF**********************************@microsof t.com...
Excuse me for my english, i'm Italian.
I have iis and asp page on my computer, but the databse (access database)
is
on another computer in the same domain.
which connection string i must use ? can we post an example ?

thank's



ok thanks !
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.