linked server to oracle

[davejam]

Hi all,

Sorry if this has been asked, had a look through previous threads but am really lost still....

my scenario...
i am running a web site with full login etc powered using my sql server... think its sql2000 (only just looked at it, doesn't seem to have the extra stuff 05 has)

they run an internal data system running on oracle... all data i need is in that oracle db

to run reports in crystal they use 'oracle net manager' for their connection which lets them run their full info and get their reports.

i need to get this type of detail to correspond with my sql users etc so need to link the server in some way

when i go to linked servers NEW not sure what to use
should i use 'microsoft OLE DB provider for oracle' or 'oracle provider for ole db'

on both of these options i then get asked for
Product Name:
Data source:
Provider String:

not sure what i need for these, i have the db name, server name, server IP, username and password for the oracle db, just not sure what order and if i have all information.

also i read somewhere about having oracle installed on my sql server... if orable net manager can connect, should this not mean i can get sql to connect, or somehow use this oracle net manager to connect the linked server.

not sure if i'm missing the point, i'm just a little lost here....

thankyou for any suggestions, ideas or possible solutions.

Cheers

daveJam

*two wrongs don't make a right..... but three lefts do!!!!*

 

[mrdenny]

You need to setup Net8 on the server and make sure that it's working.

Then use the Net8 alias for the Product Name and Data Source. In the drop down menu select the Oracle provider.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog