SQLEXPRESS连接问题 [英] SQLEXPRESS Connection Problem

问题描述

亲爱的所有人，

我是Vb.net的新手.

我在连接定义如下的情况下将数据输入了数据库.

服务器=.\ SQLEXPRESS; AttachDbFilename = F:\ jatin \ sale \ jatin_Data.MDF;集成安全性=真;连接超时= 30;用户实例=真"

我的所有数据都通过该数据库输入数据库.

现在，当我尝试制作水晶报表时，我出现了问题

数据库专家建立新连接.

我正在使用OLE DB(ADO)建立新连接.

在提供中:SQL Native Client
下一页:服务器:.\ SQLEXPRESS

接下来是用户ID和密码.

我没有放在任何地方的
密码在这里.

如果我尝试通过该操作，然后单击数据库"下拉列表，则无显示.

请指导我犯错的地方.

感谢all

Dear All,

I''m new to Vb.net.

I entered the data in the database with the connection define as under.

"server=.\SQLEXPRESS;AttachDbFilename=F:\jatin\sale\jatin_Data.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True"

My all data is entering in the database through that.

Now problem occur with me when I try to make crystal report I use

Database Expert to make new connection.

I''m using OLE DB (ADO) to make new connection.

In provide : SQL Native Client
Next : Server : .\SQLEXPRESS

Now next is User Id & Password.

Where as I have not put any kind of
password here.

If I try to bye pass that and click on Database dropdown it shows nothing.

Kindly guide where I''m committing mistake.

Thanks to all

推荐答案

我会通过连接字符串.


Crystal Reports有2种选择

1.如前所述，在晶体报告中将连接类型更改为OLEDB
2.将数据作为数据集传入.

I would check the construction of your connection string though Connection Strings.


You have 2 choices with Crystal Reports

1. As stated earlier change the connection type to OLEDB in crystal reports
2. Pass the data in as a dataset.

您应该再检查一步.
接下来是集成安全性复选框.
只需检查一下，即可列出所有数据库.

您甚至可以在连接字符串"Integrated Security = True"中看到

You should check one step further.
Next is Integrated Security checkbox.
Just check that thing, and you''ll get all your databases listed.

You can see that even in your connection string "Integrated Security=True"

将提供程序更改为从SQL Native Client到 Microsoft OLEDB Provide for SQL SERVER ..

这将解决您的问题

CHange your provider to Microsoft OLEDB Provide for SQL SERVER from SQL Native Client..

this will solve your problem

这篇关于SQLEXPRESS连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！