Q. Why can’t I find my database in the list of ODBC sources.

A.  In order for a data source to appear in the list, you must first have installed a driver for the particular database system and, then you must have configured the driver to point to your database.

Drivers are usually supplied by your database vendor, and, particularly  if you are using a client-server database, you must make sure that you have installed proper components for your particular workstation and network.

A data source, in ODBC parlance, is a driver configured to point to a particular database. For instance, you might have a driver for Oracle data and two Oracle data sources, one for each of two clinical trials you are analyzing. You can configure an ODBC driver to connect to a particular database by running the ODBC driver manager from the Windows Control Panel. Only properly configured data sources will appear in Stat/Transfers lists of available data sources.

Q. I can see my data source on Stat/Transfer’s list, but I encounter errors when I try to connect to it.

A. There are many possible causes for this problem. Your ODBC driver may not be properly installed or configured for your network.  Your database server and/or network may be down.  You might not have proper access rights or the proper password for your database.

We suggest you try to connect to your database with another tool, particularly one that is supplied by your database vendor or a general tool such as Microsoft Excel. If you still encounter difficulties, you should first seek support from your local database administrator and/or the vendor who supplied your database or driver.

Q. How can I join two tables in a relational database

A. Many database systems allow you to define a “view”, that will appear to Stat/Transfer as a single table. If you database allows this, it is the simplest and most robust way of joining tables for Stat/Transfer. If this option is not available, the Stat/Transfer command processor allows you to submit an SQL select statement.  It is simply passed through to your ODBC driver, so it must be legal SQL for your particular database driver.

[Home] [Products] [Ordering] [Downloads] [Support] [Lists] [Contact Us]

Please contact our Webmaster with questions or comments.