I am trying to make my first connection to a SQL Server DB using ADO. I have simplified this code trying to find the error. But I get Runtime error “446” Object doesn’t support names arguments. I can enter almost the same code in for RDO and it runs fine. I am sure it is something very easy and/or stupid. Does anyone have any soloutions?

Dim cn As Connection
Dim rs As New ADODB.Recordset

Set cn = New Connection

cn.connectString = "driver={SQL Server};server = genisis_srv_1"

cn/open