I am trying to use RDO to access a SQL db and I keep getting the message
429 - ActiveX component can't create object. The connection was created
from Control panel, ODBC32 under Nt Workstation 4.0 sp4. The code that it
breaks on is the "Set db" line. Any help would be greatly appreciated.
Dim db As rdoConnection
Dim rs As rdoResultset
Dim sSQL As String
Set db = rdoEngine.rdoEnvironments(0).OpenConnection("Court")
sSQL = "Select * from Docket"
Set rs = db.OpenResultset(sSQL, rdoopenkeyset)
While Not rs.EOF