Professional Web Applications Themes

How to import ORACLE BLOB data into SQL 2K - Microsoft SQL / MS SQL Server

I believe that I have done this before successfully. I am assuming you tried it? Thanks, Greg H "Chow" <com> wrote in message news:032001c35c56$ad1d3060$gbl... ...

  1. #1

    Default Re: How to import ORACLE BLOB data into SQL 2K

    I believe that I have done this before successfully. I am assuming you
    tried it?

    Thanks,
    Greg H

    "Chow" <com> wrote in message
    news:032001c35c56$ad1d3060$gbl... 


    Greg Guest

  2. #2

    Default Re: How to import ORACLE BLOB data into SQL 2K

    Greg,
    I can transfer regular data type but not BLOB. If you did
    it before would you kindly give me more information about
    how you did it.
    Thanks.

    Chow 
    am assuming you [/ref]
    how 
    >
    >
    >.
    >[/ref]
    PChow Guest

  3. #3

    Default Re: How to import ORACLE BLOB data into SQL 2K

    DTS does support the Oracle BLOB datatype when the package connection to
    Oracle uses the Oracle supplied Oracle OLEDB provider.

    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


    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!
    Carl Guest

Similar Threads

  1. Question Sql Sript to Import Data from a XML file into a oracle table
    By Denzil in forum Brainstorming Area
    Replies: 0
    Last Post: August 11th, 10:00 AM
  2. #38921 [NEW]: pdo lost the first row data:with firebird blob data
    By achun dot shx at gmail dot com in forum PHP Bugs
    Replies: 2
    Last Post: January 27th, 12:54 PM
  3. insert blob in oracle (CF_SQL_BLOB) not working
    By shahzad in forum Coldfusion Database Access
    Replies: 2
    Last Post: March 30th, 02:56 PM
  4. Replies: 5
    Last Post: August 14th, 05:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139