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