Kbase P16834: Steps for the connection from Excel to a Progress db with sql92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/28/2010 |
|
Status: Verified
GOAL:
What do you need to do in order to connect from Excel to a Progress db with SQL92?
GOAL:
How to query from Excel to Progress database using SQL-92?
FACT(s) (Environment):
Windows
OpenEdge 10.x
Progress 9.x
FIX:
To connect Excel to Progress database do the following:
1.- For Progress you need: at least a client networking license on the client and a Database Workgroup or Enterprise license on the server.
2.- The ODBC driver for SQL-92 The driver is delivered with the Progress Client Networking license.
Example
Merant 3.60 32 Bit-Progress SQL 92 v. 9.x
3.- Excel with the product 'Microsoft Query'.
a) Start the database with using
proserve <db name> -S <ODBC service name or port number> -H <host name>
Example
proserve sports -S 2755 -H host_one
(If you choose to use an ODBC service name it has to be specified in the services file)
b) Configure your ODBC data source, on Windows under control panel/data sources ODBC.
Chose a name for this data source. Supply the services name or port number that you already used to start the DB broker.
After the configuration of your ODBC data source, you can do a test connect within the data source administrator to see if it is working, and the network connectivity is ok.
c) Open your Excel, go to Data/Get external Data/New Database Query
The data source window will pop up and then you will chose your predefined ODBC data source name, under step b).
Then connect to your DB.