Devart Forums

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

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

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.

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