[Firebird-net-provider] Data types returned by FbDataReader.GetValue

2010-08-18 Thread Steve Boyd
Is there some place I can find the type of .Net Object returned by FbDataReader.GetValue for each native Firebird data type? For example, Varchar returns a String but other data types (especially the numeric types) don't appear to be that obvious. I've tried looking in the source but all

[Firebird-net-provider] invalid parameter in transaction parameter block

2010-03-08 Thread Steve Boyd
I am getting the following error: invalid parameter in transaction parameter block when executing the following code: var opt: FbTransactionOptions; begin opt := new FbTransactionOptions(); opt.TransactionBehavior := FbTransactionBehavior.ReadCommitted or

Re: [Firebird-net-provider] invalid parameter in transaction parameter block

2010-03-08 Thread Steve Boyd
I think you want to specify only FbTransactionBehavior.ReadCommitted | FbTransactionBehavior.Wait | FbTransactionBehavior.Write (or maybe event without .Write), as else your combination doesn't make sense to me. Jim; Thank you. Removing FbTransactionBehavior.Read solved the problem.

Re: [Firebird-net-provider] Using .Net provider with Delphi Prism

2010-02-26 Thread Steve Boyd
That was the latest version I could find. Where is the version 2 documentation? Jiri Cincura wrote: On Thu, Feb 25, 2010 at 22:39, Steve Boyd sboyd...@gmail.com wrote: I'll grant that I am not fully up to speed on .Net yet but I do know C# and Pascal. When I see the signature given

[Firebird-net-provider] Using .Net provider with Delphi Prism

2010-02-25 Thread Steve Boyd
I am having a problem with .Net provider 2.5.2 and Delphi Prism 2010. I can't seem to compile this statement: FbTransaction trans := connection.BeginTransaction(FbTransactionOptions.ReadCommitted); I get an error: Error1(PE223) FirebirdSql.Data.FirebirdClient.FbTransactionOptions

Re: [Firebird-net-provider] Using .Net provider with Delphi Prism

2010-02-25 Thread Steve Boyd
, Feb 25, 2010 at 21:17, Steve Boyd sboyd...@gmail.com wrote: I must be doing something wrong, but I can't figure out what. The BeginTransaction has different parameters. Just look at signature. -- Download Intel

[Firebird-net-provider] DDEX

2008-08-14 Thread Steve Boyd
OK. I have downloaded DDEX 2.1.0.0 and followed the installation instructions. Guess what? It doesn't work. In VS 2005 I can now see the Firebird provider in the list of options and the Firebird configuration dialog appears when I selection the Firebird provider. BUT, as press any key to

Re: [Firebird-net-provider] DDEX

2008-08-14 Thread Steve Boyd
to notice the errant tag at the end of the previous line. I guess I was so focused on the accurate keying of the PublicKeyToken and version information that I overlooked the obvious. Sorry for the confusion. I hate XML. Steve Boyd wrote: OK. I have downloaded DDEX 2.1.0.0 and followed

Re: [Firebird-net-provider] FB provider and DataGridView and Visual Studio 2008

2008-08-13 Thread Steve Boyd
easily find out) what columns make up the query and create them for me. Maybe I am just spoiled by Delphi were this all happens more or less automatically. Jiri Cincura wrote: On Wed, Aug 13, 2008 at 5:33 PM, Steve Boyd [EMAIL PROTECTED] wrote: I want to be able to specify column headings

Re: [Firebird-net-provider] FB provider and DataGridView and Visual Studio 2008

2008-08-13 Thread Steve Boyd
No I don't have a typed dataset. The only way I know to create a typed dataset is to use the Data | NEw Data Source menu option. But the Firebird provider isn't one of the choices so I can't create a typed dataset. Jiri Cincura wrote: On Wed, Aug 13, 2008 at 5:55 PM, Steve Boyd [EMAIL

Re: [Firebird-net-provider] FB provider and DataGridView and Visual Studio 2008

2008-08-13 Thread Steve Boyd
As Carlos asked, you need to have DDEX working to see some FB connection here (and added in server explorer or you can create new). Look at Firebird website to download it. This must be what I am missing. Let me see if I can get it installed.