RE:codigo para conecciones ado
Esta es la que yo uso y me parece sencilla
sAttributes = "DRIVER=NonStop SQL;UID=" & LCase(gsSuperusuario) & _
";PWD=" & UCase(gsSuperpasswd)
sAttributes = sAttributes & ";DATABASE=" & gcDATABASE & ";Commlib=," & gcSERVER & "," & GC_PUERTO & ";"
sAttributes = sAttributes & "ACCESS=0;"
sAttributes = sAttributes & "CURSOR=3;"
sAttributes = sAttributes & "TXN=0;"
sAttributes = sAttributes & "AUTOCOMMIT=1;"
sAttributes = sAttributes & "LOGIN_TIMEOUT=0;"
gconnADO.ConnectionString = sAttributes
gconnADO.Open
grsADO.CursorLocation = adUseClient
strQuery="Select * from Tabla"
grsADO.Open strQuery, gconnADO, adOpenKeyset, adLockOptimistic
gconnADO es ADO.Connection
grsADO es ADO.Recordset