Toad Data Point 5.7 - User Guide

サポートと今すぐチャット

Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Understand Toad Connections Troubleshoot SQL Server Connections

Understand

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Query

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Report

Tutorial: Create a Toad Data Report Manage Reports

About Managing Reports DB2 Reports MySQL Reports ODBC Reports Oracle Reports SQL Server Reports

Publish and Share Reports

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

Troubleshoot Sybase ASE Issues

Review the following solutions to help troubleshoot SAP issues pertaining to the following in Toad:

Connection Issues

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 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.

Missing Functionality or Object Information

Issue	Cause/Solution
Unable to view or export data for objects with non-standard names.	The ASE ODBC driver has issues handling non-standard names for objects. 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

Unable to view or export data for objects with non-standard names.

The ASE ODBC driver has issues handling non-standard names for objects.

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.

Other Issues

Issue	Cause/Solution
DBMS name showing as SQL Server.	Older versions of the ASE ODBC driver return SQL Server as the DBMS name. Solution: Upgrade to the latest version of the ODBC driver, which correctly returns Adaptive Server Enterprise as the DBMS name.

Issue

Cause/Solution

DBMS name showing as SQL Server.

Older versions of the ASE ODBC driver return SQL Server as the DBMS name.

Solution:

Upgrade to the latest version of the ODBC driver, which correctly returns Adaptive Server Enterprise as the DBMS name.

製品を選択してください:

サービス向上のために、「Purpose of your Chat（チャットの目的）」を記入してください。

お客様の不具合に推奨されるソリューション

Toad Data Point 5.7 - User Guide

Troubleshoot Sybase ASE Issues

Connection Issues

Missing Functionality or Object Information

Other Issues