如何在VS 2012连接水晶报表到SQL Server 2008？ [英] How to connect Crystal Report in VS 2012 to Sql Server 2008?

问题描述

我搜索在互联网上，但我无法找到一个解决我的问题。我试图使用Crystal报表中使用VS 2012我的web .NET项目我无法连接到我的本地SQL Server数据库。我有一个CrystalReport.rpt。当我右键点击它，我得到了以下选项：

I searched over the internet but I could not find a solution to my problem. I am trying to use crystal report in my web .NET project using VS 2012. I could not connect to my local Sql server database. I have a CrystalReport.rpt. When I right click on it I get the following options :

当我点击数据库导出我看到下面的选项：

When I click on Database Export I see the following options :

然后我新建连接，我得到这个名单：

Then I click make new connection and I get this list :

我选择此选项微软OEL BD提供程序SQL Server。然后，我被困在此屏幕：

I am selecting this option Microsoft OEL BD Provider for SQL Server. Then I am stuck in this screen :

我试图把（地方）在服务器领域还是我的IP地址或'。指示本地数据库。但是，当我尝试选择数据库从数据库中同一个下拉列表，它是空的？

I tried to put (local) in the server field or My Ip address or '.' indicating local database. But when I try to select the database same from the database drop down list, it is empty?

我会AP preciate如果有人能告诉我什么，我做错了。任何建议是AP preciated。

I would appreciate if someone can tell me what I am doing wrong. Any suggestions is appreciated.

感谢。

推荐答案

最后，我找到了解决我的问题。如果你看这个屏幕一些可用的选项被藏在问题中的图像：

Finally I found a solution to my problem. If you look at this screen some available options was hidden in the question image :

我选择了在SQL Server本机客户端10.0。我不知道为什么OLE DB驱动程序不能正常工作。如果有任何人能够解释本机客户端的SQL和OLE DB之间的区别？这将是巨大的。

I selected the SQL Server Native Client 10.0. I have no idea why OLE DB driver was not working. If any one can explain the difference between native client SQL and OLE DB ? That will be great.

这篇关于如何在VS 2012连接水晶报表到SQL Server 2008？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！