Re: [GENERAL] The connection is dead

2006-01-09 Thread pairat
Thank you for your response. I use ODBC instead of Npgsql because I can use ODBC with other database such as MS Access, and MS SQL. Here is the code. System.DateTime dateTimeNow = System.DateTime.Now; int i=0; dataView1.RowFilter = "Posted = true"; dataView1.Sort = "GLTran, ID"; //GLTran Table in

Re: [GENERAL] The connection is dead

2006-01-09 Thread pairat
Hi Jonel Thank you for your response. I use ODBC instead of Npgsql because the program can use with MS Access, MS SQL and PostgreSQL. Here is the code. int n = this.BindingContext[dataView1].Count - 1; string _Journal; DataRowView DataRowView1; this.cmdInsert.Transaction = _Transaction; this.cm

Re: [GENERAL] The connection is dead

2006-01-09 Thread pairat
I use ODBC instead of Npgsql because the ODBC can use with MS Access, MS SQL and PostgreSQL database. Here is the code. System.DateTime dateTimeNow = System.DateTime.Now; int i=0; dataView1.RowFilter = "Posted = true"; dataView1.Sort = "GLTran, ID"; //GLTran Table int n = this.BindingContext[data

Re: [GENERAL] The connection is dead

2006-01-07 Thread Jonel Rienton
What does your code look like? And have you tried using Npgsql instead of the ODBC driver? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Saturday, January 07, 2006 4:39 AM To: pgsql-general@postgresql.org Subject: [GENERAL] The c