|
Home > Archive > MS Access data conversion > June 2005 > Ole-object to image
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Ole-object to image
|
|
| Bjarne Anker 2005-06-09, 3:24 am |
| Hi,
I've developed an application in Access2K using jet database, but now I want
to move the database to MS SQL Server.
I've designed the database and done some adjustments to the relations, and
now it's time to copy the data.
The copying will be runned automatically for each user, so i have to program
it using recordsets. It works fine, except copying embedded images.
I have a logo field in the mdb-table and when i copy it to SQL Server it
won't show in the form no more.
I've learned that Access adds a *lot* of header information when you insert
an image in an Ole-object field, so those headers are not the same in SQL
Server i guess?
Any tips og funtions to get the image data over to SQL Server?
I've managed to strip the Ole-object headers so i can write the image to
disk and view it. So maybe i have to add SQL Server headers to the file
before i put it back?
Anything would be helpful!
Thanks in advance,
Bjarne Anker
| |
| Bjarne Anker 2005-06-09, 7:24 am |
| Nevermind, i found the soultion.
I used GetChunk and AppendChunk to copy the data, and it worked like a
charm..:)
Bjarne
"Bjarne Anker" <d-light@spray.no> skrev i melding
news:uRJxElMbFHA.3328@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I've developed an application in Access2K using jet database, but now I
want
> to move the database to MS SQL Server.
> I've designed the database and done some adjustments to the relations, and
> now it's time to copy the data.
> The copying will be runned automatically for each user, so i have to
program
> it using recordsets. It works fine, except copying embedded images.
> I have a logo field in the mdb-table and when i copy it to SQL Server it
> won't show in the form no more.
> I've learned that Access adds a *lot* of header information when you
insert
> an image in an Ole-object field, so those headers are not the same in SQL
> Server i guess?
>
> Any tips og funtions to get the image data over to SQL Server?
> I've managed to strip the Ole-object headers so i can write the image to
> disk and view it. So maybe i have to add SQL Server headers to the file
> before i put it back?
> Anything would be helpful!
>
> Thanks in advance,
>
> Bjarne Anker
>
>
|
|
|
|
|