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ı
SDAC ConnectDialog
Re: SDAC ConnectDialog
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.
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.
Re: SDAC ConnectDialog
Feel free to contact us if you have any other questions about SDAC.