Oracle Connectivity Issue
- From: "Tony Sebion" <tony@xxxxxxxxxx>
- Date: Wed, 3 Aug 2005 08:42:07 -0500
I've worked at sites with this configuration (SQL 2000 with an Oracle
linked server) before with success.
If I remember right, the only complications we ran into different than a
single server setup was that the account that the DTC service runs as
(Network Service) must have permissions to use your Oracle drivers if
you are running transactions that begin on the SQL Server and use the
linked Oracle server.
You also will need to make sure that you're installing the DTC
components from the Oracle driver setup, but my guess is that you're
already familiar with that in your current configuration.
Good luck,
Tony Sebion
-----Original Message-----
From: PrabaharaprabuS [mailto:PrabaharaprabuS@xxxxxxxxxxxxxxxxxxxxxxxxx]
Posted At: Wednesday, August 03, 2005 5:39 AM
Posted To: clustering
Conversation: Oracle Connectivity Issue
Subject: Oracle Connectivity Issue
Now i am going to install sql server clustering , at presnet sql server
2000 enterprise edition and oracle client installed in the
server,through linked server (oracle and sql server) transfering data.
if i included sql server clustering any problem will be there?
Regards
Suresh
.
- Prev by Date: Problems reapairing a node in a Virtual Server Cluster
- Next by Date: minimal hardware requirement for SQL failover clustering
- Previous by thread: Oracle Connectivity Issue
- Next by thread: Problems reapairing a node in a Virtual Server Cluster
- Index(es):
Relevant Pages
|
