the operation could not be performed because ole db provider sqlncli10 for linked server

By -
Question 1: Execute this Query in SQL server where you setup database.

Answer: EXEC sp_serveroption @Server='DB Server IP Address',@optname='remote proc transaction promotion', @optvalue='false'

try this SQL above your begin distributed transaction

 set XACT_ABORT on

Comments

Post a Comment

Popular posts from this blog

Life care Hospital Management System Project in Asp.Net

By -
Image
Life care Hospital Management System Project in Asp.Net Life care Hospital Management System Project in Asp.Net is a software application developed for hospital which is useful for managing doctors and patients ( in patients and out patients ), staff  details. Life care Hospitals has a paperwork and a manual preservation of data related to management and billings. They needed a software which can help them reduce their burden thus making their hospital semi-technological. This project is created it the view of storing, retrieving, updating, deleting records of patients, doctors, staff etc. Patients here are of two types viz.  In Patients (the ones who come for a treatment and stays) and Out Patients(the ones who come for a treatment and a regular checkup). Out Patients need their data to be stored and retrieved when necessary. As their billing requires Doctor’s Fees, it is collected manually. So the scope for Out Patient is far less in this project. The InPatient
Read more

DIY Android Home Automation With Free Smartphone Application

By -
Image
DIY Android Home Automation With Free Smartphone Application DIY SmartHome Application Ever wanted to make your home automated? Wanted to control the lights, fan, and other appliances from your smartphone? Or wanted a tutorial about connected devices and getting started with them? Our DIY Android Home Automation project will show you how to make your home automated using an Android smartphone. This requires no experience with Android programming at all, and a free application is included for you to develop. Using this Android application you will be able to control your lights, air conditioning, and door locks all from your smartphone. This system Bluetooth to connect with your device and control the various appliances in your home. Have fun with this DIY hacking tutorial! Required Materials Hardware : Arduino / Arduino Clone or make your own custom Arduino board with this  tutorial. A 5v TTL -UART Bluetooth module like:  JY-MCU BT_BOARD (Cheaper)   or  Bl
Read more

IIS content multiple website to single website SSL installation and configure

By -
Image
Setting up SSL Host Headers on IIS 7 Obtain an SSL certificate and install it into IIS 7 . For step-by-step instructions on how to do this, see  Once the certificate is installed into IIS,  bind it to the first site on the IP address . Open the command prompt  by clicking the start menu and typing “cmd” and hitting enter. Navigate to C:\Windows\System32\Inetsrv\  by typing “cd C:\Windows\System32\Inetsrv\” on the command line. In the Inetsrv folder,  run the following command for each of the other websites  on the IP address that need to use the certificate (copy both lines):  appcmd set site /site.name:" <IISSiteName> " /+bindings.[protocol='https',bindingInformation='*:443: <hostHeaderValue> '] Replace  <IISSiteName>   with the name of the IIS site and  <hostHeaderValue>  with the host header for that site (site1.mydomain.com) Test each website in a browser . It should bring up the correct page and show the lock icon without
Read more