Create New JDBC Connection
Start the New Connection Assistant (File menu) and select the database server you want to connect to in the database selection. All database server with special support are listed by name. If you are using any other JDBC enabled database server choose "Generic JDBC".
If you are adding your first connection to a particular database server choose "I don't know" for "Driver Installed". This will check for the necessary JDBC driver and try to load the driver. If there is an error with the driver installation this setting will detect and report it.
Click the right arrow to continue with the assistant.
Comment on Microsoft SQL Server: The official Microsoft JDBC driver does only support SQL Server 2000 and newer. If you want to access SQL Server 6.5 or 7 we recommend you to choose the jTDS driver. The jTDS driver also works with SQL Server 2000 and is fully supported by the New Connection Assistants automatic download feature.
Detect JDBC Driver
Click on "Detect" to load the chosen JDBC driver. If the driver is already installed "JDBC Driver loaded." is displayed in "Connection Status".
If an error occurs with the JDBC driver the message is displayed in Driver Manager Messages.
Click the right arrow to continue with the assistant.
Download JDBC Driver
This page will only be displayed if you want to access a database server and the New Connection Assistant did not recognize any installed drivers on your system.
Click "Download" to start downloading the necessary JDBC driver. Depending on the license of your database vendor this can either result in an immediate download and installation of the driver or a guide how to install the JDBC driver is displayed.
| Oracle | You have to register with Oracle Technology Network (OTN)before you can download any Oracle JDBC drivers. A complete guide with links to OTN and the download area is displayed. More >> | |
| MySQL | Thanks to MySQL AB the drivers license allows direct download. The driver will be downloaded from our web site and installed automatically. Restart SQL4X Manager J after downloading the driver to load the driver with SQL4X Manager J. | |
| MS SQL Server | You have to download the driver from Microsoft's download page. The Unix driver works very stable on Mac OS X, although Mac OS X is not listed as supported operating system. A complete download and installation guide is displayed. More >> | |
| OpenBase | Thanks to OpenBase Inc. the drivers license allows direct download. The driver will be downloaded from our web site and installed automatically. Restart SQL4X Manager J after downloading the driver to load the driver with SQL4X Manager J. | |
| PostgreSQL | Thanks to PostgreSQL the drivers license allows direct download. The driver will be downloaded from our web site and installed automatically. Restart SQL4X Manager J after downloading the driver to load the driver with SQL4X Manager J. | |
| Sybase | Thanks to Sybase Inc. the drivers license allows direct download. The driver will be downloaded from our web site and installed automatically. Restart SQL4X Manager J after downloading the driver to load the driver with SQL4X Manager J. | |
| Generic | Mac OS X supports any pure-Java JDBC driver. Download the driver from your database vendors web site or copy the driver from the installation CD. A JDBC driver usually consists of one or several .jar files. Copy these files to /Library/Java/Extensions and restart SQL4X Manager J. Start the New Connection Assistant again, select "Generic JDBC" for Database Server, "YES" for Driver Installed and click the right arrow. The documentation provided with your JDBC driver includes information on JDBC driver name and URL. These information have to be entered manually in JDBC Connection Settings. |
Restart SQL4X Manager J after downloading your new JDBC driver. This is necessary for SQL4X Manager J to recognize the new driver.
JDBC Connection Settings
As soon as your driver is installed and ready to use the JDBC Connection Settings panel is displayed. Enter the following values to connect to your database server:
| Display Name | Use any name here to identify the connection later. This name is listed in Database Navigator, Database Quick Access and SQL Console in any connection dialog. | ||||||||||||||||
| IP Address | Enter the IP address or DNS name of your database server here. | ||||||||||||||||
| Port | Usually you can leave this field empty. SQL4X Manager J connects to your database server using the standard port settings as long as you don't specify any other port. | ||||||||||||||||
| Database/SID | Enter the name of your standard database here. This setting depends very much on the capabilites of your database server and the JDBC driver, but in most cases it defines only the standard database selected after connecting to your database server. Limitations
|
||||||||||||||||
| User | Enter a valid user name to connect to your database server. Some common user names to access your database server
|
||||||||||||||||
| Password | Enter the password for your user. Attention: The user name and password is saved in clear text in your applications preferences file and can be read by anyone with access to your Mac OS X account. So make sure you don't give out your Mac OS X password. The password will be saved encrypted to Mac OS X keychain in a future release. |
Click the right arrow to continue with the assistant.
Test JDBC Connection
Click on "Connect" to check your JDBC settings. The selected JDBC driver is loaded, a connection to your database server is established and the connection is opened for access with the specified user and password.
Any error messages are displayed in "Connection Messages". If your conenction is established successfully "done." is displayed behind each step in "Connection Status". Otherwise you can see which step failed.
To correct errors in the JDBC settings click the left arrow to go back.
What does failed mean at this position:
| Load JDBC Driver |
There is a problem with your JDBC driver. Either you skipped the testing in the assistant and your driver is not installed correctly or the JDBC driver does not comply to the JDBC 2 standard. Most JDBC 1 drivers are working, but not all, depending on the implemented features. To do: Check your driver installation following the instructions of your database vendor. If your driver is installed correctly and the problem remains check for a newer driver which supports the comeplete JDBC 2 interface. |
|
| Connect to database server | Either there is a problem with the specified IP address / Port or your database server is not running. | |
| Open Database | The login information did not work. Check if you specified the correct username / password. Check the existence of this user on your database server and that the user has the access privileges necessary to establish a network connection. |
Click the right arrow to continue with the assistant.
Finish Driver Setup
Click on "Finish" to add your new connection. Your changes to the connection will not reflect directly in other parts of the SQL4X Manager J. To see the new connection click on "Refresh" in the Database Navigator.