Can't connect to my access db. can you help me? 3

[qb828]

<%
'option explicit
Response.Write(&quot;<h4>Agent Database</h4>&quot
dim oCon
dim oRS
dim sSql
Set oCon = Server.CreateObject(&quot;ADODB.Connection&quot
oCon.Connectionstring = &quot;Driver={Microsoft Access Driver (*.mdb)}; DBQ=c:\mydb\agentdb.mdb&quot;
oCon.Open
Set oRS = Server.CreateObject(&quot;ADODB.Recordset&quot
sSql=&quot;SELECT * FROM TblPathogen&quot;
oRS.Open sSql, oCon
%>
This code worked fine at my home PC.
I had saved the agentdb.mdb at same place at home and work.
C:\mydb\agentdb.mdb.

I was able to connect at home but i am having problems at my work.
I get this message. Can you help?? For some reason I am not able to connect.
Thanks.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xc34 Thread 0xf2c DBC 0x1fd1284 Jet'.
/agent/agent3.asp, line 17




QB

 

[onpnt]

try the link in this thread a few replies down
thread333-696804

you should use OLEDB connection strings

_____________________________________________________________________

_{I have the resolution perfect in my mind, but it never seems to fit on the screen quite the same way}

 

[GaryC123]

Use this connection string

oCon.Connectionstring =&quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\mydb\agentdb.mdb&quot;

http://www.intouchmedialtd.com

 

[qb828]

I get this message now.
Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/agent/agent3.asp, line 17


QB

 

[GaryC123]

Make sure you have the latest drivers, MDAC 2.8

http://www.intouchmedialtd.com

 

[qb828]

i do have that already...
I get the same error message.
Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/agent/agent3.asp, line 17

This shouldn't be that hard. I don't know why this is not working.
Thanks.


Set oCon = Server.CreateObject(&quot;ADODB.Connection&quot
oCon.Connectionstring = &quot;Provider=Mircrosoft.Jet.OLEDB.4.0; Data Source=C:\Documents and Settings\baep\My Documents\Project\AgentDB\agentdb.mdb;&quot;
oCon.Open
Set oRS = Server.CreateObject(&quot;ADODB.Recordset&quot

QB

 

[GaryC123]

And Jet 4 is definitely installed?

http://support.microsoft.com/support/kb/Articles/q278/6/04.asp

http://www.intouchmedialtd.com

 

[qb828]

Thanks guys.

I had them all already.
MDAC & JET 4.

But I fixed the problem.
I changed the location of my db
from
C:\Documents and Settings\baep\Desktop\Web_ACTD\webpage\mydb.mdb
to
C:\db\mydb.mdb.

After that it worked.

I don't know why!!!!

Can anyone explain that???

Thanks again.


QB

 

[andybeh]

Hi,

Just speculating, but it might be because 'Documents and Settings' contains whitespace. I'm not sure how well the web server would handle this?

Cheers

ab

 

[qb828]

Thanks a lot Guys.



QB