Ahi os va:
error:
Excepción no controlada del tipo 'Microsoft.Data.Odbc.OdbcException'
en microsoft.data.odbc.dll
Información adicional: Error del sistema.
codigo:
Imports Microsoft.Data.Odbc ...
...
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim strConnectionString As String
strConnectionString = "dsn=BD;uid=pppp;pwd=pp;"
Dim pConn As New OdbcConnection(strConnectionString)
Dim pInsertQuery As String = "SELECT * FROM pais"
Dim adapter As New OdbcDataAdapter(pInsertQuery, pConn)
Dim paises As DataSet = New DataSet()
adapter.Fill(paises, "pais") ' ***aqui me falla***
DataGrid1.SetDataBinding(paises, "pais")
DataGrid1.Show()
End Sub
Me da ese error en el adapter. Parece que conecta bien, y hace la sql, pero me peta al acceder a los datos, no???