Re: Problema al conectar con Npgsql

hola, estoy usando Visual Studio 2005 , framework 2.0 y me funciona
perfecto, espero te sirva este ejemplo.

Private sConnString as string =
"Server=mihost;Database=mibase;Uid=postgres;Pwd=mipassword;"

Private strSql as string = "SELECT * FROM tabla"

Dim Cn As NpgsqlConnection
Dim dsGrid As DataSet = New DataSet
Dim MyAdapter As New NpgsqlDataAdapter

Try

Cn = New NpgsqlConnection(sConnString)

MyAdapter = New NpgsqlDataAdapter(strSql, Cn)
MyAdapter.FillSchema(dsGrid, SchemaType.Source, "tabla")
MyAdapter.Fill(dsGrid, "tabla")

With dgvSel
.AutoGenerateColumns = True
.DataSource = dsGrid
.DataMember = tabla
End With

Catch ex As Npgsql.NpgsqlException
TextBox1.Text = "Mensaje: " & ex.Message & vbCrLf
End Try