Devart Forums

I'm trying to establish a connection to a SQL Server Compact.
According to the manual , I should specify the database name at the TMSCompactConnection object.
Something like c:\test.sdf. But what kind of name is this?
MSSQL Server database files are _Data and _Log .MDF files.

I think you cannot use TMSCompactConnection for connecting to regular MS SQL database (.mdf & .ldf is used by "normal" sql server - enterprise, standard, express; NOT compact).
You should use TMSConnection to connect to running SQL instance with those files attached as database.

Bingo!

Thanks, Ludek.

Ludek is right. The TMSCompactConnection component supports connection to SQL Server Compact Edition only (.sdf database file).

To connect to the database, whose files (.mdf and .ldf) are not attached to the running SQL Server instance, you should set the TMSConnection.Options.InitialFileName property value to the full path and full .mdf file name before connection. See more details about the InitialFileName property in our documentation:
https://www.devart.com/sdac/docs/?devar ... lename.htm .