Showing posts with label knows. Show all posts
Showing posts with label knows. Show all posts

Tuesday, March 27, 2012

Converting bytes [] to an SQL CE 3 image type to store

Hi,

I was wondering if anyone knows how to convert an array of bytes to an SQL CE 3 image type and vice versa.

I am using the SDF Signature control and I would like to store the signature as an Image. It needs to be an image so it can be synced with a desktop access 2003 database.

Cheers

Simon

I have got around this by changing the Image type to nText then converted the byte array to a base64 string and this works a treat.

Cheers

Simon.

|||

Better way to do it would be to create memory stream from byte array from SQL and pass it to bitmap constructor:

Bitmap bmp = new Bitmap(new MemoryStream(byteArrayFromSqlCe));

Thursday, March 22, 2012

Converting 2000 Reporting Services Reports to 2005!

Idea Hi There,
just wondering if anyone knows how to convert 2000 reports to 2005? any hints or resources would be greatly appreciated, having trouble finding it out on the web

Thanks!
As far as my experiences, all RS 2000 reports will normally work on RS 2005 without any problem, you don't need to do too much unless you want to use the cool features of RS 2005.

Tuesday, February 14, 2012

Convert from Clarion to MS SQL Server or Access

Hello!

Somebody knows how to convert the data from Clarion (tps) to mdb or mdf files?
Any variants?

Thanks to all!

I don't know much about Clarion, well, nothing.
There seems to be plenty of ODBC drivers for it though.
You could then use SSIS to import the data into SQL. You cannot as such "convert" anything to mdf. You can import it into SQL though.

http://www.google.co.uk/search?q=clarion+odbc+drivers&sourceid=navclient-ff&ie=UTF-8&rlz=1B3GGGL_enGB213GB213|||Crispin, thanks for the time, given to my question.