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]