PDA

View Full Version : Help with ASP DB connection please....



mrkipling
April 26th, 2001, 19:06
Can anyone help me setup a database connection with wwww.domaindlx.com . 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")
Recordset2.ActiveConnection = "Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};DBQ=\\www2.domaindlx.com\radial\database\hotpipe.md b;"
Recordset2.Source = "SELECT * FROM IndexPageData"

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

thanks Mark