When im trying to update the records from mysql to postgresql, the connection error

rhepsi

Dear All,

Im vb.net 1.1,
When im trying to update the records from mysql to postgresql, the connection error:

the following code is Update data button click:


Dim myPgrConnect As New NpgsqlConnection
Dim myPgrCommand As New NpgsqlCommand
'myCon.ConnectionString = "Server=ip adress; Port=xxxx Database=xx; Userid=xx; password=xx; Protocol=x; SSL=false; Pooling=true; MinPoolSize=1; MaxPoolSize=20; Encoding=UNICODE; Timeout=15; SslMode=Disable;"
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=ipadress; Port=xxxx; Database=xx; Userid=xx; Password=xx; Protocol=x; SSL=false; Pooling=true; MinPoolSize=1; MaxPoolSize=20; Encoding=UNICODE; Timeout=15; SslMode=Disable;"
' myPgrConnect.Open()
' End If



Now im getting Error as General error: Connection not open

Im getting an eception saying maxpoolsize parameter not supporting Mysql.data.dll

HELP ME...
Thnks in Advance..

Apr 24 '07 #1