如何在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屋!