Please help me out because I can't connect to 

my Access database.



I have the connection string for Access as written here.

cn.Open "Driver={Microsoft Access Driver(*.mdb)};" & _

        "Dbq=C:\APP_DEV\profile.mdb;" & _

        "Uid=Admin;" & _

        "Pwd=;"





I encounter this error when the ASP page is run.

Below is the error message.



Microsoft OLE DB Provider for ODBC Drivers error '80004005' 



[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 



/getblobinfo.asp, line 13 

Best Regards

Hi, I also had a lot of problems connecting to my databse...



finally, this was the only way it worked out:



Set conn = Server.CreateObject("ADODB.Connection")

conn.Provider="Microsoft.Jet.OLEDB.3.51"

conn.open Server.MapPath("\") & TempPath & "\Test.mdb"



You have to be careful with your "c:\..." path, because this links to the 

server and not to your local harddisc or any other netserver... For this I 

use the "server.mappath" command, which finds out the main directory of 

the web on the webserver.... 



I hope this helps

Matthias