FIX: Access Violation in MSADCE When You Execute a SHAPE Query Using a .udl File (208210)

RESOLUTION

To work around this problem do either of the following:

Use a connect string instead of the .udl file to open the connection. For example:

Note Make sure that the uid <username> has the appropriate permissions to perform the required operations on the database.
```
cnn.Open "Data Provider=MSDASQL;DSN=Pubs;uid=<username>;pwd=<strong password>;"
					
```
Use server-side cursors.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article. This problem has been fixed in Microsoft Data Access Components 2.1 Service Pack 2 and later versions. You may download the latest MDAC service pack from the following Microsoft Web site:

http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp

MORE INFORMATION

Steps to Reproduce Behavior:

Create a .udl file using Microsoft Data Links. To do so, right-click on the Windows desktop, point to New, and select Microsoft Data Link. Use the MSDataShape Provider and reference a DSN pointing to the Pubs database in SQL Server.

Note Under Windows 2000, Microsoft Data Links does not display on the New menu when you right-click on the Desktop. To create a data link file under Windows 2000, create a text file, and then rename it using a UDL filename extension.

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
244659 MDAC 2.5 Sample How to Create a Data Link File with Windows 2000

Create a blank Visual Basic standard exe project, insert a command button into form1, and add the following code to the Click Event:

      Dim cnn As New ADODB.Connection
      Dim rst As New ADODB.Recordset
      Dim rsChapter As Recordset 'Variant
      cnn.CursorLocation = adUseClient
      cnn.Open "File Name=c:\data sources\pubs.udl"
      rst.Open "SHAPE  {select * from authors}APPEND ({select * from titleauthor} AS chapter RELATE au_id TO au_id)", cnn