Re: LINKED server problem..
- From: "oj" <nospam_ojngo@xxxxxxxx>
- Date: Sun, 25 Jun 2006 12:33:12 -0700
you'd want to start here:
http://support.microsoft.com/kb/280106
--
-oj
"Daniel" <Daniel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0475374F-7DA1-441B-B30E-4BDC7295149D@xxxxxxxxxxxxxxxx
Hi All,
Here is the problem:
I want to link my sql server 2000 with oracle server and i used Linked
Servers feature under Security in SQL Server Enterprise Manager. I succeed
to
configure and can view all the table name (not content) whihc belong in
Oracle database.
So, i try to use Query Analyser to pull some data from the linked server.
After i run, here is my error message:
Server: Msg 7320, Level 16, State 2, Line 1
Could not execute query against OLE DB provider 'OraOLEDB.Oracle'.
OLE DB error trace [OLE/DB Provider 'OraOLEDB.Oracle'
ICommandText::Execute
returned 0x80040155].
Any ideas? Please advice.
thank you in advance.
regards,
Ocurnos.
.
- Prev by Date: Re: sql2k5 security
- Next by Date: Re: Problems changing the password for the service account in SQL 2000
- Previous by thread: setup an asymmetric key
- Next by thread: Re: Problems changing the password for the service account in SQL 2000
- Index(es):
Relevant Pages
|
|
