-
October 2nd, 2013, 03:21 AM
#1
ConnectionString SQL Server 2005 with ActiveReport 2.0 via address IP ?
In VB6.0 code error below:
Dim cn As ADODB.Connection
Set cn = New Connection
cn.ConnectionString = "Driver={SQL Server}; Server=192.168.1.54,1433; Uid=xyz;Pwd=123;Database=Northwind;"
cn.Open
warring error:
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'xyz'. The user is not associated with a trusted SQL Server connection
In ActiveReport 2.0
Dim rpt As New ActiveReport1
rpt.DataControl1.Provider = "SQLOLEDB.1" ' ' "SQLOLEDB.1"
rpt.DataControl1.ConnectionString = "Driver={SQL Server};" & _
"Server=192.168.1.54; Uid=xyz; Pwd=123; Database=Northwind;"
warring error:
Error 5000 : Error in processing report.
[ Extended Info:Invalid connection string attribute]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|