Can disable DTC or Transactions when I use OLEDB provider for Oracle?

Hi,
I am trying to improve my data export operation. At this point I need to
disable implicit transactions when I use insert into [Linked Table] command.
How can disable transactions when I do a distributed insert or use DTS to
export table data ?
Thank you,
MaxHello Max,
You could disable transaction by right click the
package->Properties->Advanced, uncheck "transaction"
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Maxwell2006" <alanalan@.newsgroup.nospam>
>Subject: Can disable DTC or Transactions when I use OLEDB provider for
Oracle?
>Date: Tue, 4 Apr 2006 14:18:01 -0400
>Lines: 19
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.1830
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Message-ID: <eES89OBWGHA.5044@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: mtl-hse-ppp170505.qc.sympatico.ca 65.94.105.17
>Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP0
9.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:426864
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hi,
>
>I am trying to improve my data export operation. At this point I need to
>disable implicit transactions when I use insert into [Linked Table]
command.
>
>How can disable transactions when I do a distributed insert or use DTS to
>export table data ?
>
>Thank you,
>Max
>
>

Can a stored procedure use the OpenRowSet function to get DB2

Linked servers was our first thought, but we don't have that. We'd have to
purchase MSFT Integration Server to get linked servers to work w/our DB2
databases, and we haven't purchased that.
So the linked server route is not an option for us at this time.
Other ideas?
--
Joe Palm
Senior Technical Developer
Madison, WI
"Alejandro Mesa" wrote:
> Can you add a linked server?, this way you do not have to embed the userid
> and password in your query.
> Creating a linked server to DB2 using Microsoft OLE DB provider for DB2
> http://support.microsoft.com/defaul...kb;en-us;222937
>
> AMB
> "Joe Palm" wrote:
>Joe,
The report will pull the data executing a sp in sql server, so that is not
an impediment. The problem with this solution is that encrypting the code of
the sp is not as safe as we think and the userid and password can be taken
from that code.
How can I decrypt a SQL Server stored-procedure?
http://www.mssqlcity.com/FAQ/Devel/DecryptSP.htm
AMB
"Joe Palm" wrote:
> Linked servers was our first thought, but we don't have that. We'd have t
o
> purchase MSFT Integration Server to get linked servers to work w/our DB2
> databases, and we haven't purchased that.
> So the linked server route is not an option for us at this time.
> Other ideas?
> --
> Joe Palm
> Senior Technical Developer
> Madison, WI
>
> "Alejandro Mesa" wrote:
>

Calling user defined function from other server

I have UDF in a database on SQL2000 server. Is it possible to call this UDF from other server (SQL2005)? I did setup a linked server to SQL2000

Call to the following function returns an error:

Msg 207, Level 16, State 1, Line 1

Invalid column name 'srv2000'.

select [srv2000].db_test.dbo.F_TEST()

You cannot call remote UDFs in SQL Server right now. So you will have to use pass-through query using OPENQUERY to call the UDF or EXECUTE AT in SQL Server 2005.

-- SQL Server 2000/2005

select i from openquery([srv2000], 'select db_test.dbo.F_TEST() as i')

-- SQL Server 2005

exec('select db_test.dbo.F_TEST() as i') at [srv2000]

-- Or

declare @.i int
exec('select ? = db_test.dbo.F_TEST() ', @.i output) at [srv2000]
select @.i

|||Thanks for help!

Calling UDF over Server Link

For some reason, over a server link, the following call to a UDF on a linked server does not work, it seems it is treating the UDF as a table.

The same UDF called on the local server works fine.

--call/select from function
SELECT
MASTERID
FROM
PAUL.RISK_DB.dbo.FNTRADEFILEPRICE('10/2/2006')

error:
Server: Msg 170, Level 15, State 31, Line 5
Line 5: Incorrect syntax near '('.

Thanks.I created a sproc that calls the function, works like a charm. Still does not expain why calling the function natively from a remote server does not work, this is a work-around though.

Thanks,
Schmed.

Calling stored procs on AS/400

