Re: [DBNETLIB][ConnectionOpen (Connet()).]SQL server does not exist or access

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 12
Joined: Tue 05 Feb 2008 22:57

Re: [DBNETLIB][ConnectionOpen (Connet()).]SQL server does not exist or access

Post by nileiqi » Tue 12 Feb 2008 13:57


I have run my application in two PC, PC1 it works fine without any problem, however when running in PC2, it comes with following error message,

[DBNETLIB][ConnectionOpen (Connet()).]SQL server does not exist or access denied.

But, when I test connection in Data Link Property it reports test connect succeed, and I set TMSConnection->Connected = true, so I can see the database content at design time, so I don't understand why the above error message coming up.

Both PC installed with MS SQL 2005 server, the only difference is server name and user name because they are in different PC.

Can anyone tell me what is the problem ? thanks in advance.


Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Wed 13 Feb 2008 12:40

Try to install the SQL Server Native Client provider. You can download it by this link.

Posts: 12
Joined: Tue 05 Feb 2008 22:57

Post by nileiqi » Thu 14 Feb 2008 12:52

thanks, I just do it, but no help.

I give more details here.

The trick thing happens when testing connection in Data Link Property.

(1) Before I press the TestConnection button, TMSTable->Active = true, then
(2) I press the button, it reports test connect succeed, then trick thing happens ! TMSTable->Active changes from true to false.

This can be repeated. The database file is copied from other and attaches to the SQL 2005 server in this PC. Thanks.

Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Tue 19 Feb 2008 07:59

Data Link Properties wizard reassigns connection string when calling TestConnection, that's why the TMSConnection component disconnects and closes all linked datasets.

Post Reply