Image vs Varbinary(Max)

[Former Member]

Hello Ludek,

The problem is that Microsoft is deprecating the image datatype and telling people to use Varbinary(Max) as the new data type:

The two are considered equal (image probably wasn't a good choice of name).

The problem we have at LabWare is that we have to use the Varbinary(Max) in 2 tables that can contain images in future releases of SQL server. In order for that to work, we are obliged to use any of the SQL native client ODBCs. That works to get the data into the database. The problem comes with the Crystal that treats Varbinary(Max) as string 255 when using the SQL native client ODBCs.

I've done a simple report connected to the field that is Varbinary(max). I can see the image in the report using SQL server ODBC but not with the SQL Native client (any of them)

I am using Crystal reports Crystal Reports 8.5, XI, 2008 and 2013

Thank you.

Peter

[former_member11696]

Hi Peter,

Can you explain what MS Native client is that you are using?

As of CR 9 I think, we no longer shipped a CR Native SQL Server database dll, only option now is to connect via ODBC or OLE DB using the MS SQL Native 10 or 11 clients.

Also, CR 8.5 cannot be on the same PC as the other versions, it did not support side by side installs, had to be on a separate PC with no other versions of CR Designer or runtime.

Also, no upgrade for 8.5 but you can get CR XI R2 from here:

http://downloads.businessobjects.com/akdlm/crystalreports/crxir2_sp4_full_bld_0-20008684.exe
http://downloads.businessobjects.com/akdlm/crystalreports/CRYSTALREPORTS06_0-20008684.EXE

Use your XI Keycode to install it.

Don