server: Running an Oracle Stored Procedure

When using a linked server for calling a remote Oracle stored procedure from
SQL Server 2000 I receive the error :
Server: Msg 7212, Level 17, State 1, Line 1
Could not execute procedure 'ABB_TEST_AMF' on remote server 'ORCLOMD'.
[OLE/DB provider returned message: One or more errors occurred during
processing of command.]
[OLE/DB provider returned message: Syntax error in {call...} ODBC Escape.]
I have tried the following commands:
exec ORCLOMD.OMD.APPS.ABB_TEST_AMF
exec ORCLOMD..APPS.ABB_TEST_AMF
The Microsoft KB Article (ID 873234) recognises this error but no resolution
is provided. Any ideas ?
Linked server using Micrsoft OLE DB provider for Oracle
Oracle client installed on sql server: Oracle 8.1
Oracle database: Oracle 7.3
Hi Narimrajr,
There are some limitation when executing an Oracle procedure within a DTS
package.
If you want to execute an Oracle procedure you must use Oracle ODBC native
drivers and specify the connection, Data Source, to use Oracle Provider OLE
DB
and specify the DNS entry in the properties dialog.
Thanks,
Chandan
"narimrajr" wrote:

> When using a linked server for calling a remote Oracle stored procedure from
> SQL Server 2000 I receive the error :
> Server: Msg 7212, Level 17, State 1, Line 1
> Could not execute procedure 'ABB_TEST_AMF' on remote server 'ORCLOMD'.
> [OLE/DB provider returned message: One or more errors occurred during
> processing of command.]
> [OLE/DB provider returned message: Syntax error in {call...} ODBC Escape.]
> I have tried the following commands:
> exec ORCLOMD.OMD.APPS.ABB_TEST_AMF
> exec ORCLOMD..APPS.ABB_TEST_AMF
> The Microsoft KB Article (ID 873234) recognises this error but no resolution
> is provided. Any ideas ?
> Linked server using Micrsoft OLE DB provider for Oracle
> Oracle client installed on sql server: Oracle 8.1
> Oracle database: Oracle 7.3
>
>
>
|||Also, try calling the Oracle procedure via OPENQUERY
Thanks,
Chandan
"narimrajr" wrote:

> When using a linked server for calling a remote Oracle stored procedure from
> SQL Server 2000 I receive the error :
> Server: Msg 7212, Level 17, State 1, Line 1
> Could not execute procedure 'ABB_TEST_AMF' on remote server 'ORCLOMD'.
> [OLE/DB provider returned message: One or more errors occurred during
> processing of command.]
> [OLE/DB provider returned message: Syntax error in {call...} ODBC Escape.]
> I have tried the following commands:
> exec ORCLOMD.OMD.APPS.ABB_TEST_AMF
> exec ORCLOMD..APPS.ABB_TEST_AMF
> The Microsoft KB Article (ID 873234) recognises this error but no resolution
> is provided. Any ideas ?
> Linked server using Micrsoft OLE DB provider for Oracle
> Oracle client installed on sql server: Oracle 8.1
> Oracle database: Oracle 7.3
>
>
>

server: Running an Oracle Stored Procedure

When using a linked server for calling a remote Oracle stored procedure from
SQL Server 2000 I receive the error :
Server: Msg 7212, Level 17, State 1, Line 1
Could not execute procedure 'ABB_TEST_AMF' on remote server 'ORCLOMD'.
[OLE/DB provider returned message: One or more errors occurred during
processing of command.]
[OLE/DB provider returned message: Syntax error in {call...} ODBC Escape.]
I have tried the following commands:
exec ORCLOMD.OMD.APPS.ABB_TEST_AMF
exec ORCLOMD..APPS.ABB_TEST_AMF
The Microsoft KB Article (ID 873234) recognises this error but no resolution
is provided. Any ideas ?
Linked server using Micrsoft OLE DB provider for Oracle
Oracle client installed on sql server: Oracle 8.1
Oracle database: Oracle 7.3Hi Narimrajr,
There are some limitation when executing an Oracle procedure within a DTS
package.
If you want to execute an Oracle procedure you must use Oracle ODBC native
drivers and specify the connection, Data Source, to use Oracle Provider OLE
DB
and specify the DNS entry in the properties dialog.
Thanks,
Chandan
"narimrajr" wrote:
> When using a linked server for calling a remote Oracle stored procedure from
> SQL Server 2000 I receive the error :
> Server: Msg 7212, Level 17, State 1, Line 1
> Could not execute procedure 'ABB_TEST_AMF' on remote server 'ORCLOMD'.
> [OLE/DB provider returned message: One or more errors occurred during
> processing of command.]
> [OLE/DB provider returned message: Syntax error in {call...} ODBC Escape.]
> I have tried the following commands:
> exec ORCLOMD.OMD.APPS.ABB_TEST_AMF
> exec ORCLOMD..APPS.ABB_TEST_AMF
> The Microsoft KB Article (ID 873234) recognises this error but no resolution
> is provided. Any ideas ?
> Linked server using Micrsoft OLE DB provider for Oracle
> Oracle client installed on sql server: Oracle 8.1
> Oracle database: Oracle 7.3
>
>
>|||Also, try calling the Oracle procedure via OPENQUERY
Thanks,
Chandan
"narimrajr" wrote:
> When using a linked server for calling a remote Oracle stored procedure from
> SQL Server 2000 I receive the error :
> Server: Msg 7212, Level 17, State 1, Line 1
> Could not execute procedure 'ABB_TEST_AMF' on remote server 'ORCLOMD'.
> [OLE/DB provider returned message: One or more errors occurred during
> processing of command.]
> [OLE/DB provider returned message: Syntax error in {call...} ODBC Escape.]
> I have tried the following commands:
> exec ORCLOMD.OMD.APPS.ABB_TEST_AMF
> exec ORCLOMD..APPS.ABB_TEST_AMF
> The Microsoft KB Article (ID 873234) recognises this error but no resolution
> is provided. Any ideas ?
> Linked server using Micrsoft OLE DB provider for Oracle
> Oracle client installed on sql server: Oracle 8.1
> Oracle database: Oracle 7.3
>
>
>

