Kbase 19015: How to connect via SQL Explorer(GUI) using JDBC/ODBC bridge
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/08/1999 |
|
How to connect via SQL Explorer(GUI) using JDBC/ODBC bridge
SUMMARY: How to connect via SQL Explorer(GUI) using JDBC/ODBC bridge
Knowledge Base number: 19015
This document applies to: Progress V9.1A Beta Windows NT 4.0
Version and Release Number:V9.1A beta
INTRODUCTION:
The SQL Explorer (GUI version) only supports the JDBC/ODBC bridge.
In order to connect to a database through the SQL Explorer(GUI),
you have to use the URL option to access the JDBC/ODBC bridge.
There is no documentation (either in EDOC or in Online Help)
regarding the JDBC/ODBC bridge and the SQL Explorer aside from
what is mentioned in the hard copy release notes.
STEP BY STEP DETAILS:
Basically, to use the SQL Explorer gui to connect
to a database, you must do the following:
- create a data source name. To do this, do
1. start->settings->control panel
->odbc data sources.
2. click "add"
3. click "MERANT 3.50 32-bit Progress
SQL92 Driver"
4. click "finish"
5. fill out the information on the "General"
tab. Note the data source name.
6. click "OK".
- Use the Progress->SQL Explorer Tool
icon to bring up the SQL Explorer gui.
- Select File->Connect
- Click on the "url" tab.
- Enter "jdbc:odbc:<data source name>" where
the data source name is what you created
in the first step.
Notice that you may see couple of warnings after you connect to the
database saying 'Optional feature not implemented.' but those are OK,
they will soon be gone. You will be able to perform the regular tasks
after connected even though you see those warnings.
REFERENCES TO WRITTEN DOCUMENTATION:
Hard copy Release Notes for 9.1A beta