Field is not Blob
Posted: Wed 23 Mar 2016 04:55
Delphi Xe2
Unidac 6.2.10
MSSQL 2008
I try to read a blob field on MSSQL on a simple table like this
ID varchar(50)
FBlob varBinary(MAX)
connection options
Uniconnection.SpecificOptions.Values['Provider'] := 'prDirect';
open table as usual ...
....
Stream := WuSchema.CreateBlobStream(WuSchema.FieldByName('FBlob'), bmRead);
raise exception "Field is not BLOB'
if i change connection options
Uniconnection.SpecificOptions.Values['Provider'] := 'prNativeClient';
it's work !
Let me know
bye
Carlo
Unidac 6.2.10
MSSQL 2008
I try to read a blob field on MSSQL on a simple table like this
ID varchar(50)
FBlob varBinary(MAX)
connection options
Uniconnection.SpecificOptions.Values['Provider'] := 'prDirect';
open table as usual ...
....
Stream := WuSchema.CreateBlobStream(WuSchema.FieldByName('FBlob'), bmRead);
raise exception "Field is not BLOB'
if i change connection options
Uniconnection.SpecificOptions.Values['Provider'] := 'prNativeClient';
it's work !
Let me know
bye
Carlo