[Firebird-net-provider] problem using a proxy to the firebird service

hi all, i'm using firebird 2.1 super server as window service on a win xp sp3. I'm working with local application (the client applications are on the same machine). i'mt trying to use FbScanner (http://www.ibphoenix.com/main.nfs?a=ibphoenixpage=ibp_fbscanner), an application that will intercept

[Firebird-net-provider] massive data insertion

hi, i must do a massive data insertion (~10 milion rows) using ado.net/firebird net provider on a single table. what expedients can i do to speed it? (i'm not very good in databses so also simple suggestions are good) - there's a single index wich i will destroy/recreate before/after the

Re: [Firebird-net-provider] web providers support

with the assembly bindings i resolve my problems, thanks! only another question, the sql script to initialize the db is not embedded in the dll, right? so i must run it by hand when i create/rebuilt the db --

[Firebird-net-provider] problem with a query (maybe a bug)

hi all, i'm using the client 2.5.2.0 from a net 2.0 project with a window fb server i have ths tables: table:user_infos column: ID integer table view_infos column:ID integer table:User_Views_Map column: view_id integer //FK to view_infos.ID column: User_Id integer //FK to user_infos.ID

Re: [Firebird-net-provider] problem with a query (maybe a bug)

How do you do the query directly to firebird ? i did the query using directly the parameter value (as integer and string) :) it's this query cannot by done with the parameter in this place can samebody help me to rebuilt it?

Re: [Firebird-net-provider] problem with a query (maybe a bug)

thanks all, i resolved reweiting the query in another way, i was using this query becouse it's autogenerate with nhibernate -- ___ Firebird-net-provider mailing list

[Firebird-net-provider] disable truncation for longer varchar parameter

hi all, i have a table with a column varchar(50). if i do an insert with a parameter with a string of 51 chars with ado.net /firebird data provider the string is silently truncate (i try it using a prameter, not putting it directly in the sql). there's same way to get an exception(as 'arithmetic

Re: [Firebird-net-provider] disable truncation for longer varchar parameter

i had read it (Parameter handling reworked according to SqlClient behavior. When the value is longer than declared size, the value is truncated.) but i hope that this behaviour can be changed with same settings or workaround becouse for me it's not acceptable to save invalid sting truncating

Re: [Firebird-net-provider] disable truncation for longer varchar parameter

i already validate on ui side, but if also the db will throw an exception it's an additional help to find errors/bugs. if with param lenght you mean FbParameter.Size then there will be no excpetion also without setting it this code will silently truncate the long text using

[Firebird-net-provider] problem with a random io exception

hi all, i have a form application which will create/insert data into a firebird db. i'm using fb embedded 2.5 with the net provider 2.6 (and nhibernate). my application works on a single table, it will insert a single row per transaction with a low rate (10 insert for minute). my problem is that

Re: [Firebird-net-provider] problem with a random io exception

but i didn't find that entry in firebord.conf. thanks Da: Jiri Cincura disk...@cincura.net A: korkless korkl...@yahoo.it; For users and developers of the Firebird .NET providers firebird-net-provider@lists.sourceforge.net Cc: Inviato: Giovedì 24 Febbraio 2011 10:46 Oggetto: Re: [Firebird-net

[Firebird-net-provider] question about 3.5 support

hi, i have downloaded code from https://firebird.svn.sourceforge.net/svnroot/firebird/NETProvider/trunk , the problem is that the project is  for 4.0 compiler only so i want know if there's same other repository with code for 3.5 compiler. (please don't tell me that only 4.0 is supported :( )

Re: [Firebird-net-provider] question about 3.5 support

thanks for the fast reply, i tried to target 3.5 with NET_35; (ENTITY_FRAMEWORK;) (TRACE;) but it doesn't compile. for example FirebirdSql.Data.Services.FbTrace has a default parameter in the method void DoSimpleAction(int action, int? sessionID = null) that is supported only by 4.0

[Firebird-net-provider] can i cache table schema?

hi, i'm using the 2.6.5.0 for net 2.0. i have a service which use a dbdataadapter every minute to insert data into a single table (the istance is recreate every time becouse i need thread safety), i see that it calls every time the method FbDataReader.GetSchemaTable to get the schema from the

[Firebird-net-provider] what is the correct way to close the trace api service?

hi, i'm tring to use the trace api but i have same problems to correctly close the trace service. the call to fbTraceIstance.start(sessionName) will never return so this code will not works fbTraceIstance.start(sessionName) //next code will never execute Console.WriteLine(started, press