Re: Help with connection string
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Mon, 25 Feb 2008 16:31:01 -0500
The connection string looks correct.
Is that E drive accessible to the user account under whose context the
IIS process is running (if your website has Anonymous enabled, that will
usually be the IUSR_MACHINENAME account)? Does that account have Modify
permissions for the folder contining the database file?
Hakk wrote:
I was hoping someone could offer me a bit of help here. I am trying to
connect to an unpassworded Access 2007 database for use in a small
website.
For testing purposes I have everything stored locally, and am using
the following connection string:
ConnectString = "Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=E:\myWebs\htdocs\grahams\data\products.accdb;Persist Security
Info=False;"
All I get when I try to open the website is this:
Microsoft Office Access Database Engine error '80004005'
Unspecified error
/grahams/connection.asp, line 14
the connection.asp file is just this:
Dim conn, ConnectString
ConnectString = "Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=E:\myWebs\htdocs\grahams\data\products.accdb;Persist Security
Info=False;"
Set conn = Server.CreateObject("ADODB.Connection")
response.Write(ConnectString)
conn.open ConnectString
I have tried every combination of file name, and tried to use
server.mappath but I get the same error no matter what.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- Follow-Ups:
- Re: Help with connection string
- From: Hakk
- Re: Help with connection string
- References:
- Help with connection string
- From: Hakk
- Help with connection string
- Prev by Date: Help with connection string
- Next by Date: Re: Help with connection string
- Previous by thread: Help with connection string
- Next by thread: Re: Help with connection string
- Index(es):
Relevant Pages
|
