Yuo need to write:

Set ConnectionToDatabase=Server.CreateObject("ADODB.Connection")



regards Christian Dygaard



-----Oprindelig meddelelse-----

Fra: Locke, Darrell (FCS/SFC) [mailto:Darrell.Locke@g...]

Sendt: 20. februar 2002 14:42

Til: ASP Databases

Emne: [asp_databases] ADO Connections





Hi, I had changed my connection to my database from this:





'Dim ConnectionToDatabase

'	Set ConnectionToDatabase=Server.CreateObject("ADODB.Connection")

'	ConnectionToDatabase.ConnectionTimeout = 60

'	ConnectionToDatabase.Open "Profile"





To this:





Dim ConnectionToDatabase

ConnectionToDatabase.Mode =adModeShareExclusive

ConnectionToDatabase.Open "Provider=Microsoft.Jet.OLEDB.4.0;"  & _

           "Data Source=c:..\database1\liguistic.mdb;" & _

           "User Id=admin;" & _

           "Password=;"



But now I am getting this error, can some help me debug this?



Error Type:

Microsoft VBScript runtime (0x800A01A8)

Object required: ''

/hrform/linguistic.asp, line 9



This is line 9 ----> ConnectionToDatabase.Mode =adModeShareExclusive






$subst('Email.Unsub').