I have been trying for 3 days to connect to my postgres linux box via vb
.net on a windows box. I have to make this work somehow.

I found npgsql provider and tried it but could not make it connect either. I
would prefer to use the OleDbConnection if possible.

Has anyone been able to connect via the odbc driver and .NET?

I am getting despirate and not sure which way to turn now.

A snip of the code I have been using to try to connect is below.

Thanks in advance.

Tommy


Dim connstring As String = "Server=192.168.5.5;User
Id=myname;Password=mypassword;Database=mydbname"

Dim conn As New NpgsqlConnection(connstring)

conn.Open()

conn.Close()




Sun, 27 Oct 2002 21:55:54 -0600
"Tommy" <tmartin1@telocity.com>
Pgsql and .NET (Help!)