Re: Data Provider

I second that, check to see if the file is journaled.

Also, what versino of CA are you using? I seem to recall that
distributed transactino support was new in v5r4.

You should be able to get your hands on and use CA v5r4 with older
versions of the OS.

Charles

On Mon, Oct 20, 2008 at 9:20 AM, Jim Steil <steil@xxxxxxxxxxx> wrote:

I can't say that I have experience here, but my first thought would be
to see if the target file is journaled. Because of my lack of
experience with this environment (recently) I'm not sure its required,
just something I'd check first.

-Jim

Salter, James wrote:

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.