Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Moving phot data from MS Access to ASE 12

10 views
Skip to first unread message

Darren

unread,
Jul 28, 2003, 1:06:39 PM7/28/03
to
Using PB 8 with ASE 12.5

I'm trying to move a column from a MS Access 2000 database to a
table
on ASE 12. The column is a photo and is described as type OLE Object
in
Access. I have tried these methods:

1. When I create the pipeline the source datatype is BigBinary for
this
column. Whenever I try to run the pipeline I get the message:
'Select error. Column lists do not match'.

I have tried having the destination column of type binary, varbinary
and
image.

2. Writing PowerScript and using SelectBlob. When I use SelectBlob
on the MS Access photo column, PB blows up.

How can I transfer this data?

Thanks

0 new messages