Post reply

where can i find oracle OLE DB provider or oracle

  • August 23, 2003 at 3:51 pm

    #106064

    where can i find oracle OLE DB provider or oracle ODBC so that i can download it as i have oracle 9i currently installed but it does not conect with DTS(i.e) when i try to access tables of oracle in DTS..

  • August 26, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • August 27, 2003 at 10:06 am

    #471637

    Not sure if this is what your are looking for:

    But the ODBC drivers ship with SQL Server.

    If you are in SQL Server and wanting to set up the correct connection you will need to go into design veiw (of DTS), and you can simply click and drag the proper connection property. In this case we would click on the new connection icon (if you into using the GUI) for Microsoft ODBC Driver for Oracle. In order to set up the connection properly you will need the server, username and password.

    Hope this helps.

    Christine


    Aurora

Viewing 3 posts - 1 through 2 (of 2 total)

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