[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
'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

BLUEDOOR interactive
5 Thomas Street
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