sql localdb and AttachDbFileName

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
tonisanta
Posts: 55
Joined: Wed 04 Apr 2007 17:25

sql localdb and AttachDbFileName

Post by tonisanta » Wed 14 Nov 2012 10:00

Hi,
from documentation of sqllocaldb (sql 2012) there should be an AttachDbFileName= parameter, useful to attach a .mdf available during the session is active. It would be fine if you could provide a property AttachDbFileName in the TMSConnection.
And just another thing would be fine: if the indicated instance in Server does not exist and the provider is (localdb), so a "sqllocaldb.exe create name_instance" should be launched.
best regards
Toni

AndreyZ

Re: sql localdb and AttachDbFileName

Post by AndreyZ » Wed 14 Nov 2012 11:58

Hello,

1. To set the AttachDBFileName connection string option, you can use the TMSConnection.Options.InitialFileName property.
2. You can leave your suggestion at our UserVoice page at http://devart.uservoice.com/forums/1046 ... components , and if there are many votes for your suggestion, we will implement it.

tonisanta
Posts: 55
Joined: Wed 04 Apr 2007 17:25

Re: sql localdb and AttachDbFileName

Post by tonisanta » Wed 14 Nov 2012 12:55

Great! The Options.InitialFileName works fine.
The "AutoCreateInstance"-feature would be fine but is not essential.
Many thanks for your prompt feedback.
Toni

AndreyZ

Re: sql localdb and AttachDbFileName

Post by AndreyZ » Wed 14 Nov 2012 13:03

Feel free to contact us if you have any other questions about SDAC.

Post Reply