You MAY just have the server name wrong. DRDA is picky about server
names. Check that the system name of your System i matches what you have
entered in your SQL server provider setup. System i name is shown on
your "Sign On" panel unless you have modified it.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Salter, James
Sent: Monday, October 20, 2008 7:56 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Data Provider
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.
As an Amazon Associate we earn from qualifying purchases.