Connecting to PostgreSQL through SSH (putty)

[rhepsi]

Hii all,

im doin a vb 1.1 vs.net 2003 project where im trying to update the data from mysql to postgreSQL....

when im trying to click on update , im opening the connection of PostgreSQL using SSH(secure shell)

Dim myPgrConnect As New NpgsqlConnection("Server=localhost; Port=8443; Database=dalitch_css; User Id=dalitch; Password=dfndev; Timeout=30")
        Dim myPgrCommand As New NpgsqlCommand
        Dim strSQL As String
        Dim record As String
        Dim intRowsAffected As Integer
        Dim ds As New DataSet
        Dim myTable As DataTable
 
        myPgrConnect.Open()..........>> Here im getting a error stating that 
 

An unhandled exception of type 'System.IO.IOException' occurred in npgsql.dll
Additional information: Unable to read data from the transport connection.

plz help.....

regards
ruth

[michaelb]

You said "... opening the connection of PostgreSQL using SSH(secure shell)"
This suggests that database server is installed on a remote machine.
At the same time you coded "Server=localhost;"

I am not familiar with the VB/npgsql API, but this is the first thing I would check on. While at it verify that dbname, port# and everything else in the connect string is correct.

Also make sure that your version of npgsql is compatible with your version of Postgres.
(I think the latest Frontend/Backend Protocol is now up to version 3)

There's also a chance that this is a bug in npgsql, similar cases have been reported:
http://gborg.postgresql.org/project/...pdate.php?1418

[rhepsi]

You said "... opening the connection of PostgreSQL using SSH(secure shell)"
This suggests that database server is installed on a remote machine.
At the same time you coded "Server=localhost;"

I am not familiar with the VB/npgsql API, but this is the first thing I would check on.

Also make sure that your version of npgsql is compatible with your version of Postgres.
(I think the latest Frontend/Backend Protocol is now up to version 3)

Thnq for ur reply....

hey ure right...

        ' code to update the data with required fields into the post gre data base 
        Dim myPgrConnect As New NpgsqlConnection
        Dim myPgrCommand As New NpgsqlCommand
              Dim strSQL As String
        Dim record As String
        Dim intRowsAffected As Integer
        Dim ds As New DataSet
        Dim myTable As DataTable
 
        Try
            If Plink.HasExited = False Then
                myPgrConnect.ConnectionString = "Server=192.168.1.61; Port=5432; Database=dalitch_css; Userid=dalitch; Password=dfndev; Protocol=3; SSL=false; Pooling=true; MinPoolSize=1; MaxPoolSize=20; Encoding=UNICODE; Timeout=15; SslMode=Disable;"
                myPgrConnect.Open()
            End If
        Catch ex As Exception
            MsgBox("Error" + ex.Message(), MsgBoxStyle.Information, "error")
 
            MessageBox.Show("Secure Shell is not connected", "Error Message...!!")
            Return
        Catch ex1 As System.NullReferenceException
            MessageBox.Show("Error2: " + ex1.Message(), "Error Message...!!")
            Return
        End Try
 
        myTable = myData.Tables(0)
        Dim myRow As DataRow
 
        'For Each myRow In mytable.Rows
        '    strSQL = "UPDATE ""Tbl_Students"" SET " _
        '    & " ""ST_FirstName"" = @ST_FirstName," _
        '    & " ""ST_DateofBirth"" = @ST_DateofBirth, " _
        '    & " ""ST_Gender"" = @ST_Gender, " _
 

[michaelb]

I'm glad it worked for you.
Please make sure to use the correct format (especially CODE TAGS) in your next posting.
The Posting Guidelines at the top of the forum will give you more information.