Toad Data Studio 1.1

지금 지원 담당자와 채팅

Create Amazon Redshift Connections Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Create SharePoint 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

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.

제품을 선택하십시오.

더 나은 서비스 제공을 위해 채팅 목적을 작성해 주십시오.

문제에 대한 권장 솔루션

Toad Data Studio 1.1 - User Guide

Troubleshoot Sybase ASE Issues

Connection Issues

Missing Functionality or Object Information

Other Issues