Problems with SQL-Server CE 2.0

[Guest]

Hello

I have problems to write images into the SQL CE Database
I get one array from the SQL-Server 2000 and want to write this into the SQL CE Database
But everytime I insert the Array into the SQL-Server CE i get one error message
At both time I use the <image> datatype

Is somthing special by the SQL-Server CE
I can insert all other data without any problems

Thanks for you help

regard

Brave

 

[Jon Heide]

Hello Brave,

A couple questions for you.

(1) What is the error message that you are receiving?
(2) Are you using replication or RDA for retrieving the data from SQL server?

If you are inserting data into the image data type, you may be having a conversion problem. Data must insert it as hexadecimal into the
image datatype. For more information on inserting and storing images see:

http://support.microsoft.com/default.aspx?scid=kb;en-us;318639

Thanks,


Jon Heide
([email protected])
SQL Server CE Team
Microsoft

----------------------------------------------------------------------------

Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp

----------------------------------------------------------------------------

This posting is provided "AS IS" with no warranties, and confers no rights.

Use of included script samples are subject to the terms specified at

http://www.microsoft.com/info/cpyright.htm.

----------------------------------------------------------------------------