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

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...
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...
Read more

IGNOU Contact Number

By -
IGNOU Contact Number  IGNOU  is one of the most renowned Open Universities in Indiawhich is also known as Indira Gandhi National Open University. It is the first Indian Open University that has its penetration across the entire length and breadth of the country. The University, with its number of Regional Centres, provides excellent educational services to students in all nooks and corners throughout the country. The university was commenced by an Act of Parliament in 1969. In the beginning, the University started with two Academic Programs  in 1987, including  Diploma in Management  and  Diploma in Distance Education  with strength of 4528 students.   Today, the University has emerged as one of the most prominent educational establishment with noteworthy presence in abroad also. It provides excellent educational services and facilities to students in India and abroad. It imparts education over to 4 million students with the help of ...
Read more