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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-08 : 08:46:45
|
| Eric writes "Hi,I've been digging msdn and books online about how to connect my transact sql query to an oracle server without using linked server. I'm currently exploring OpenDatasource and OpenRowset but I can't quite make it work. Here's what the code looks like.SELECT *FROM OPENROWSET( 'MSDAORA.1', 'Password=XXX;User ID=ORCLlOGIN;Data Source=TNSNAMESlink',oracletablename)-- it gives me this errorServer: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'MSDAORA.1' reported an error. [OLE/DB provider returned message: ORA-12560: TNS:protocol adapter error]Am I using the function properly? or do you have a sample of this kind? Thanks in advance and hope to hear from you." |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-07-08 : 12:19:10
|
| Your statement looks correct. I would guess the problem lies in the Oracle driver.-Chad |
 |
|
|
|
|
|
OpenDataSource/OpenRowset to Oracle