Hi,
Accoding to coding the SP was successfully created.But Once its going to be
executed through vb ADO cording, its giving following error message.
MSDTC on server "NISHANTHA" unavailable.
NISHANTHA is a working server.Particuler SP is exists in that server which is
accessing another server.
Please send me why it is and How to solve.Please attach sample cording.
Thanks,
Pubudu
This error suggests that you will need to start the 'Distributed Transaction Coordinator' NT Service on your NISHANTHA server.
Chris