SDAC ConnectDialog
Posted: 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ı
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ı