[Firebird-net-provider] problem with design time in Visual Web Developer

2006-06-21 Thread Christoph Donges
I am having trouble getting the firebird data controls to show up in the toolbox. Steps: Install Visual Web Developer Express Install FirebirdClient-2.0-RC5.exe Create new asp.net project Add Reference and add the firebird feferences Choose Items in toolbox and select all the 'Fb' ones They don't

Re: [Firebird-net-provider] Old stored procs

2006-06-21 Thread Carlos Guzmán Álvarez
Hello: > Hope I didn't cause a problem with my novice testing... > No problem, feel free to ask all the question that you have. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que no haya tenido reyes en su

Re: [Firebird-net-provider] Old stored procs

2006-06-21 Thread Craig Brannon
It works the same by just using the proc name as below! ...new FbCommand("GET_ITEM_ONHANDQTY_NEW", This is how I first started calling it. In Delphi we have done this both ways so it was natural to try it when I wasn't getting an answer. In the old Delphi we could use a TQuery "SELECT * FROM P

Re: [Firebird-net-provider] Old stored procs

2006-06-21 Thread Craig Brannon
It appears to do so. It returns the correct answer 270 (decimal) which is unique to this itemId. I will try it with just the proc name and see what happens and let you know. In the debug it shows: [FirebirdSql.Data.FirebirdClient.FbParameterCollection] parameters [0] ParameterName - Value "@IT

Re: [Firebird-net-provider] Old stored procs

2006-06-21 Thread Carlos Guzmán Álvarez
Hello: > FbCommand fbCommand = new FbCommand("SELECT * FROM > GET_ITEM_QTYSUM(@ITEMID, fbConnection); > This looks to be incorrect, hope it's: FbCommand fbCommand = new FbCommand("SELECT * FROM GET_ITEM_QTYSUM(@ITEMID)", fbConnection); > fbCommandType = System.Data.CommandType.StoredProcedur

[Firebird-net-provider] Old stored procs

2006-06-21 Thread Craig Brannon
Carlos, Am working with your "most excellent" FirebirdClient 2.0 in VS 2005. Don't know if this is the right place, but if it is, thought I'd pass on an experience. We have an older Delphi 5 application that runs an older Firebird db (was IB) dialect 1. The db has a number of parameterized '

Re: [Firebird-net-provider] Problem with stored proc and blob parameter

2006-06-21 Thread Jiri Cincura
Is the SP parametr sub_type text? -- Jiri Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support.

[Firebird-net-provider] Problem with stored proc and blob parameter

2006-06-21 Thread Le roy Arnaud
hello in this exemple i have this error message "error to convert string to byte[]" conn = new FbConnection(_fbConnectionString); FbCommand cmd = new FbCommand("PROFILES_SETPROPERTIES", conn); conn.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(CreateInputParam("@Applic

Re: [Firebird-net-provider] Connection to Embedded 1.5.3 Serverfails with RC5, worked with RC3

2006-06-21 Thread Carlos Guzmán Álvarez
Hello: > > Rasha, Carlos; > > > > *1.* I did a build of the HEAD and it works fine using the connect > string as follows: > > conn = new > FbConnection(@"Database=D:\\VisualAttorney_DATA\DATABASE.FDB;ServerType=1"); > Great !!! > > > -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blo

Re: [Firebird-net-provider] Fwd: Provider .NET error! any suggestion?

2006-06-21 Thread Carlos Guzmán Álvarez
Hello: Sorry for the delay. > And the version of provider? > > Your code works fine for me, I've only commented out > '//fbcnnbuilder.ServerType = FbServerType.Context;' line. > Context should be used only in Fyracle stored procedures implementations -- Carlos Guzmán Álvarez Vigo-Spain htt

Re: [Firebird-net-provider] Connection to Embedded 1.5.3 Serverfails with RC5, worked with RC3

2006-06-21 Thread Warren Anderson
Rasha, Carlos;   1. I did a build of the HEAD and it works fine using the connect string as follows: conn = new FbConnection(@"Database=D:\\VisualAttorney_DATA\DATABASE.FDB;ServerType=1");     2. RC5 does not work with conn = new FbConnection(@"Database=D:\\VisualAttorney_DATA\DATAB

Re: [Firebird-net-provider] Fwd: Provider .NET error! any suggestion?

2006-06-21 Thread Jiri Cincura
And the version of provider? Your code works fine for me, I've only commented out '//fbcnnbuilder.ServerType = FbServerType.Context;' line. BTW you can send a small solution to test it here. -- Jiri Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com _