Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
guidoia
Starting Member
2 Posts |
 Posted - 2009-02-13 : 09:16:20
|
| I have a server running SQL Server 2005 with 5 applications. It also has IIS and 2 of the applications are accessed through the web interface to the server. We are adding a new application and some of the info needed is in our Oracle database on another server. The Vendor wants us to put the Oracle Client (9g or 10g) on the SQL server. What is the likelyhood this will affect the other applications on the SQL server in a negative way? Is this even a good idea? If not, what kind of problems will I experience?Thanks,Mark |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2009-02-13 : 09:27:43
|
| What is the intent of installing the Oracle client? Is there software that will run on the database server or will you be utilizing linked servers in SQL Server pointing to Oracle? We use this setup very extensively (linked servers to Oracle) for the past 7 or so years and it works fine. It's just a matter of configuration and making sure you have enough memory on the box. |
 |
|
|
guidoia
Starting Member
2 Posts |
Posted - 2009-02-13 : 09:40:26
|
| Yes there is new software running on the SQL server. Instead of entering all the users and info again they want to connect it to our existing Oracle database. |
|
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2009-02-13 : 10:44:09
|
| I'm sorry, but you will need to better describe what you are trying to accomplish. Aside from that, I can tell you this... we have the Oracle client installed on our SQL Servers and utilize linked servers to communicate to Oracle and it works fine. |
|
|
|
|
|
|
SQL and Oracle Client