Changing from DNS to DNS less connection

dudeshouse · February 7th, 2007, 11:14 AM

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

dparsons · February 7th, 2007, 11:19 AM

Try: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;

And, as a matter of personal prefreance, i suppose, i never hard coded the path to the mdb file.

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &Server.MapPath("mydatabase.mdb") &";"

You can also refer to http://www.connectionstrings.com

================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========

dudeshouse · February 7th, 2007, 11:40 AM

Thanks for that, seems to be seeing the database now, although I'm now getting the interesting error of:

Microsoft JET Database Engine error '80004005'

The Microsoft Jet database engine cannot open the file 'D:\database.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

/showcategory.asp, line 15

Any more thoughts?

Thanks,

Glenn

dudeshouse · February 7th, 2007, 11:49 AM

Sorry all.
The reason for this next error was stupidity on my part. Slightly wrong connection string.

Thanks for the help.

Glenn

dparsons · February 7th, 2007, 12:02 PM

Glad you got it all worked out.

================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========