[thelist] Access+ASP: database connection error

[Ed Wolstenholme]

Problem solved using this bit of code:
'<% @LANGUAGE = VBScript %>
'<%
'Option Explicit
'Response.Expires = 0
 'Application.UnLock
'Dim strQuery,objConn,objRS, strconnection, storyno
'Set objConn = server.CreateObject("ADODB.Connection")
'strConnection = "DSN=; Database=;"
'objConn.Open strConnection


 'strQuery = "SELECT * From bill"
'Set objRS = objConn.Execute(strQuery)


'%>
Basically its down to a stuck process which the above code unlocks, just
insert your DSN and database name.

Ed Wolstenholme
Producer

BLUEDOOR interactive
5 Thomas Street
Heckmondwike
West Yorkshire
WF16 0LS

T: 01924 412241
F: 01924 412770
E:ed at bluedoor.uk.com
W: http://www.bluedoor.uk.com