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]
Re: ConnectionString SQL Server 2005 with ActiveReport 2.0 via address IP ?
Re: ConnectionString SQL Server 2005 with ActiveReport 2.0 via address IP ?
Quote:
Originally Posted by
VictorN
I have read your link but it not
Re: ConnectionString SQL Server 2005 with ActiveReport 2.0 via address IP ?
According to your thread on the other forum you are using SQL Server Express and not SQL Server. There is a difference namely that you need to specify the instance when using the express version
Server\SQLExpress
1 Attachment(s)
Re: ConnectionString SQL Server 2005 with ActiveReport 2.0 via address IP ?
if I replace "Server=192.168.1.54,1433" as "Server=.\SQLEXPRESS", then run normally without error. My computer SQL Server =. \ SQLEXPRESS has got IP address = 192.168.1.54. why My computer not run with the IP ? you see attach file my config SQL Server 2005 express
Re: ConnectionString SQL Server 2005 with ActiveReport 2.0 via address IP ?
Quote:
Originally Posted by
dongtrien
if I replace "Server=192.168.1.54,1433" as "Server=.\SQLEXPRESS", then run normally without error. My computer SQL Server =. \ SQLEXPRESS has got IP address = 192.168.1.54. why My computer not run with the IP ?
Because your connection string (at least its Server part is wrong.
Try
Code:
"Server=192.168.1.54.\SQLEXPRESS"
Re: ConnectionString SQL Server 2005 with ActiveReport 2.0 via address IP ?
Now, My computer run Server=192.168.1.54,1433"(IP LAN) but address IP out internet not run. I also check this item?
Re: ConnectionString SQL Server 2005 with ActiveReport 2.0 via address IP ?
Quote:
Originally Posted by
dongtrien
Now, My computer run Server=192.168.1.54,1433"(IP LAN) but address IP out internet not run. I also check this item?
:confused:
Sorry, I could not understand what you meant! :eek:
Please, show the full connection string that does work and the one that does not (and with what error!)
Re: ConnectionString SQL Server 2005 with ActiveReport 2.0 via address IP ?
Please, show the full connection string that does work and the one that does not (and with what error!)
I guess you can test your connection on a demo server with RESTful interface for SQL data here and it auto debugs and clears all injected errors.
Re: ConnectionString SQL Server 2005 with ActiveReport 2.0 via address IP ?
I set "Server=192.168.1.54,1434" then run normally, If i replace network address IP "Server=network address IP,1434", It will warning error: "Error 5000 : Error in processing report.
[ Extended Info:[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''. The user is not associated with a trusted SQL Server connection.]". I have tested the network IP address and open port 1434 by telnet command [OK]
Re: ConnectionString SQL Server 2005 with ActiveReport 2.0 via address IP ?
Re: ConnectionString SQL Server 2005 with ActiveReport 2.0 via address IP ?
Quote:
Originally Posted by
VictorN
I have seen this page before, but still not