Review the following solutions to help troubleshoot SAP issues pertaining to the following in Toad:
| Issue | Cause/Solution |
|---|---|
|
Unable to connect to the database. The following message displays: "The ODBCMDA procedures have not been installed on this database..." |
Stored procedures that the ODBC driver requires currently do not exist on the server. Solution: Install the required procedures. |
| Issue | Cause/Solution |
|---|---|
|
Unable to view or export data for objects with non-standard names. |
The Solution: When setting up an ASE connection in Toad, select Use quoted identifiers on the Connection tab in the Adaptive Server Enterprise window to enable the use of quotations in identifiers. |
| Unable to view linked tables. |
Linked tables store DSN connection information. Solution: Set up the DSN connection information exactly the same on all machines that access the database. |
| Issue | Cause/Solution |
|---|---|
|
DBMS name showing as SQL Server. |
Older versions of the Solution: Upgrade to the latest version of the ODBC driver, which correctly returns Adaptive Server Enterprise as the DBMS name. |
