Summary
This article contains information on the error "An error has occurred. The list of Worksheets could not be loaded" when using the Business Adapter Studio.Symptoms
When opening an existing adapter XML file using the Business Adapter Studio (BAS) you may receive one of the following errors:
Cause
This error occurs because the driver listed in the connection string of the XML either isn't installed on the system or is not working.Resolution
To resolve this issues, follow the steps below:
-
Open the XML file in a text editor
-
Locate the Connection String and make a note of what is listed in the "Provider=.." or "Driver=..." section
-
In BAS go to Tools -> ODBC Data Source Administrator
-
Click on the "Drivers" tab and see if the driver listed in step 2 is listed
-
If not, you need to install the driver, if it is listed, try re-installing the driver.
Example: If the connection string lists "Microsoft.ACE.OLEDB.12.0" then ODBC Data Source Administrator should have an entry called "Microsoft Access Driver (*.mdb, *.accdb)" version 12.00.* or similar under the "Drivers" tab. If not, you need to install the driver from the Microsoft download site: http://www.microsoft.com/en-us/download/confirmation.aspx?id=237
Other drivers can be located on the relevant publishers website.
Was this helpful?
0/255
Upload Attachment
File Upload
Maximum file
size allowed is 3 MB.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Are you sure you want to cancel the case creation?
Case closed successfully
File Upload
Maximum file size allowed is 3 MB.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
File Upload
Maximum file
size allowed is 3 MB.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Revenera Assistant
Case id: 00001065
Activity: Status change: 2 hours ago