Querying Oracle BLOBs and SQL Server images 
Author Message
 Querying Oracle BLOBs and SQL Server images
I'm trying SELECT real-time data from Oracle to an SQL
Server.  The SQL Server is linked to the Oracle Database.  
I can SELECT fine, except for a table that has an Oracle
BLOB field.  I need to be able to take the Oracle BLOB
field and place it in an SQL Server image field and vice-
versa.  Currently I get an OLE DB provider error that says
datatype not supported.  If I need to change the field
type on either side I can do that.  The BLOBs/images are
JPEGs.

Any ideas?

Thanks,
Terry



Fri, 06 Jan 2006 20:30:40 GMT
 Querying Oracle BLOBs and SQL Server images

<
Currently I get an OLE DB provider error that says datatype not
supported.
Microsoft's Oracle OLEDB provider does not support CLOB, BLOB, BFILE,
NCHAR, NCLOB, and NVARCHAR2.  See the Knowledge Base article titled
"INFO: Limitations of Microsoft Oracle ODBC Driver and OLEDB Provider"
at http://support.microsoft.com/default.aspx?scid=kb;en-us;244661

Instead, use the Oracle supplied Oracle OLEDB provider which will work
with MDAC 2.6 and 2.7 and does support these data types.  

Carl Federl
Please post DDL (create table) with datatypes, primary and foreign keys.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Fri, 06 Jan 2006 22:00:46 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Converting BLOB(Oracle) data to IMAGE(SQL Server) data

2. Sample code needed for retrieve image as BLOB from Oracle 8 server

3. Image Blobs in SQL Server 7

4. Images in BLOB fields in SQL Server

5. How to get an GIF file into an ODBC-SQL Server Image datafield (BLOB)

6. How to get an GIF file into an ODBC-SQL Server Image datafield (BLOB)

7. How to insert a ntext , image(BLOBs) data into SQL Server 2000

8. Help with passing an SQL Server Image field (BLOB) to a DLL

9. Images in BLOB fields in SQL Server

10. Image Blob Problems in SQL Server 7

11. Image Blob Problems In SQL Server 7

12. Sybase to Oracle conversion: Problem loading sybase image data into oracle blob


 
Powered by phpBB® Forum Software