BUG: Connection Failure with ADO 2.1 and the Jet 3.51 Provider

ID: Q229741

The information in this article applies to:

SYMPTOMS

If you try to set read, write, or read/write access permissions using the ADO mode property within your connection string, you get the error:

Run-time error: '-2147217887' "Errors Occurred"
However, if you use the Microsoft Data Link or the Data Environment designer to set these permissions, you get the following error:
Test connection failed because of an error in
initializing provider. 0x80040e21


RESOLUTION

Remove the "Share Deny None" mode option from your ADO connection string.

If you are using the Microsoft Data Link or the Data Environment designer, you can deselect the "Share Deny None" option from the Advanced tab.

-or-

Use the Jet 4.0 OLEDB Provider instead of the Jet 3.51 OLEDB Provider.


STATUS

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


MORE INFORMATION

Steps to Reproduce Behavior

  1. Right-click on your Desktop, choose New/Microsoft Data Link.


  2. Fill in the appropriate information to connect to your Access Database via the Microsoft Jet 3.51 OLEDB Provider.


  3. Go to the Advanced tab. Select read, write, or read/write permission.


  4. Test your connection. You should get the error.



REFERENCES

For more information, please refer to the ADO documentation.

© Microsoft Corporation 1999, All Rights Reserved.
Contributions by Ammar Abuthuraya, Microsoft Corporation

Additional query words: 


Keywords          : kbADO210bug kbDataview kbOLEDB kbDataEnv kbGrpVBDB 
Version           : WINDOWS:2.1,3.51
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: May 26, 1999