Re: Data Provider

I have worked on a Data Warehouse running on SQL that pushed & pulled data from the 400. First this is to make sure the file is journaled. Journaling is required incase a SQL Roll Back is required.


Jim


--- On Mon, 10/20/08, Salter, James <JSalter@xxxxxxxxxx> wrote:

From: Salter, James <JSalter@xxxxxxxxxx>
Subject: Data Provider
To: midrange-l@xxxxxxxxxxxx
Date: Monday, October 20, 2008, 7:26 PM
We are trying to access and update data on the System i from
SQL SERVER
2005 (Windows Server 2003 64-bit) using the IBMDASQL
provider, however
we are getting the following error -

The operation could not be performed because OLE DB
provider "IBMDASQL"
for linked server "DB2400OLEDB" was unable to
begin a distributed
transaction.

Any thoughts? Which provider would you use and why?

Thanks.
James Salter
Systems Programmer
American Cast Iron Pipe Co
Email: jsalter@xxxxxxxxxx
Phone: (205) 325-3033
Fax: (205) 307-3833

_________Confidentiality Notice_______________________
This e-mail and any files transmitted with it is
confidential and is intended solely for the use of
the individual(s) or entity(ies) to whom this e-mail
is addressed. If you are not the intended recipient
or the person responsible for delivering the e-mail
to the intended recipient, be advised that you have
received this e-mail in error, and that any use,
disclosure, dissemination, forwarding, printing,
retention or copying of this e-mail is strictly
prohibited. If you have received this e-mail in
error, please immediately return this e-mail to
the sender and delete the e-mail from your system.
Thank you.

--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com