I am working on a number of pages which have the following connection code. When I go to load the pages in a browser (IE6), I get an "Unspecified Error" which points to the line which reads "objConn.Open", although sometimes the page loads properly only to receive the error the next time I go in.
I am connecting to an Access Database in case that matters.
What is happening and what do I need to do?
I am connecting to an Access Database in case that matters.
What is happening and what do I need to do?
Code:
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DSN=NOFA9"
objConn.Open
set oRS=Server.CreateObject ("ADODB.recordset")
oRS.Open "SELECT * from NOFAS", objConn