trying to link server to oracle...

  • thanks, and i will look into it and let you know how it went.

  • I usually take this route: http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/[/url]

    I also usually create a local ODBC > System DSN connection, via the TNSNAMES.ora file, so that I can verify my credentials and general connectivity.

    Make sure your client and the version of Oracle match. Also be sure to get the proper tnsnames file from your oracle admin.

  • Well I have to say it worked. thanks to everyone who took the time to reply!!! :satisfied:

Viewing 3 posts - 16 through 17 (of 17 total)

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