Data Provider

["Salter, James" <JSalter@xxxxxxxxxx>]

The file is journalled & we are using V5R4 Client Access.

If this should work with this, maybe I should make sure that we are at
the most recent service pack level of CA.

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

message: 10
date: Mon, 20 Oct 2008 10:02:26 -0400
from: "Charles Wilt" <charles.wilt@xxxxxxxxx>
subject: 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.


------------------------------