Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

Logon failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed

Jan 20, 2012
Introduction:

In this article I will explain how to solve problem of “Logon failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed” during deploy crystal reports in server.


Description:

In Previous posts I explained
crystal reports example in asp.net and pass parameters to crystal reports using asp.net. After create crystal reports if I run in my system it’s working fine whenever I deployed crystal reports to server I got error like Logon failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed.

I didn’t get why I am getting this error because it’s working very well in my local system after sometime I realized that I am getting this error because of missing SQL Native Client in server. During the time of creating the crystal report I selected SQL Native Client or SQLNCLI as OLEDB provider it works perfectly in my system because of SQL Native Client or SQLNCLI already install in my machine. To solve this problem in your server you need to change OLEDB provider of your report from SQL Native Client to Microsoft OLE DB Provider for SQL Server and deploy to your server it will work for you.

Another way we can solve this problem by installing SQL Native Client drivers (sqlncli.msi) in your server. You can download it from here 


After install sqlncli.msi component in server run your application it will work for you. 

If you enjoyed this post, please support the blog below. It's FREE!

Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

subscribe by rss Subscribe by RSS subscribe by email Subscribe by Email

1 comments :

Anonymous said...

Thank you!
Solved my problem!

Regards
Sarah Barry

Give your Valuable Comments

Other Related Posts

© 2010-2012 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.