Porque no funciona el codigo (conexion Acces 2000)
Publicado por juan (5 intervenciones) el 10/01/2003 01:36:40
Hola, alguien podria decirme porque no funciona este codigo de conexion a la BD:
Option Explicit
Dim conBase As ADODB.Connection
Dim rstCliente As ADODB.Recordset
Private Sub Form_Load()
On Error GoTo errorA
Set conBase = New ADODB.Connection
With conBase
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=" & App.Path & "\base2000.mdb;Persist Security Info=False"
.Open
End With
Set rstCliente = New ADODB.Recordset
With rstCliente
.ActiveConnection = conBase
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
.Open "SELECT * from Clientes"
End With
errorA:
MsgBox "No se puede establecer la conexion a la Base de Datos" & vbCrLf & "Error : " & Err.Description, vbInformation, "Tech"
Unload Me
End Sub
¿Qué está mal?
Option Explicit
Dim conBase As ADODB.Connection
Dim rstCliente As ADODB.Recordset
Private Sub Form_Load()
On Error GoTo errorA
Set conBase = New ADODB.Connection
With conBase
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=" & App.Path & "\base2000.mdb;Persist Security Info=False"
.Open
End With
Set rstCliente = New ADODB.Recordset
With rstCliente
.ActiveConnection = conBase
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
.Open "SELECT * from Clientes"
End With
errorA:
MsgBox "No se puede establecer la conexion a la Base de Datos" & vbCrLf & "Error : " & Err.Description, vbInformation, "Tech"
Unload Me
End Sub
¿Qué está mal?
Valora esta pregunta


0