Monday, March 12, 2012

MSSQLServer Express and Delphi application

Dear friends I have a problem with the use of DELPHI and MSSQLServer!

I have installed in a PC a MSSQLServer Express. The PC is connected

with a other via a small network. I have developed an application in DELPHI

which runs also in the two computers. I have regulated SQLServer so as

to is accessible via TCP/IP, make that I tryed after in the other PC I

installed SQL Server Management Studio Express and had access in the

database via the network. While in the beginning both applications

worked normaly and were connected regularly in the base suddenly

one day they couldn't be connected giving as message the following

"DataBase Server Error: SQL State: 08001, SQL Error Code: 17 ", as there was no server. That is to say without I have teased the

properties the access to DataBase was impossible via the application but possible via the SQL

Server Management Studio Express and the environment of Borland Delphi

2005 from both PC's. That is to say

suddenly only the application simply could not be connected. I tryed

a lot of solutions but no one it did not work. When I installed the

MSSQLServer Express in the other PC the application could be connected

from this but no from the other via network always giving the same

message. Has anyone any idea why I am in impasse from solutions!!!!

Thak you in advance!

It is hard to diagnose based on what you describe here. But it could be related to the connection protocols. The following article may help you :

http://blogs.msdn.com/sql_protocols/archive/2005/12/19/505372.aspx

|||Thank you my friend, I will use your advises as soon as possible and I wish they will help me!

No comments:

Post a Comment