Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connecting from SQL to Oracle using OPENROWSET()

Status
Not open for further replies.
alexm

alexm

Programmer
Oct 9, 2000
4
0
0
ZA
Hi,

I need help I need to connect to Oracle from within a SQL stored procedure - how would I do this - could I use the OPENROWSET() and if so how would I use it - I've tried a couple of things.

Please let me know.

Thanks
Alex
 
Status
Not open for further replies.

Similar threads

V
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
202
Volvere
V
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
118
Mike Lewis
Mike Lewis
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
166
pjw001
pjw001
bharons
  • Question
Pick up value from combobox
Replies
0
Views
141
bharons
bharons
Cpreston
  • Question
Seconds to minutes 2
Replies
5
Views
272
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top