Dynamics Community Forum Thread Details

Hook and Connection to SQL

Can i perform a connection to sql server 2005 on a hook using ADO?

How can i do that cause im trying without any result

this is my code

Dim Value_Need As String

Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset

Set cnn = New Connection
Set rst = New Recordset
cnn.Open "Provider=SQLNCLI;Server=ServerRMS;Database=RMSSampleDB;Uid=sa; Pwd=P@$$W0RD;", "sa", "P@$$W0RD"
                ' abrir el recordset indicando la tabla a la que queremos acceder
                rst.Open "SELECT Password FROM Cashier WHERE Number = " & "'" & LastCashier & "'", cnn, adOpenDynamic, adLockOptimistic
                ' Asignar los nombres de los campos al combo
                If Not rst.EOF And Not rst.BOF Then
                    rst.MoveFirst
                  Value_Need = rst.Fields("Password")
                Else
                   Value_Need = ""
                End If
                ' Cerrar el recordset y la conexión
                rst.Close
                cnn.Close

but getting error looks like i dont have register the dll for ADO connection but i verify and i have the same version.

If i try this code on a winform or class works fine but in the hook cant make work.

Quick Links

Leaderboard