[Firebird-net-provider] Problem with trying to connect to a database
Hi,
I'm having a problem when trying to connect to a database, but I doubt
that the problem is with the Firebird Server.
The environment is Windows 2008 R2 standard server with .Net 4,
Firebird 2.5RC3 and Firebird ADO.Net 2.5.2.
The error that is returned is:
Exception Source: FirebirdSql.Data.FirebirdClient
Exception Type:System.IndexOutOfRangeException
Exception Message: Index was outside the bounds of the array.
Exception Target Site: Object reference not set to an instance of an object.
The call stack:
at FirebirdSql.Data.Common.IscHelper.VaxInteger(Byte[] buffer, Int32 index,
Int32 length)
at FirebirdSql.Data.Common.IscHelper.ParseDatabaseInfo(Byte[] buffer)
at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.GetServerVersion()
at
FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.Attach(DatabaseParameterBuffer
dpb, String dataSource, Int32 port, String database)
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()
at FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create()
at FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut()
at FirebirdSql.Data.FirebirdClient.FbConnection.Open()
at DoctorDeals.DoctorDealsPMP.HasTrigger(String vTriggerName)
at DoctorDeals.DoctorDealsPMP..ctor()
The line of code that in the function HasTrigger, I do the following
check:
if (fbConnCommands.State != ConnectionState.Open)
{
fbConnCommands.Open();
}
And, I was able to confirm that the error is triggered by the
fbConnCommands.Open(). And, it is the first time that a connection is
attempted.
This is the error that is generated on a customer's computer. I don't
get this error on my computer.
Any ideas to help me debug this would be appreciated.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Solutions Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
--
This SF.net email is sponsored by
Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with trying to connect to a database
On Thu, Aug 12, 2010 at 14:25, Daniel Rail dan...@accra.ca wrote:
Any ideas to help me debug this would be appreciated.
http://tracker.firebirdsql.org/browse/DNET-330
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
This SF.net email is sponsored by
Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Compact Framework version of 2.5.2
Is there an official download of 2.5.2 for .Net CF? Also, has anyone got this working fully with .Net 2.0 or must we still use .Net 3.5? -- This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with trying to connect to a database
Hi, At August-12-10, 9:47 AM, Jiri Cincura wrote: On Thu, Aug 12, 2010 at 14:25, Daniel Rail dan...@accra.ca wrote: Any ideas to help me debug this would be appreciated. http://tracker.firebirdsql.org/browse/DNET-330 Thanks. I've downloaded the latest weekly build and the fbConnection.Connect now works. But, I'm now getting an error when starting a transaction. The exception message is: Object reference not set to an instance of an object. Here's the call stack: at FirebirdSql.Data.FirebirdClient.FbTransaction.BuildTpb(FbTransactionOptions options) at FirebirdSql.Data.FirebirdClient.FbTransaction.BuildTpb() at FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction() at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.BeginTransaction(IsolationLevel level, String transactionName) at FirebirdSql.Data.FirebirdClient.FbConnection.BeginTransaction(IsolationLevel level, String transactionName) at FirebirdSql.Data.FirebirdClient.FbConnection.BeginTransaction() at DoctorDeals.DoctorDealsPMP.HasTrigger(String vTriggerName) in C:\Users\Daniel Rail\Documents\Visual Studio 10\Projects\DoctorDeals\DoctorDeals.PServerWindowsService\DoctorDealsPMP.cs:line 532 at DoctorDeals.DoctorDealsPMP..ctor() in C:\Users\Daniel Rail\Documents\Visual Studio 10\Projects\DoctorDeals\DoctorDeals.PServerWindowsService\DoctorDealsPMP.cs:line 38 And, the line in HasTriggers is: FbTransaction vTrans1 = fbConnCommands.BeginTransaction(); -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Compact Framework version of 2.5.2
I found a download at http://sourceforge.net/projects/firebird/files/firebird-net-provider/2.5.2/NETProvider-2.5.2-CF.7z/download And it works with .net 3.5, but not with 2.0 (get missingmethodexception) -- This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with trying to connect to a database
Hi, At August-12-10, 11:07 AM, Daniel Rail wrote: Thanks. I've downloaded the latest weekly build and the fbConnection.Connect now works. But, I'm now getting an error when starting a transaction. The exception message is: Object reference not set to an instance of an object. Here's the call stack: at FirebirdSql.Data.FirebirdClient.FbTransaction.BuildTpb(FbTransactionOptions options) at FirebirdSql.Data.FirebirdClient.FbTransaction.BuildTpb() at FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction() at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.BeginTransaction(IsolationLevel level, String transactionName) at FirebirdSql.Data.FirebirdClient.FbConnection.BeginTransaction(IsolationLevel level, String transactionName) at FirebirdSql.Data.FirebirdClient.FbConnection.BeginTransaction() at DoctorDeals.DoctorDealsPMP.HasTrigger(String vTriggerName) in C:\Users\Daniel Rail\Documents\Visual Studio 10\Projects\DoctorDeals\DoctorDeals.PServerWindowsService\DoctorDealsPMP.cs:line 532 at DoctorDeals.DoctorDealsPMP..ctor() in C:\Users\Daniel Rail\Documents\Visual Studio 10\Projects\DoctorDeals\DoctorDeals.PServerWindowsService\DoctorDealsPMP.cs:line 38 And, the line in HasTriggers is: FbTransaction vTrans1 = fbConnCommands.BeginTransaction(); After downloading the pdb file, it gave me the line of code that wasn't working. It was the line 474, in BuildTbp (the first line of the for loop for the lock tables). What is odd for me, is that the application runs on my development machine, but fails on their new Windows 2008 R2 server, with all updates installed. I downloaded the source code and commented out that code and everything is working now. I'm now seriously considering to setup a clean system for testing purposes. And, keep up the good work. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
