i am running a web site with full login etc powered using my sql server
we use an internal data system running on oracle... i need the data for the web from that oracle db
to run reports in crystal staff 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
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.
I have tried a connection specifying Product Name as the db name and the data source as the server name adding in a security user with the usernme and password.
When simply trying to view tables i get:
error 7399 OLE DB provider 'OraOLEDB.oracle' reported an error
OLE DB error trace [OLE/DB provider IDBInitialize: initialize returned 0x80004005:]
not sure where i'm going wrongor if i've just entered the wrong detail in each section??