I'm already able to pull data out of the AS/400 tables using a linked server from SQL 2000 SP3.
What I'd like to do is to be able to run stored procs on the AS/400 from SQL Server. Not sure what SPs are called in AS/400 parlance, but you get the idea.
Anyone done this before?
If not, any idea how to kick-off any kind of SQL task on the AS400 from SQL Server?
Hi,
Generally we do not support executing remote stored procedures if linked
server is non-SQL Server. I assume that you are using DB2. You may check if
the following can work on DB2.
1. Create a trigger on a table in DB2 database, which calls stored
procedures. The triggering action may be insertion, update, deletion.
2. Execute openquery to the DB2 linked server from SQL Server (e.g. insert
into table, etc.)
Thus the trigger can fire the stored procedure. I understand that it may be
inconvenient for you. However, we do not have better method.
If you use ADO or ADO.NET in code, you can execute the stored procedure on
DB2.
Calling Stored Procedure From ADO.NET Results in SQLCODE: -188 (330096)
http://support.microsoft.com/?id=330096
Thank you,
Bill Cheng
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided as is with no warranties and confers no rights.
| Thread-Topic: Calling stored procs on AS/400
| thread-index: AcRendMRxBNgJ+1tQUeVNCcN746SiQ==
| X-WBNR-Posting-Host: 80.132.66.129
| From: "=?Utf-8?B?SmFtZXM=?=" <news@.att.com>
| Subject: Calling stored procs on AS/400
| Date: Wed, 30 Jun 2004 05:29:01 -0700
| Lines: 10
| Message-ID: <05E76F43-0C6D-4CB0-9118-BE46C1314E00@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:349340
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I'm already able to pull data out of the AS/400 tables using a linked
server from SQL 2000 SP3.
| What I'd like to do is to be able to run stored procs on the AS/400 from
SQL Server. Not sure what SPs are called in AS/400 parlance, but you get
the idea.
|
| Anyone done this before?
|
| If not, any idea how to kick-off any kind of SQL task on the AS400 from
SQL Server?
|
|
|
|
|
|||OK, trigger sounds good.
""Bill Cheng"" wrote:

> Hi,
> Generally we do not support executing remote stored procedures if linked
> server is non-SQL Server. I assume that you are using DB2. You may check if
> the following can work on DB2.
> 1. Create a trigger on a table in DB2 database, which calls stored
> procedures. The triggering action may be insertion, update, deletion.
> 2. Execute openquery to the DB2 linked server from SQL Server (e.g. insert
> into table, etc.)
> Thus the trigger can fire the stored procedure. I understand that it may be
> inconvenient for you. However, we do not have better method.
> If you use ADO or ADO.NET in code, you can execute the stored procedure on
> DB2.
> Calling Stored Procedure From ADO.NET Results in SQLCODE: -188 (330096)
> http://support.microsoft.com/?id=330096
>
> Thank you,
> Bill Cheng
> Microsoft Online Partner Support
> Get Secure! – www.microsoft.com/security
> This posting is provided “as is” with no warranties and confers no rights.
> --
> | Thread-Topic: Calling stored procs on AS/400
> | thread-index: AcRendMRxBNgJ+1tQUeVNCcN746SiQ==
> | X-WBNR-Posting-Host: 80.132.66.129
> | From: "=?Utf-8?B?SmFtZXM=?=" <news@.att.com>
> | Subject: Calling stored procs on AS/400
> | Date: Wed, 30 Jun 2004 05:29:01 -0700
> | Lines: 10
> | Message-ID: <05E76F43-0C6D-4CB0-9118-BE46C1314E00@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
> | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGXA03.phx.gbl
> | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:349340
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | I'm already able to pull data out of the AS/400 tables using a linked
> server from SQL 2000 SP3.
> | What I'd like to do is to be able to run stored procs on the AS/400 from
> SQL Server. Not sure what SPs are called in AS/400 parlance, but you get
> the idea.
> |
> | Anyone done this before?
> |
> | If not, any idea how to kick-off any kind of SQL task on the AS400 from
> SQL Server?
> |
> |
> |
> |
> |
>
|||Hi,
I am glad to know that it can work for you. I am happy to work with you.
Thanks again for choosing Microsoft newsgroups.
Thank you,
Bill Cheng
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided as is with no warranties and confers no rights.
| Thread-Topic: Calling stored procs on AS/400
| thread-index: AcRfcnJUe/OsxZDeS3+6uUwDO+xsUw==
| X-WBNR-Posting-Host: 80.132.81.90
| From: "=?Utf-8?B?SmFtZXM=?=" <news@.att.com>
| References: <05E76F43-0C6D-4CB0-9118-BE46C1314E00@.microsoft.com>
<4O8IPgxXEHA.2244@.cpmsftngxa06.phx.gbl>
| Subject: RE: Calling stored procs on AS/400
| Date: Thu, 1 Jul 2004 06:51:02 -0700
| Lines: 70
| Message-ID: <EF8371DE-2652-4173-858E-7DF9749DE1F3@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:349558
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| OK, trigger sounds good.
|
| ""Bill Cheng"" wrote:
|
| > Hi,
| >
| > Generally we do not support executing remote stored procedures if
linked
| > server is non-SQL Server. I assume that you are using DB2. You may
check if
| > the following can work on DB2.
| > 1. Create a trigger on a table in DB2 database, which calls stored
| > procedures. The triggering action may be insertion, update, deletion.
| > 2. Execute openquery to the DB2 linked server from SQL Server (e.g.
insert
| > into table, etc.)
| >
| > Thus the trigger can fire the stored procedure. I understand that it
may be
| > inconvenient for you. However, we do not have better method.
| >
| > If you use ADO or ADO.NET in code, you can execute the stored procedure
on
| > DB2.
| > Calling Stored Procedure From ADO.NET Results in SQLCODE: -188 (330096)
| > http://support.microsoft.com/?id=330096
| >
| >
| > Thank you,
| >
| > Bill Cheng
| > Microsoft Online Partner Support
| > Get Secure! – www.microsoft.com/security
| > This posting is provided “as is” with no warranties and confers no
rights.
| > --
| > | Thread-Topic: Calling stored procs on AS/400
| > | thread-index: AcRendMRxBNgJ+1tQUeVNCcN746SiQ==
| > | X-WBNR-Posting-Host: 80.132.66.129
| > | From: "=?Utf-8?B?SmFtZXM=?=" <news@.att.com>
| > | Subject: Calling stored procs on AS/400
| > | Date: Wed, 30 Jun 2004 05:29:01 -0700
| > | Lines: 10
| > | Message-ID: <05E76F43-0C6D-4CB0-9118-BE46C1314E00@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.server
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
| > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGXA03.phx.gbl
| > | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:349340
| > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > |
| > | I'm already able to pull data out of the AS/400 tables using a linked
| > server from SQL 2000 SP3.
| > | What I'd like to do is to be able to run stored procs on the AS/400
from
| > SQL Server. Not sure what SPs are called in AS/400 parlance, but you
get
| > the idea.
| > |
| > | Anyone done this before?
| > |
| > | If not, any idea how to kick-off any kind of SQL task on the AS400
from
| > SQL Server?
| > |
| > |
| > |
| > |
| > |
| >
| >
|

