Microsoft KB Archive/238384

{|
 * width="100%"|

-

The information in this article applies to:


 * Microsoft Visual InterDev, version 6.0

-

SYMPTOMS
After you install Service Pack 3 for Visual Studio when you are trying to select a connection for the Recordset Design-Time Control (DTC), a valid data connection is not listed or the  option appears.

CAUSE
DTCs under Service Pack 3 require more information than is added when you select the Use ODBC Data Source Name option. This connection information, which provides information to the drop-down combo box on the recordset DTC, is added to a binary file called the Dataenvironment.asa.

RESOLUTION
When you create a new data connection if you select the Use Connection String option in Connection Properties dialog box you have the option of using the connection with the Recordset DTC. Use the following steps to create a data connection that you can use with the Recordset DTC.


 * 1) Add a data connection to your Visual InterDev project.
 * 2) In the Data Link Properties dialog box, select a provider for your database and click Next.
 * 3) Complete the appropriate information on the Connection tab and click OK.
 * 4) The Connection Properties dialog box appears with the Use Connection String option selected. Leave this option selected and do not change to the option of Use ODBC Data Source Name.
 * 5) Add a Recordset DTC to your project. You can now select the connection you have created in the connection settings of the Recordset DTC.

STATUS
Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.

MORE INFORMATION
This behavior is experienced only at design time and the Use ODBC Data Source Name works correctly at run time as long as you have previously bound all your DTCs at design time with the Use Connection String option.

Steps to Reproduce Behavior

 * 1) Add a data connection to your Visual InterDev Project.
 * 2) In the Data Link Properties dialog box select a provider for your database and click Next.
 * 3) Complete the appropriate information on the Connection tab and click OK.
 * 4) The Connection Properties dialog box appears with the Use Connection String option selected. Change the option to Use ODBC Data Source Name. Create a new data source or select an existing data source and click OK.
 * 5) Add a Recordset DTC to a page in your project. You cannot select the connection or the option appears if there are no other valid connections in your project.

Additional query words:

Keywords         : Version          : WINDOWS:6.0 Platform         : WINDOWS Issue type       : kbbug
 * }