current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help
Stack Overflow is a community of 4.7 million programmers, just like you, helping each other.

Join them; it only takes a minute:

Sign up
Join the Stack Overflow community to:
  1. Ask programming questions
  2. Answer and help your peers
  3. Get recognized for your expertise
up vote 1 down vote favorite

I have PostgreSQL database in version 9.1 with table that contains column named BinContent configured as BYTEA data type. My target is to migrate/convert this table to Microsoft SQL Server (2008) column configured as IMAGE data type.

When I'm trying to do that conversion i got following error:

OLE DB provider "MSDASQL" for linked server "POSTGRES2" returned message "Requested   conversion is not supported.". 
Msg 7341, Level 16, State 2, Line 1
Cannot get the current row value of column "[MSDASQL].bincontent" from OLE DB provider "MSDASQL" for linked server "POSTGRES2".
share|improve this question
    
Are you the same person who asked importing a CSV containing an image from MS-SQL into PostgreSQL? – Craig Ringer May 14 '14 at 12:30
    
Nope. I don't know that post. – xsqr May 14 '14 at 19:37
    
Huh, it must just be import-from-mssql-day. Funny. Can't really help you on this one, as the error seems to be on the MS-SQL side and I haven't used it much at all. – Craig Ringer May 15 '14 at 1:48

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.