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

nileiqi · Post by **nileiqi** » Tue 12 Feb 2008 13:57

Hi,

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.

daniel

Antaeus · 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.

nileiqi · 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.

Challenger · 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.