DB connection Error : any help please...

[mrkipling]

Can anyone help me, i keep getting a connection error when running my asp script as follows:



Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x5c4 Thread 0x6dc DBC 0x18ee8024 Jet'.

/radial/index.asp, line 3




Im using macromedia's ultradev to produce my asp pages, and am using this connection string within my page:

set Recordset2 = Server.CreateObject("ADODB.Recordset&quot
Recordset2.ActiveConnection = "Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};DBQ=\\

http://www2.domaindlx.com\radial\database\hotpipe.mdb;"

Recordset2.Source = "SELECT * FROM IndexPageData"

Is this connection string correct? please any help would be greatly appreciated



thanks Mark

 

[foxbox]

You are using a bit outdated connectionstring. Try the following instead.

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\files\database.mdb;" & _
"User Id=admin;" & _
"Password=;"


See also:

http://www.adOpenStatic.com/faq/whyOLEDB.asp

br
Gerard
(-:

Better a known bug then a new release.