Calling stored procs on AS/400

I'm already able to pull data out of the AS/400 tables using a linked server
from SQL 2000 SP3.
What I'd like to do is to be able to run stored procs on the AS/400 from SQL
Server. Not sure what SPs are called in AS/400 parlance, but you get the id
ea.
Anyone done this before?
If not, any idea how to kick-off any kind of SQL task on the AS400 from SQL
Server?Hi,
Generally we do not support executing remote stored procedures if linked
server is non-SQL Server. I assume that you are using DB2. You may check if
the following can work on DB2.
1. Create a trigger on a table in DB2 database, which calls stored
procedures. The triggering action may be insertion, update, deletion.
2. Execute openquery to the DB2 linked server from SQL Server (e.g. insert
into table, etc.)
Thus the trigger can fire the stored procedure. I understand that it may be
inconvenient for you. However, we do not have better method.
If you use ADO or ADO.NET in code, you can execute the stored procedure on
DB2.
Calling Stored Procedure From ADO.NET Results in SQLCODE: -188 (330096)
http://support.microsoft.com/?id=330096
Thank you,
Bill Cheng
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided as is with no warranties and confers no rights.
--
| Thread-Topic: Calling stored procs on AS/400
| thread-index: AcRendMRxBNgJ+1tQUeVNCcN746SiQ==
| X-WBNR-Posting-Host: 80.132.66.129
| From: "examnotes" <news@.att.com>
| Subject: Calling stored procs on AS/400
| Date: Wed, 30 Jun 2004 05:29:01 -0700
| Lines: 10
| Message-ID: <05E76F43-0C6D-4CB0-9118-BE46C1314E00@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:349340
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I'm already able to pull data out of the AS/400 tables using a linked
server from SQL 2000 SP3.
| What I'd like to do is to be able to run stored procs on the AS/400 from
SQL Server. Not sure what SPs are called in AS/400 parlance, but you get
the idea.
|
| Anyone done this before?
|
| If not, any idea how to kick-off any kind of SQL task on the AS400 from
SQL Server?
|
|
|
|
||||OK, trigger sounds good.
""Bill Cheng"" wrote:

