Post reply

What is the script to use ODBC from oracle?

  • March 28, 2002 at 10:06 am

    #57588

    I need to use ODBC to pull information from an Oracle server database. Any one have an example of the script i nee to use for this procedure?

    Darrell R. Whalen Jr.


    Darrell R. Whalen Jr.

  • March 28, 2002 at 1:50 pm

    #426259

    What version of Oracle? And what are you trying to do, usually you use a link server if this needs to be live pulls, or better use DTS to import periodically.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • March 28, 2002 at 2:23 pm

    #426263

    The version is Oracle v8.1.5, what i am trying to do is query the database for specific information and send it out again. I am not putting this into another database it will not be saved, just pulled in then pushed right back out. What is the best way to accomplish this?

    And is there a way to do this in a store procedure?

    Darrell R. Whalen Jr.


    Darrell R. Whalen Jr.

  • March 29, 2002 at 9:26 am

    #426293

    If you will be doing this often then setup a Linked Server (many threads on that here but I can help if no one does by Monday, sorry not at home or near a server), then look at openquery in BOL. If not often you may still want to use a linked server or look and querystring in BOL. But these should help you get what you are after.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply