Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

FAQ: What diagnostic tools can be used for testing ODBC connections?
Answer

The following diagnostic tools are available when configuring and troubleshooting an ODBC environment:

  • SSGODBC
  • ODBC Trace
  • Snoop
  • ODBC Test

SSGODBC​​

Informatica provides an ODBC test utility for Windows and UNIX.
For more information about Informatica SSGODBC, refer to HOW TO: Test an ODBC connection (KB 15339).

ODBC Trace​

ODBC tracing allows you to record the ODBC function calls executed to an ODBC driver into a text file.
To create a trace log, turn on tracing, start the ODBC application, reproduce the issue, stop the application, and turn off tracing. Then, open the log file in a text editor and review the output to help you debug the problem. Be sure to turn off tracing when you are finished reproducing the issue because tracing decreases the performance of your ODBC application.
For more information on ODBC tracing refer to the HOW TO: Test an ODBC connection using SSGODBC (KB 18255)

Snoop Trace​

The Snoop tool is a DataDirect Java-based application that logs TCP/IP packets sent over the network between the ODBC driver and the database. You must have a Java Virtual Machine (JVM) installed on the machine where the tool is installed.
When figuring out how to configure the tool in your environment, think of it as a proxy. When the tool is running, it is listening for incoming TCP requests on a specific port number. The Snoop tool redirects those incoming TCP requests to another port number. At the same time, the tool logs the TCP packets to a text file.

You can configure the Snoop tool for one, two, or three-tiered configurations. When starting the tool, you specify the hostname and port number for your database, as well as the port number the tool will listen on for incoming TCP/IP requests.
You must reconfigure your ODBC data source to connect to the Snoop tool, using the tool's IP address and port number. When you establish a connection, the tool will generate a file for each connection made. The file names of the text files created by the Snoop tool will be 0.out, 1.out, and so on.

Syntax:

You can start the Snoop tool using the following command:

java Snoop dbhostname dbportnumber -snoopPort portnumber

where dbhostname is the database server name, dbportnumber is the database port number, and portnumber is the port number the tool will listen on for incoming TCP/IP requests.

Example

java Snoop 127.0.0.1 50000 –snoopPort 5555

For a list of configuration options for the Snoop tool, refer to the readme.
For more information on how to configure the Snoop tool refer to HOW TO: Enable Snoop Tracing (KB 102374)  

ODBC TEST​

On Windows, Microsoft ships an ODBC-enabled application named ODBC Test along with their ODBC SDK. ODBC test can be used to test ODBC drivers and the ODBC Driver Manager. ODBC 3.51 includes both ANSI- and Unicode-enabled versions of the ODBC Test.

For more information about ODBC Test, see the Microsoft ODBC SDK Guide.​​


More Information

Applies To
Product: Data Quality; PowerCenter
Problem Type: Connectivity
User Type: Administrator
Project Phase: Configure; Implement; Onboard; Optimize
Product Version:
Database: ODBC
Operating System:
Other Software:

Reference

Attachments

Last Modified Date:3/3/2020 10:53 PMID:102091
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)