我在VB中调用水晶报表时总是提示我输入数据库的连接密码,请问这如何解决呀?
我是用的SQL SERVER2000数据库,连接代码如下:
Sql = "select * from dayall_V"
Rs.Open Sql, Conn.ConPath = App.Path & "\Report\DAV.rpt"
Set Report = CryApp.OpenReport(Path)
Report.Database.SetDataSource Rs
Screen.MousePointer = vbHourglass
CRViewer96.ReportSource = Report
CRViewer96.ViewReport
Screen.MousePointer = vbDefault(谢谢)
我是用的SQL SERVER2000数据库,连接代码如下:
Sql = "select * from dayall_V"
Rs.Open Sql, Conn.ConPath = App.Path & "\Report\DAV.rpt"
Set Report = CryApp.OpenReport(Path)
Report.Database.SetDataSource Rs
Screen.MousePointer = vbHourglass
CRViewer96.ReportSource = Report
CRViewer96.ViewReport
Screen.MousePointer = vbDefault(谢谢)
你好,你在建连接(Conn.Con)时,是不是没有设连接数据库的用户名和密码
如
Public Public_con As New ADODB.Connection '公用连接源
Main_cnstr=“
SQLOLEDB;Persist Security Info=False;User ID=用户名;pwd=密码;Initial Catalog=数据库名;Data Source=服务器名称或服务器IP地址”
用以下连接则可
Public_con.Open Main_cnstr