Are there any news of this problem?
Can anyone else reproduce the error?
Regards,
-H.
El 20/01/2011, a las 12:08, Hernán Martínez escribió:
> El 19/01/2011, a las 22:03, Jiri Cincura escribió:
>> On Wed, Jan 19, 2011 at 17:44, Hernán Martínez <hernan.marti...@ecc.es>
>> wrote:
>>> I'm sure I'm missing something here, because how can FB.NET
>>> know the correct FbDbType in this case?
>>
>> If it's Dynamic SQL Error, it's from server. Without the code, it's
>> hard to guess, maybe you're doing something that isn't supported by
>> Firebird.
>
> I could a make a sample that shows the error. It works fine with
> FB.NET 2.5.2.0 but fails with the new 2.6.0.0
> The connection string use an FbServerType.Embedded and the underlying
> fbembed.dll
> version is 2.1.3.18185.
>
> Here is the code:
>
> DbProviderFactory dbf =
> DbProviderFactories.GetFactory("FirebirdSql.Data.FirebirdClient");
> DbConnection conn = dbf.CreateConnection();
> conn.ConnectionString = connstr;
> conn.Open();
> DbCommand comm = dbf.CreateCommand();
> comm.Connection = conn;
> comm.CommandText =
> "INSERT INTO WITHBLOB ( ID, LONGTEXT ) VALUES ( 10, @LONGTEXT
> )";
> DbParameter p = dbf.CreateParameter();
> p.ParameterName = "@LONGTEXT";
> p.DbType = DbType.String;
> p.Value = "Hello";
> comm.Parameters.Add(p);
> comm.ExecuteNonQuery();
> conn.Close();
>
> The table WITHBLOB is defined as:
>
> CREATE TABLE WITHBLOB
> (
> ID integer,
> LONGTEXT blob sub_type 1
> );
>
> The error was:
> "BLOB and array data types are not supported for move operation"
>
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
