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
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 ?
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
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]
* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.