Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2003
    Posts
    1,074

    Unanswered: Can Oracle connect via OLE DB?

    I've been googling this for about 30 minutes, and all I can find is that Oracle itself can be accessed using OLE DB.

    What I want to know is, can Oracle read in a file (a SAS dataset in this case) using OLE DB? We already have the OLE DB driver, and were able to read in the SAS dataset using Excel. Now, we want to try it with Oracle.

    Thanks,
    Chuck

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >and were able to read in the SAS dataset using Excel.
    >Now, we want to try it with Oracle.

    I am not clear on what you hope to accomplish.

    On a PC with Oracle client installed, Excel can open a connection into Oracle using ODBC.
    After the connection was opened, SQL can be issued against the Oracle DB.

    Close enough?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2003
    Posts
    1,074
    Opposite direction. This is how I see it working in a perfect world:

    Create an external table in Oracle which points to a SAS dataset, via an OLE DB Provider. Then I could query that data using Oracle.

    SQL Server allows this to happen via something they call "shared servers", and I wasn't sure if Oracle had anything similar.

    And this is using OLE DB instead of ODBC, since the SAS ODBC driver requires that you have a SAS add-on we do not own (SAS SHARE), which allows you to leverage SAS running on the server to process your request to read the dataset. OLE DB is passive, and puts the processing burden on the machine which has the OLE DB Provider installed.

    --=Chuck

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You might be able to jury rig a remote connection via Hetrogenous (sp?) Services; then again might not.

    Beyond this, I am out of ideas.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    As for as I know, oracle can not be controlled via OLE calls. Oracle forms can issue OLE calls, but it doesn't have an OLE server in the database.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  6. #6
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    ---
    "It does not work" is not a valid problem statement.

  7. #7
    Join Date
    Dec 2003
    Posts
    1,074
    Honestly, I couldn't tell you if there was a difference between OLE, and OLE DB, as this is the first time I've been unable to just use something simple like ODBC. --=cf

Posting Permissions

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