ASP error

cudjoe83 · August 26th, 2003, 02:13 AM

Hi,
Can any one of you guys help? I am trying to connect to my database using asp. Anytime I connect the following error message. Being new to asp, its difficult to figure out what exactly the problem is:

Dim objRs, objConn, Hardware,strConn

'emne=Request.QueryString("emne")
strQuery="SELECT DISTINCT * FROM Hardware"
'strQuery="SELECT * FROM Lokation
'LokationID2 objRS("LokationID")
'strQuery="SELECT * FROM Hardware WHERE LokationID=LokationID
'objRS2.open strConn
' WHERE emne='" & emne & "';"

strConn=Application("strConn")
set objRS=Server.createObject("ADODB.recordset")
set objConn=Server.createObject("ADODB.connection")
objConn.open strConn
objRS.open strQuery, objConn, adOpenStatic,, adCmdText

The asp error is
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access-driver] "(unknown)" is not a valid path. Control, that the parth is correctly spelt, and that you are connect to the right server, hvor the files is.
/web2/menuitem5doc1.asp, line 39

Line 39 is the objConn.open strConn

Any suggestions?

Nick

pgtips · August 26th, 2003, 03:46 AM

Sounds like a problem with the format of the connection string strConn. See if it looks like any of the examples here: http://www.able-consulting.com/ADO_Conn.htm

Jonax · August 26th, 2003, 04:49 AM

Quote:

quote:
Being new to asp, its difficult to figure out what exactly the problem is

To view the contents of your connectionstring, add the following line to your code...

Code:

strConn=Application("strConn")
response.write strConn: response.end
set objRS=Server.createObject("ADODB.recordset")

(You should remove it or comment it out, once you think you have the right path...)