Results 1 to 2 of 2

Thread: BLOB or CLOB ORACLE with aspDb ??

  1. #1
    varimed Guest

    BLOB or CLOB ORACLE with aspDb ??

    Hello,

    How can we use CLOB or BLOB in ORACLE 8 databases with aspDB ?
    With Oracle ODBC driver from Microsoft it doesn't work !
    Please help

    Thanks

  2. #2
    Frank Guest

    BLOB or CLOB ORACLE with aspDb ?? (reply)

    1. Visit the following and read it -
    http://www.kingkwong.com/HTMLDOC/Oracle.shtm

    2. ORACLE ODBC driver never worked with ASP/ADO, you HAVE to use MS's ORACLE driver.

    3. ORACLE BLOB is suportted just like others.

    4. For CLOB and other types. Do the following -
    *Build an ORACLE DB with the types.
    * Do a Datatype display using the pure asp file shipped with the ASPdb package and identify the data types of the fields. Invalid result means that datatype (CLOB or others ?) is not supported by the driver hence there is nothing you can do. Try both ODBC and OLEDB drivers. Always put the BLOB and MEMO fields a the end of the SELECT statement in your test.

    5. If you got a data type and cannot get it going then send me E-mail and sample database using EXP80.


    Frank



    ------------
    varimed at 12/6/99 4:45:56 PM

    Hello,

    How can we use CLOB or BLOB in ORACLE 8 databases with aspDB ?
    With Oracle ODBC driver from Microsoft it doesn't work !
    Please help

    Thanks

Posting Permissions

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