[thelist] Access+ASP: database connection error
Ed Wolstenholme
ed at bluedoor.uk.com
Wed Jan 31 18:06:48 CST 2001
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
More information about the thelist
mailing list