error in connection string

[rjkealey]

Does anybody see anyhing wrong with this code?
I uploaded the files to server and keep getting error

<%
dim ConnectionString
dim MyConn
dim RS


'set connection string to local variable-I use a DSN-less connection
'ConnectionString = &quot;Provider=Microsoft.Jet.OLEDB.4.0; Data Source=e:/home/default/cmkinc.biz/htdocs/auto/foreclosure.mdb&quot;

ConnectionString= &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\home\default\cmkinc.biz\htdocs\auto\foreclosure.mdb&quot;

'ConnectionString=&quot;Driver={Microsoft Access Driver (*.mdb)}; DBQ=\e:\home\default\cmkinc.biz\htdocs\auto\foreclosure.mdb&quot;

Set MyConn=Server.CreateObject(&quot;ADODB.Connection&quot
Set RS=Server.CreateObject(&quot;ADODB.RecordSet&quot



*******Error Points Here***********************
MyConn.open ConnectionString
%>

Microsoft JET Database Engine error '80004005'

Unspecified error

/auto/databaseconnect.asp, line 21

This works great on localhost but when I upload it to hosting server gets error connecdting?
I have tried several different ways to connect still no luck

RJKealey

 

[onpnt]

cahnge this
Driver={Microsoft Access Driver (*.mdb)};
to
PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=
_________________________________________________________
for the best results to your questions: FAQ333-2924
Is your question a most FAQ?? Find out here FAQ333-3048

http://www.onpntwebdesigns.com

 

[rjkealey]

I have tried that and several others typed differently
still no luck

RJKealey

 

[onpnt]

hmm... I guess that explains it up there.

try server.mapPath instead of the hard coded path. this will take out a possible error in there

eg:
DBQ=&quot; & server.mapPath(&quot;\htdocs\auto\foreclosure.mdb&quot _________________________________________________________
for the best results to your questions: FAQ333-2924
Is your question a most FAQ?? Find out here FAQ333-3048

http://www.onpntwebdesigns.com

 

[rjkealey]

still no dice could it be a server error?
RJKealey

 

[BG12424]

Try the following:

strConn = &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot; & Server.MapPath(&quot;/home/default/cmkinc.biz/htdocs/auto/foreclosure.mdb&quot & &quot;;&quot; _______________________________
regards,
Brian

AOL IM: FreelanceGaines

 

[rjkealey]

keeps giving error on MyConn.open ConnectionString
can not figure this out
RJKealey

 

[BG12424]

Go to

http://www.google.com

and type in &quot;Microsoft JET Database Engine error '80004005'&quot; in the search box.

I saw a bunch of links that reference this error. You might want to check them out. _______________________________
regards,
Brian

AOL IM: FreelanceGaines

 

[tonylnng]

rjkealey,

I have some hits for you to trace,

1. Are you sure the hosting server supports the provider you specificed?

2. What is the physical path of the mdb file you stored in hosting server?
At localhost you stored to
d:\home\default\cmkinc.biz\htdocs\auto\foreclosure.mdb
How about hosting? Is it same path? If not, you need to change the path that same as hosting but not localhost.


Tony