Dns-less connection..Help

Dns-less connection

[wweidner]

First of all hello to everyone, I am new to posting things like this, please be understanding.

I am trying to make a dns-less connection (first time trying this) for a website that i am building and everything that I have tried is not working. It is telling me that my connection is no good. Here is the code:

set connection = Server.CreateObject("ADODB.Connection")
fakeDSN="DRIVER={Microsoft Access Driver (*.mdb)}; "
fakeDSN=fakeDSN & "DBQ=" & Server.MapPath("data/backend.mdb")
connection.Open fakeDSN
function EncodeThisText(text)
if(instr(text, "'")) then
text = replace(text, "'", "'")
elseif(instr(text, """")) then
text = replace(text, """", """)
end if
EncodeThisText = text
end function

This is the error that i am getting:

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 0xbd0 Thread 0xad0 DBC 0x205c0b4 Jet'.

/includes/connection.inc, line 5

I can not make heads or tales of what is wrong, i have change things and even talked to the server to make sure the permissions are set to "write".

[defanjos]

Welcome to WebmasterWorld

Try:
fakeDSN=fakeDSN & "DBQ=" & Server.MapPath("/data/backend.mdb")

Instead of:
fakeDSN=fakeDSN & "DBQ=" & Server.MapPath("data/backend.mdb")

[wweidner]

It is still giving me the same error. Thank you for the welcome

[defanjos]

Not sure if it is the same error, but read this thread [webmasterworld.com]

[Spooky]

Use OLEDB

fakeDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("data/backend.mdb")

You are sure the path is correct?

[wweidner]

I have try alot of different things and I still can not get this code to work....it is giving me a runtime error now.

[Spooky]

The error is? :)

[wweidner]

I got this problem fixed...i had posted the other problem hich also got fixed....THank you for asking