Coneccion sql server 2000 ==>vb 6.0
Estoy empezando a programar en visual basic 6.0 y deseo utilizar bases de datos de sql server 2000, me podrías indicar como hacer la conexión desde visual
Gracias de antemano
Gracias de antemano
1 respuesta
Respuesta de pjlm99
1
Abnet, intentá esto. No olvides agregar referencias a ADO al proyecto.
Dim db as ADODB.Connection
Dim Comando as ADODB.Command
Dim Rst as ADODB.RECORSET
Private Sub Login()
Set db = New ADODB.Connection
Set Comando = New ADODB.Command
Set Rst = New ADODB.Recordset
With dbsarcisADO
.Provider = "SQLOLEDB"
.ConnectionString = "SERVER=Soft;UID=" + UserTxt + ";PWD=" + PassTxt + ";DATABASE=master"
.CommandTimeout = 3600
.Open
End With
end sub
Dim db as ADODB.Connection
Dim Comando as ADODB.Command
Dim Rst as ADODB.RECORSET
Private Sub Login()
Set db = New ADODB.Connection
Set Comando = New ADODB.Command
Set Rst = New ADODB.Recordset
With dbsarcisADO
.Provider = "SQLOLEDB"
.ConnectionString = "SERVER=Soft;UID=" + UserTxt + ";PWD=" + PassTxt + ";DATABASE=master"
.CommandTimeout = 3600
.Open
End With
end sub
