Pgsql and .NET (Help!)

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()