PRB: Unhandled Exception When You Set ADO Property to a String in Visual C# .NET (309047)

MORE INFORMATION

Steps to Reproduce the Behavior

1. Start Microsoft Visual Studio .NET.
2. Create a new Windows Application project in Visual C# .NET.
3. Place a Button control on Form1, and change its Name property to btnTest.
4. In Solution Explorer window, right-click References, and then click Add Reference.
5. On the COM tab in the Add Reference dialog box, click Microsoft ActiveX Data Objects 2.x Library. Click Select to add this reference to the Selected Components section, and then click OK.
6. If no wrapper is found for the selected library, you receive a warning. Click Yes to generate a wrapper. The ADODB reference is added to the project references.
7. Switch to Form view, and double-click btnTest to add the click event handler. Add the following code to the handler:

   String myConnString = 
       "Provider=SQLOLEDB.1;User ID=sa;password=sa;Initial Catalog=pubs;
       Data Source=mySQLServer";
   String mySelectQuery  = "SELECT * FROM Authors";
   
   ADODB.Connection myConnection = new ADODB.Connection();
   ADODB.Recordset myRecordset1 = new ADODB.Recordset();
   ADODB.Recordset myRecordset2 = new ADODB.Recordset();
   try
   {
       myConnection.Open(myConnString,"","",0);
   
       //Setting the ActiveConnection to a Connection object will work properly.
       myRecordset1.ActiveConnection = myConnection;
   
       myRecordset1.Open(mySelectQuery,myConnection,ADODB.CursorTypeEnum.adOpenKeyset ,
   ADODB.LockTypeEnum.adLockReadOnly,0);
       MessageBox.Show(myRecordset1.Fields[0].Value.ToString());
   
       //Setting the ActiveConnection to a Connection string will fail.
       //Comment the next line of code, and uncomment the line that uses
       //the let_ActiveConnection to make the code work properly.
       myRecordset2.ActiveConnection = myConnString;
       //myRecordset2.let_ActiveConnection(myConnString);
       myRecordset2.Open(mySelectQuery,myConnection,ADODB.CursorTypeEnum.adOpenKeyset  ,
   ADODB.LockTypeEnum.adLockReadOnly,0);
       MessageBox.Show(myRecordset2.Fields[0].Value.ToString());
   }
   catch (Exception ex)
   {
       MessageBox.Show(ex.ToString());
   }
   finally
   {
       myRecordset1.Close();
       myRecordset2.Close();
       myConnection.Close();
   }
   					

8. Modify the connection string (myConnString) as appropriate for your environment.
9. Save your project.
10. On the Debug menu, click Start to run your project.
11. Click the button. A message box displays the result from the first Recordset object. This indicates that the assignment goes through successfully when you set the ActiveConnection property of the Recordset object to another object (in this case, the Connection object).
12. Set the ActiveConnection property of the Recordset to a string. Notice that the code fails with the above-mentioned exception.
13. Close the exception dialog box, and stop running the program.
14. Comment out the line that sets the ActiveConnection property to a Connection string. Uncomment the line that uses the let_ActiveConnection method.
15. Run the project again. Notice that the data is returned properly.