Re: [Firebird-net-provider] problem

[<car...@te...>]

Hello:

> i have little problem with:
> Unhandled Exception: FirebirdSql.Data.Firebird.FbException: arithmetic
> exception, numeric overflow, or string truncation
>
> i use win1252 coding and slovak collation...
> i have set in connection string
> Pooling=true;Charset=WIN1252


Making what?? What is the charset of the database??

> pooling is not working too... because connection open takes more then 1

> sec...


A sample on how connection pooling work (at this moment connection 
pooling can have problems :) ):

			FbConnection myConnection1 = new FbConnection(GetConnectionString());
			FbConnection myConnection2 = new FbConnection(GetConnectionString());
			FbConnection myConnection3 = new FbConnection(GetConnectionString());

			// Open two connections.
			Console.WriteLine ("Open two connections.");
			myConnection1.Open();
			myConnection2.Open();

			// Now there are two connections in the pool that matches the 
connection string.
			// Return the both connections to the pool.
			Console.WriteLine ("Return both of the connections to the pool.");
			myConnection1.Close();
			myConnection2.Close();

			// Get a connection out of the pool.
			Console.WriteLine ("Open a connection from the pool.");
			myConnection1.Open();

			// Get a second connection out of the pool.
			Console.WriteLine ("Open a second connection from the pool.");
			myConnection2.Open();

			// Open a third connection.
			Console.WriteLine ("Open a third connection.");
			myConnection3.Open();

			// Return the all connections to the pool.
			Console.WriteLine ("Return all three connections to the pool.");
			myConnection1.Close();
			myConnection2.Close();
			myConnection3.Close();



>
> using alpha 3...
>
> I think, that autor is not english native, so it is probable, that
> pronlem is on my side, but i dont know where...


I´m spanish.




Best regards
Carlos Guzmán Álvarez
Vigo-Spain