access file path question

[middletree]

I usually use SQL Server, but have occasionally had to use Access. This is
such an occasion. My research, mainly at aspfaq.com, has been that you need
to put the file path in your connection string, like this (watch out for the
wrap):

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\mydirectoryname\dbname.mdb;User Id=xxxxx;Password=xxxxxxx;"
Well, the host of this new site I am working on is asking me if a relative
path will work. I don't think it will, but thought I should ask.

And please, I know that Access is not a good choice, but it needs to be this
way in this case.

[Peter Foti]

"middletree" <mi********@htomail.com> wrote in message
news:ec**************@TK2MSFTNGP10.phx.gbl...

I usually use SQL Server, but have occasionally had to use Access. This is
such an occasion. My research, mainly at aspfaq.com, has been that you need to put the file path in your connection string, like this (watch out for the wrap):

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\mydirectoryname\dbname.mdb;User Id=xxxxx;Password=xxxxxxx;"
Well, the host of this new site I am working on is asking me if a relative
path will work. I don't think it will, but thought I should ask.

I believe it needs to be a path like the one you listed, but you could also
use the MapPath function to get the full path to the file.
Hope this helps.
Peter Foti

[Peter Foti]

"Peter Foti" <pe***@Idontwantnostinkingemailfromyou.com> wrote in message
news:10*************@corp.supernews.com...

"middletree" <mi********@htomail.com> wrote in message
news:ec**************@TK2MSFTNGP10.phx.gbl...

I usually use SQL Server, but have occasionally had to use Access. This is such an occasion. My research, mainly at aspfaq.com, has been that you need

to put the file path in your connection string, like this (watch out for

the

wrap):

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\mydirectoryname\dbname.mdb;User Id=xxxxx;Password=xxxxxxx;"
Well, the host of this new site I am working on is asking me if a relative path will work. I don't think it will, but thought I should ask.

I believe it needs to be a path like the one you listed, but you could

also use the MapPath function to get the full path to the file.

Meant to include this link:
http://www.devguru.com/Technologies/...r_mappath.html

Regards,
Peter Foti

[Imran Salahuddin Khan]

why don't you use server.mappath???? like below

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="&server.mappath("relativepath")&";User
Id=xxxxx;Password=xxxxxxx;"

relative path may be any relative path of your access db...

!mran Khan

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Jeff Cochran]

On Thu, 11 Mar 2004 13:12:05 -0600, "middletree"
<mi********@htomail.com> wrote:

I usually use SQL Server, but have occasionally had to use Access. This is
such an occasion. My research, mainly at aspfaq.com, has been that you need
to put the file path in your connection string, like this (watch out for the
wrap):

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\mydirectoryname\dbname.mdb;User Id=xxxxx;Password=xxxxxxx;"
Well, the host of this new site I am working on is asking me if a relative
path will work. I don't think it will, but thought I should ask.
Relative path works, placing the MDB in the same folder (no path)
works and Server.MapPath works. Depending on what your ISP allows and
where the database is located.
And please, I know that Access is not a good choice, but it needs to be this
way in this case.

Access is fine, provided you understand and can live with its
limitations.

Jeff

[middletree]

can't seem to make it work.

Here's my entire code for this include file, and the only thing I changed
here is the ID and password:

strConnection =
"Provider=Microsoft.Jet.OLEDB.4.0;DataSource="&ser ver.mappath("\")"&shape.md
b;User Id=x;Password=x;"

filePath = Server.MapPath("shape.mdb")

I did this because the Access db is in the same folder as the page which
calls it (not the include file, but the page which calls the include)

The error I get now is:
Expected end of statement

/gracearlingtoncom/shape/includes/shapedbinc.asp, line 5

strConnection =
"Provider=Microsoft.Jet.OLEDB.4.0;DataSource="&ser ver.mappath("\")"&shape.md
b;User Id=admin;Password=;"
----------------------------------------------------------------------------
------^In case the wrap is messing things up for you, the arrow is pointing
to the quote mark right after the closing parenthesis.
"Imran Salahuddin Khan" <it***********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

why don't you use server.mappath???? like below

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="&server.mappath("relativepath")&";User
Id=xxxxx;Password=xxxxxxx;"

relative path may be any relative path of your access db...

!mran Khan

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Peter Foti]

"middletree" <mi********@htomail.com> wrote in message
news:uZ**************@TK2MSFTNGP10.phx.gbl...

can't seem to make it work.

Here's my entire code for this include file, and the only thing I changed
here is the ID and password:

strConnection =
"Provider=Microsoft.Jet.OLEDB.4.0;DataSource="&ser ver.mappath("\")"&shape.md b;User Id=x;Password=x;"

Try this:
strConnection =
"Provider=Microsoft.Jet.OLEDB.4.0;DataSource="&ser ver.mappath("\shape.md
b")&";User Id=x;Password=x;"
Regards,
Peter Foti

[middletree]

Looks like it got past that problem. Now, I have to go research what this
means:

Microsoft JET Database Engine error '80004005'
Could not find installable ISAM.

/gracearlingtoncom/shape/list.asp, line 37

thanks


"Peter Foti" <pe***@Idontwantnostinkingemailfromyou.com> wrote in message
news:10*************@corp.supernews.com...

Try this:
strConnection =
"Provider=Microsoft.Jet.OLEDB.4.0;DataSource="&ser ver.mappath("\shape.md
b")&";User Id=x;Password=x;"