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"
------------------------------------------------------------------------------
Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
