SDAC ConnectDialog

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
asliakar
Posts: 6
Joined: Wed 07 Sep 2011 18:08

SDAC ConnectDialog

Post by asliakar » Mon 17 Sep 2012 09:05

Hello,

We are using SDAC 6.1.6 to connect to Sql Server 2008. We need to use the component set: Loginprompt to true. When dealing with multible connections in one project, we are in the need of setting the database property to the database to connect.

Each TMSConnection that exists has its own ConnectDialog, and its connectionstring is set before it is needed to open. (Thus, in the time the connectionprompt appears, database and server is already known by TMSConnection.)

But, ConnectDialog acts bizarre. Rather than bringing the TMSConnection's properties as the database to connect, it brings the last database connected. This creates conflictions in the usage. Since the users are prone to confuse where to connect.

To sum up: we would like to set the 'database' and 'server' fields of connectDialog programmatically before it is shown.

How can we overcome this problem?
Thank you in advance.
Aslı

AndreyZ

Re: SDAC ConnectDialog

Post by AndreyZ » Mon 17 Sep 2012 10:42

Hello,

To solve the problem, you should set the TMSConnectDialog.StoreLogInfo property to False. StoreLogInfo is used to specify whether the login information should be kept in the system registry after a connection was established.

asliakar
Posts: 6
Joined: Wed 07 Sep 2011 18:08

Re: SDAC ConnectDialog

Post by asliakar » Mon 17 Sep 2012 10:51

It is solved, thank you.

AndreyZ

Re: SDAC ConnectDialog

Post by AndreyZ » Mon 17 Sep 2012 10:58

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

Post Reply