The conversion works for about 80% of my customers databases, but for some customers who have very large databases, the sometimes throws the following exception :-
The inner exception reports a "System.Net.Sockets.SocketError.TimedOut" error with error code 10060.CoreLab.PostgreSql.PgSqlException was unhandled by user code
Message="A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond"
Source="CoreLab.Data"
ErrorCode=-2147467259
LineNumber=0
Position=0
StackTrace:
at CoreLab.Common.DbScript.ExecuteNext(IDataReader& reader)
at CoreLab.Common.DbScript.Execute()
at co2005_to_v4.frmMain.ExecPGSQL(String sql) in E:\vs2005\source\co2005_to_v4\co2005_to_v4\frmMain.cs:line 253
After a lot of testing, the problem seems to occur after a particularly long script (i.e. > 1 minute).
Is there any workaround for this, or perhaps a timeout value that I can tweak somewhere to make this work? Thanks.