בעייה במעבר מ Access ל mySQL

השגיאה שקיבלת נובעת מאחת משתי סיבות
1. אם מפתח הרגיסטרי של OLE DB לא מוגדר נכון….
2. אם מחרוזת החיבור שלך לא תקינה.
פתרונות:

* Do not use the "Persist Security Info" keyword in your ADO connection string.

———————————————————————–

* Add the OLEDB_SERVICES registry entry as follows:IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows Registry
1. Start Registry Editor (Regedit.exe).
2. In the registry under HKEY_CLASSES_ROOTCLSID, find the CLSID of the OLE DB Provider. For example, the following registry key is for the Microsoft OLE DB Provider for SQL Server (SQLOLEDB):
HKEY_CLASSES_ROOTCLSID{0C7FF16C-38E3-11d0-97AB-00C04FC2AD98}
Click the CLSID, and then on the Edit menu, click Add Value and add the following registry value:
Value Name: OLEDB_SERVICES
Data Type: REG_DWORD
Value: 0xFFFFFFFF

NOTE: To find the CLSID for the provider you are using, search for the provider's ProgID (SQLOLEDB, for example) in the registry under HKEY_LOCAL_MACHINESOFTWAREClasses. Under the ProgID, there will be a key named CLSID.

———————————————————————–

* If the above conditions are satisfied and you still receive the error, check your connection string for other possible errors.