server: Running an Oracle Stored Procedure

When using a linked server for calling a remote Oracle stored procedure from
SQL Server 2000 I receive the error :
Server: Msg 7212, Level 17, State 1, Line 1
Could not execute procedure 'ABB_TEST_AMF' on remote server 'ORCLOMD'.
[OLE/DB provider returned message: One or more errors occurred during
processing of command.]
[OLE/DB provider returned message: Syntax error in {call...} ODBC E
scape.]
I have tried the following commands:
exec ORCLOMD.OMD.APPS.ABB_TEST_AMF
exec ORCLOMD..APPS.ABB_TEST_AMF
The Microsoft KB Article (ID 873234) recognises this error but no resolution
is provided. Any ideas ?
Linked server using Micrsoft OLE DB provider for Oracle
Oracle client installed on sql server: Oracle 8.1
Oracle database: Oracle 7.3Hi Narimrajr,
There are some limitation when executing an Oracle procedure within a DTS
package.
If you want to execute an Oracle procedure you must use Oracle ODBC native
drivers and specify the connection, Data Source, to use Oracle Provider OLE
DB
and specify the DNS entry in the properties dialog.
Thanks,
Chandan
"narimrajr" wrote:

> When using a linked server for calling a remote Oracle stored procedure fr
om
> SQL Server 2000 I receive the error :
> Server: Msg 7212, Level 17, State 1, Line 1
> Could not execute procedure 'ABB_TEST_AMF' on remote server 'ORCLOMD'.
> [OLE/DB provider returned message: One or more errors occurred during
> processing of command.]
> [OLE/DB provider returned message: Syntax error in {call...} ODBC
Escape.]
> I have tried the following commands:
> exec ORCLOMD.OMD.APPS.ABB_TEST_AMF
> exec ORCLOMD..APPS.ABB_TEST_AMF
> The Microsoft KB Article (ID 873234) recognises this error but no resoluti
on
> is provided. Any ideas ?
> Linked server using Micrsoft OLE DB provider for Oracle
> Oracle client installed on sql server: Oracle 8.1
> Oracle database: Oracle 7.3
>
>
>|||Also, try calling the Oracle procedure via OPENQUERY
Thanks,
Chandan
"narimrajr" wrote:

> When using a linked server for calling a remote Oracle stored procedure fr
om
> SQL Server 2000 I receive the error :
> Server: Msg 7212, Level 17, State 1, Line 1
> Could not execute procedure 'ABB_TEST_AMF' on remote server 'ORCLOMD'.
> [OLE/DB provider returned message: One or more errors occurred during
> processing of command.]
> [OLE/DB provider returned message: Syntax error in {call...} ODBC
Escape.]
> I have tried the following commands:
> exec ORCLOMD.OMD.APPS.ABB_TEST_AMF
> exec ORCLOMD..APPS.ABB_TEST_AMF
> The Microsoft KB Article (ID 873234) recognises this error but no resoluti
on
> is provided. Any ideas ?
> Linked server using Micrsoft OLE DB provider for Oracle
> Oracle client installed on sql server: Oracle 8.1
> Oracle database: Oracle 7.3
>
>
>

server using Windows authentication

Hi,
I´m having problems with using Windows authentication with a linked server.
When connecting to the linked server I receive the error:
Error 18452: Login failed for user 'domain/name of a local windows account
on the linked server'. Reason: Not associated with a trusted SQL Server
connection.
When I change to mixed mode on the linked server everything works fine, but
this is not an option that I want to use. How do I make this work with
Windows authentication?
Best regards,
WencheThis is a security delegation issue. Please take a look at this article for
more info.
http://msdn.microsoft.com/library/en-us/adminsql/ad_security_2gmm.asp?frame=true
-oj
Rac v2.2 & QALite!
http://www.rac4sql.net
"Wenche" <weels@.dne.com> wrote in message
news:uiBMiHVkDHA.1708@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I´m having problems with using Windows authentication with a linked
server.
> When connecting to the linked server I receive the error:
> Error 18452: Login failed for user 'domain/name of a local windows account
> on the linked server'. Reason: Not associated with a trusted SQL Server
> connection.
> When I change to mixed mode on the linked server everything works fine,
but
> this is not an option that I want to use. How do I make this work with
> Windows authentication?
> Best regards,
> Wenche
>