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..