[Firebird-net-provider] Large messages/attachments

2006-10-17 Thread Helen Borrie
Hello List, Several messages today have been rejected because they were large, or had large attachments - in one case 650 Kb in picture-perfect screenshots! One list member wrote to me asking for the 40 Kb size limit to be increased... The answer is No. It's a Sourceforge limit. Let's not c

Re: [Firebird-net-provider] Params for stored procedure

2006-10-17 Thread Jiri Cincura
> read the datatype from the DB server anyway and do an automatic conversion. It should, but DDEX stuff isn't so easy to control :) -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Using Tomc

Re: [Firebird-net-provider] Params for stored procedure

2006-10-17 Thread Rick Roen
Yes, that was it! I didn't see where to set the param type, and I assumed that VS.Net would read the datatype from the DB server anyway and do an automatic conversion. Thanks for all your help Jiri. Rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of J

Re: [Firebird-net-provider] Params for stored procedure

2006-10-17 Thread Jiri Cincura
Rick Roen wrote: Then I right click on the TableAdapter and select preview, fill in the params and get the error like below. Look at the att. You have to change the type of params to Int64 according to your definition in DB, not the Object as you have. How are you entering the “Select * fro

Re: [Firebird-net-provider] Attempted to read or write protected memory. This is often an indication that other memory is corrupt

2006-10-17 Thread Carlos Guzmán Álvarez
Hello: > I get this error when I try read the FbDataReader Please, send a test case with database included, and tell the version of the firebird server, the ado.net provider, the .net framework you are using. - Using Tomcat

Re: [Firebird-net-provider] Still problems with Firebird 2.0 and .NET 1.1

2006-10-17 Thread Carlos Guzmán Álvarez
Hello: > Hi again Carlos, > > As Rubén said earlier today, we can't make the provider work with Firebird > 2.0. We can now compile, but no way to run it correctly? > > Is there anything missing from the CVS? Is it really a fixed problem? > Please, retry with the latest CVS sources, connection l

Re: [Firebird-net-provider] How disable FB Server warnings(Exceptions)

2006-10-17 Thread Robert Pawlowski
>> Use the try-catch/try-finally block... Yes, yes ... :-) But this command is not executed on Server site, is ignored with warning ( exception ) :-( -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ---

Re: [Firebird-net-provider] How disable FB Server warnings (Exceptions)

2006-10-17 Thread Jiri Cincura
Robert Pawlowski wrote: > Hi > > > > How can I disable FB Server warning ( in user application exception ) > when I execute script provided for dialect 3 on database with dialect 1 > (for example: creation add column type DATE instead TIMESTAMP )? Use the try-catch/try-finally block... --

[Firebird-net-provider] FW: Params for stored procedure

2006-10-17 Thread Rick Roen
I can't get this to post with the attachments since they are over the 40K limit. I can send the gifs to anyone who wants to see them. Rick -Original Message- From: Rick Roen [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 11:51 AM To: 'For users and developers of the Firebird

[Firebird-net-provider] How disable FB Server warnings (Exceptions)

2006-10-17 Thread Robert Pawlowski
Hi   How can I disable FB Server warning ( in user application exception ) when I execute script provided for dialect 3 on database with dialect 1 (for example: creation add column type DATE instead TIMESTAMP )? Robert   ---

Re: [Firebird-net-provider] Params for stored procedure

2006-10-17 Thread Jiri Cincura
Rick Roen wrote: > Then in VB.NET 2005 Pro I add a new table adapter in the Select using this sp. Then when I right click for Preview and fill in the data, InNum1=10 and InNum2=2 I get the error message. Can you be more specific, i.e. the select what you use? As you can see in att. I've no p

[Firebird-net-provider] DatagridViewComboBoxCell value is not valid

2006-10-17 Thread Mafc
Hello,  When I try add a DataGridViewComboBoxColumn I get the error:DatagridViewComboBoxCell value is not validCan I help me?TranksThis is the code :     Friend column_combo As DataGridViewComboBoxColumn = New DataGridViewComboBoxColumn()    FbConnection.Open()    dbDataAdapter

Re: [Firebird-net-provider] Params for stored procedure

2006-10-17 Thread Rick Roen
Here is a very simple procedure that I think you can easily duplicate in your DB. SET TERM ^^ ; CREATE PROCEDURE P_MOD ( INNUM1 BigInt, INNUM2 BigInt) returns ( MODULUS BigInt) AS /* get the mod of INNUM1 MOD INNUM2 */ begin if ((INNUM1 is null) or (INNUM2 is null) or (INNUM2 = 0)) then

[Firebird-net-provider] Attempted to read or write protected memory. This is often an indication that other memory is corrupt

2006-10-17 Thread Mafc
I get this error when I try read the FbDataReader Friend FbConnection As FirebirdSql.Data.FirebirdClient.FbConnectionFriend SQL As StringFriend dbDataAdapter As FirebirdSql.Data.FirebirdClient.FbDataAdapterFriend dbDataSet As New Data.DataSetFriend dr As FbDataReader..FbConnection

Re: [Firebird-net-provider] Params for stored procedure

2006-10-17 Thread Jiri Cincura
Rick Roen wrote: > But I don't think that could be the problem anyway since I get the same > error when I call an sp that has only two input params - both integers with > an integer return value. > Can you provide some test for us, to be able to test it on our builds? -- Jiri {x2} Cincura http:

Re: [Firebird-net-provider] Params for stored procedure

2006-10-17 Thread Rick Roen
Jiri and Carlos, Thanks for your help so far. The charset is ISO8859-1. This is set in the connection string. No, the sp does not have any BLOB's. But I don't think that could be the problem anyway since I get the same error when I call an sp that has only two input params - both integers with