> Hi,
> Generally we do not support executing remote stored procedures if linked
> server is non-SQL Server. I assume that you are using DB2. You may check i
f
> the following can work on DB2.
> 1. Create a trigger on a table in DB2 database, which calls stored
> procedures. The triggering action may be insertion, update, deletion.
> 2. Execute openquery to the DB2 linked server from SQL Server (e.g. insert
> into table, etc.)
> Thus the trigger can fire the stored procedure. I understand that it may b
e
> inconvenient for you. However, we do not have better method.
> If you use ADO or ADO.NET in code, you can execute the stored procedure on
> DB2.
> Calling Stored Procedure From ADO.NET Results in SQLCODE: -188 (330096)
> http://support.microsoft.com/?id=330096
>
> Thank you,
> Bill Cheng
> Microsoft Online Partner Support
> Get Secure! – www.microsoft.com/security
> This posting is provided “as is” with no warranties and confers no rig
hts.
> --
> | Thread-Topic: Calling stored procs on AS/400
> | thread-index: AcRendMRxBNgJ+1tQUeVNCcN746SiQ==
> | X-WBNR-Posting-Host: 80.132.66.129
> | From: "examnotes" <news@.att.com>
> | Subject: Calling stored procs on AS/400
> | Date: Wed, 30 Jun 2004 05:29:01 -0700
> | Lines: 10
> | Message-ID: <05E76F43-0C6D-4CB0-9118-BE46C1314E00@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
> | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:349340
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | I'm already able to pull data out of the AS/400 tables using a linked
> server from SQL 2000 SP3.
> | What I'd like to do is to be able to run stored procs on the AS/400 from
> SQL Server. Not sure what SPs are called in AS/400 parlance, but you get
> the idea.
> |
> | Anyone done this before?
> |
> | If not, any idea how to kick-off any kind of SQL task on the AS400 from
> SQL Server?
> |
> |
> |
> |
> |
>|||Hi,
I am glad to know that it can work for you. I am happy to work with you.
Thanks again for choosing Microsoft newsgroups.
Thank you,
Bill Cheng
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided as is with no warranties and confers no rights.
--
| Thread-Topic: Calling stored procs on AS/400
| thread-index: AcRfcnJUe/OsxZDeS3+6uUwDO+xsUw==
| X-WBNR-Posting-Host: 80.132.81.90
| From: "examnotes" <news@.att.com>
| References: <05E76F43-0C6D-4CB0-9118-BE46C1314E00@.microsoft.com>
<4O8IPgxXEHA.2244@.cpmsftngxa06.phx.gbl>
| Subject: RE: Calling stored procs on AS/400
| Date: Thu, 1 Jul 2004 06:51:02 -0700
| Lines: 70
| Message-ID: <EF8371DE-2652-4173-858E-7DF9749DE1F3@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:349558
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| OK, trigger sounds good.
|
| ""Bill Cheng"" wrote:
|
| > Hi,
| >
| > Generally we do not support executing remote stored procedures if
linked
| > server is non-SQL Server. I assume that you are using DB2. You may
check if
| > the following can work on DB2.
| > 1. Create a trigger on a table in DB2 database, which calls stored
| > procedures. The triggering action may be insertion, update, deletion.
| > 2. Execute openquery to the DB2 linked server from SQL Server (e.g.
insert
| > into table, etc.)
| >
| > Thus the trigger can fire the stored procedure. I understand that it
may be
| > inconvenient for you. However, we do not have better method.
| >
| > If you use ADO or ADO.NET in code, you can execute the stored procedure
on
| > DB2.
| > Calling Stored Procedure From ADO.NET Results in SQLCODE: -188 (330096)
| > http://support.microsoft.com/?id=330096
| >
| >
| > Thank you,
| >
| > Bill Cheng
| > Microsoft Online Partner Support
| > Get Secure! – www.microsoft.com/security
| > This posting is provided “as is” with no warranties and confers no
rights.
| > --
| > | Thread-Topic: Calling stored procs on AS/400
| > | thread-index: AcRendMRxBNgJ+1tQUeVNCcN746SiQ==
| > | X-WBNR-Posting-Host: 80.132.66.129
| > | From: "examnotes" <news@.att.com>
| > | Subject: Calling stored procs on AS/400
| > | Date: Wed, 30 Jun 2004 05:29:01 -0700
| > | Lines: 10
| > | Message-ID: <05E76F43-0C6D-4CB0-9118-BE46C1314E00@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.server
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
| > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:349340
| > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > |
| > | I'm already able to pull data out of the AS/400 tables using a linked
| > server from SQL 2000 SP3.
| > | What I'd like to do is to be able to run stored procs on the AS/400
from
| > SQL Server. Not sure what SPs are called in AS/400 parlance, but you
get
| > the idea.
| > |
| > | Anyone done this before?
| > |
| > | If not, any idea how to kick-off any kind of SQL task on the AS400
from
| > SQL Server?
| > |
| > |
| > |
| > |
| > |
| >
| >
|