Hi,
I'm moving to hosting that doesn't allow DNS connections, as my site has been set up and need therefore to move to a DNS less connection to a MS Access DB.
I'm getting an error reading:
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 0x80c Thread 0x8c0 DBC 0xec826f4 Jet'.
/showcategory.asp, line 15
The code around this point is:
Code:
Dim rs_Categories
Dim rs_Categories_numRows
Set rs_Categories = Server.CreateObject("ADODB.Recordset")
rs_Categories.ActiveConnection = MM_db_port_STRING
rs_Categories.Source = "SELECT * FROM tbl_Category WHERE CatID = " + Replace(rs_Categories__MMColParam, "'", "''") + ""
rs_Categories.CursorType = 0
rs_Categories.CursorLocation = 2
rs_Categories.LockType = 1
rs_Categories.Open()
rs_Categories_numRows = 0
as created by Dreamweaver... All I've done to try and get around swapping this over is change the file in the Connections file from:
Code:
MM_db_port_STRING = "dsn=databasedsn;"
to:
Code:
Dim MM_db_port_STRING
conString = "DBQ=D:pathtodatabase\databasename.mdb"
MM_db_port_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};" & conString
Any help would be greatly appreciated. I've also tried using Provider= and Data Source instead of the DRIVER= and DBQ but to no avail. Do I need to change the whole Connection part of the code?
Thanks in advance,
Glenn