Subject | Firebird Exception using OpenVPN |
---|---|
Author | Alex Castillo |
Post date | 2008-02-06T16:43:52Z |
Hello,
I have an application coded in C# and I'm using
Firebird 2.0.1 and the .NET provider (FBClient 2.1.0).
On my local network everything works fine, but I have
a VPN with OpenVPN and when I'm using
FbDataAdapter.Fill()
method, the application raises the next exception:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog
box.
************** Exception Text **************
FirebirdSql.Data.FirebirdClient.FbException --->
FirebirdSql.Data.Common.IscException: Exception of
type 'FirebirdSql.Data.Common.IscException' was
thrown.
at
FirebirdSql.Data.Client.Gds.XdrStream.ReadValue(DbField
field)
at
FirebirdSql.Data.Client.Gds.GdsStatement.ReadDataRow()
at FirebirdSql.Data.Client.Gds.GdsStatement.Fetch()
at
FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()
--- End of inner exception stack trace ---
at
FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()
at
FirebirdSql.Data.FirebirdClient.FbDataReader.Read()
at
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping
mapping)
at
System.Data.Common.DataAdapter.FillFromReader(DataSet
dataset, DataTable datatable, String srcTable,
DataReaderContainer dataReader, Int32 startRecord,
Int32 maxRecords, DataColumn parentChapterColumn,
Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataTable[]
dataTables, IDataReader dataReader, Int32 startRecord,
Int32 maxRecords)
at
System.Data.Common.DbDataAdapter.FillInternal(DataSet
dataset, DataTable[] datatables, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at
System.Data.Common.DbDataAdapter.Fill(DataTable[]
dataTables, Int32 startRecord, Int32 maxRecords,
IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable
dataTable)
at Pes.GUIVentas.FrmBuscaVenta.Buscar()
at
Pes.GUIVentas.FrmBuscaVenta.EventoCambiarDias(Object
sender, EventArgs e)
at
System.Windows.Forms.DateTimePicker.OnValueChanged(EventArgs
eventargs)
at
System.Windows.Forms.DateTimePicker.WmDateTimeChange(Message&
m)
at
System.Windows.Forms.DateTimePicker.WmReflectCommand(Message&
m)
at
System.Windows.Forms.DateTimePicker.WndProc(Message&
m)
at
System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&
m)
at
System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&
m)
at
System.Windows.Forms.NativeWindow.Callback(IntPtr
hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
I've noticed that this happens when I'm using Date and
DateTime fields in the query.
I've asked to dot-net-provider list and they suggest
the issue is OpenVPN. That sounds logical because if I
open the port 3050 on my firewall and I connect all
the clients in that way the exception is not raised.
But you are the masters of Firebird, so I'd appreciate
any advice :-)
Has Firebird any known issue with OpenVPN server??
Regards.
_______________________________
I'm free, I use GNU/Linux.
Close your Windows, Open your mind.
____________________________________________________________________________________
¡Capacidad ilimitada de almacenamiento en tu correo!
No te preocupes más por el espacio de tu cuenta con Correo Yahoo!:
http://correo.yahoo.com.mx/
I have an application coded in C# and I'm using
Firebird 2.0.1 and the .NET provider (FBClient 2.1.0).
On my local network everything works fine, but I have
a VPN with OpenVPN and when I'm using
FbDataAdapter.Fill()
method, the application raises the next exception:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog
box.
************** Exception Text **************
FirebirdSql.Data.FirebirdClient.FbException --->
FirebirdSql.Data.Common.IscException: Exception of
type 'FirebirdSql.Data.Common.IscException' was
thrown.
at
FirebirdSql.Data.Client.Gds.XdrStream.ReadValue(DbField
field)
at
FirebirdSql.Data.Client.Gds.GdsStatement.ReadDataRow()
at FirebirdSql.Data.Client.Gds.GdsStatement.Fetch()
at
FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()
--- End of inner exception stack trace ---
at
FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()
at
FirebirdSql.Data.FirebirdClient.FbDataReader.Read()
at
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping
mapping)
at
System.Data.Common.DataAdapter.FillFromReader(DataSet
dataset, DataTable datatable, String srcTable,
DataReaderContainer dataReader, Int32 startRecord,
Int32 maxRecords, DataColumn parentChapterColumn,
Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataTable[]
dataTables, IDataReader dataReader, Int32 startRecord,
Int32 maxRecords)
at
System.Data.Common.DbDataAdapter.FillInternal(DataSet
dataset, DataTable[] datatables, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at
System.Data.Common.DbDataAdapter.Fill(DataTable[]
dataTables, Int32 startRecord, Int32 maxRecords,
IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable
dataTable)
at Pes.GUIVentas.FrmBuscaVenta.Buscar()
at
Pes.GUIVentas.FrmBuscaVenta.EventoCambiarDias(Object
sender, EventArgs e)
at
System.Windows.Forms.DateTimePicker.OnValueChanged(EventArgs
eventargs)
at
System.Windows.Forms.DateTimePicker.WmDateTimeChange(Message&
m)
at
System.Windows.Forms.DateTimePicker.WmReflectCommand(Message&
m)
at
System.Windows.Forms.DateTimePicker.WndProc(Message&
m)
at
System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&
m)
at
System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&
m)
at
System.Windows.Forms.NativeWindow.Callback(IntPtr
hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
I've noticed that this happens when I'm using Date and
DateTime fields in the query.
I've asked to dot-net-provider list and they suggest
the issue is OpenVPN. That sounds logical because if I
open the port 3050 on my firewall and I connect all
the clients in that way the exception is not raised.
But you are the masters of Firebird, so I'd appreciate
any advice :-)
Has Firebird any known issue with OpenVPN server??
Regards.
_______________________________
I'm free, I use GNU/Linux.
Close your Windows, Open your mind.
____________________________________________________________________________________
¡Capacidad ilimitada de almacenamiento en tu correo!
No te preocupes más por el espacio de tu cuenta con Correo Yahoo!:
http://correo.yahoo.com.mx/