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]

Could it be something like in http://support.microsoft.com/kb/889615 ?

Quote:

---

Originally Posted by VictorN

Could it be something like in http://support.microsoft.com/kb/889615 ?

---

I have read your link but it not

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

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

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"

---

Now, My computer run Server=192.168.1.54,1433"(IP LAN) but address IP out internet not run. I also check this item?

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!)

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.

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]

http://support.microsoft.com/kb/555332

Quote:

---

Originally Posted by VictorN

http://support.microsoft.com/kb/555332

---

I have seen this page before, but still not