Connecting to Oracle 9.2.0.7 thru SQL Server 2000

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Connecting to Oracle 9.2.0.7 thru SQL Server 2000

Author

Topic

pras2007
Posting Yak Master

216 Posts

Posted - 2007-08-28 : 01:08:17

Hello All,

I've tried serveral ways to try to connect to Oracle database thru Linked Server without any success. The following Oracle parameters is what I was given.

SAMPLE ONLY

The name of the table is WEEK_DATA

These are the settings I use to connect:
DTCCONHP1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 90.155.52.55)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = teds1)
)
)
Environment Prod: DTTEDS1
DB User : rpt_week_data
DB Password Prod: rpt4weekdata

Does anyone know how to set this up in SQL Server 2000 environment? Please advice. Thanks.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-08-28 : 02:23:00

google it

http://www.databasejournal.com/features/mssql/article.php/3290801

-ec

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-28 : 21:41:30

Create odbc dsn to Oracle db on sql server then create linked server with ole db provider for odbc driver.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources