Connection string to upload data from mysql to postgresql thru SSH

[rhepsi]

HII all,

im doin a vb project (vs.net 2003)

im trying to uload the data from mysql (tbl_students) to postgresql (tbl_students_new) ...

in the upload button_click:

connection string is as follows:-

 
  ' 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
 
[ERROR]........>>>> myPgrConnect.ConnectionString = "Server=localhost; Port=5432; Database=dalitch_css; Userid=dalitch; Password=dfndev; Protocol=3; SSL=true; Pooling=true; MinPoolSize=1; MaxPoolSize=20; Encoding=UNICODE; Timeout=15; SslMode=Enable;"...........>>>>>[ERROR]
 
UNABLE TO WRITE THE DATA INTO THE TRANSPORT CONNECTION...
 
[ERROR].........>>>>myPgrConnect.Open()....................>>>>>[ERROR]
 
            End If
            Catch ex As Exception
            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
 
 

IF IM TRYING TO GIVE THE SERVER AS THE ONE OF SSH TEHN IM GETTING AN ERROR STATING THAT:

[ERROR]
An unhandled exception of type 'Npgsql.NpgsqlException' occurred in npgsql.dll

Additional information: No connection could be made because the target machine actively refused it.

[/ERROR]


PLS REPLY...

THNQ

REGARDS
HEPSI..

[kenobewan]

Here is a site that may help:
Postgre SQL

[rhepsi]

Here is a site that may help:
Postgre SQL

Thnx.....

hey i need to know how to confirm whether SSh is activated or not...??

[rhepsi]

Hii all,


How to know whether the SSH Tunnelling is working frm mysql to postgresql correctly...???

im trying to connect frm mysql to postgresql through ssh from vb.net code.....

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

Im getting an error as:

Unable to write the data into the transport conenction.....



plz help..

thnx in advance

hepsi..