Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn IB Bloggers
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CLOSED] How to connect the progress database
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] How to connect the progress database
 Login/Join
 
Member
posted
Hi Everyone

I am using the progress database version 9.1E. I can not able to connect database using ODBC driver. Can you suggest, how to connect this lower version of progress database using Data migrator

Please help me, to resolve this issue.

Thanks
Kalaivanan

This message has been edited. Last edited by: Chuck Wolff,


WebFOCUS 8
Windows, All Outputs
 
Posts: 25 | Registered: February 17, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Dumb question: What is the issue with the ODBC driver?


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1029 | Location: Toronto, Ontario | Registered: May 26, 2004Reply With QuoteReport This Post
Member
posted Hide Post
Hello Dhagen

ODBC driver is not installed in the Progress database server, Only JDBC driver is available. How can i connect the progress database using JDBC driver ?

Thanks
Kalaivanan

This message has been edited. Last edited by: Kalai,


WebFOCUS 8
Windows, All Outputs
 
Posts: 25 | Registered: February 17, 2017Reply With QuoteReport This Post
Guru
posted Hide Post
Kalai

The jdbc driver will need to be on the machine where data migrator is installed and in the CLASSPATH environmental variable. Then you will configure a generic jdbc adapter to connect to it. You will need to know the driver name and jdbc connection to your progress database server as well as a user id and password.

Hope that helps


Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 375 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Hi Chuck wolff

Can you please explain in details with steps to followed ?

1. Which progress JDBC driver i need to use for progress9.1E ? where i can get this ?
2. How install the progress jdbc driver (In Linux) ?
3. After download the driver. Where i can set environment variable path (In Linux)

I am new to this, in DMC.

Thanks for your support

Kalaivanan

This message has been edited. Last edited by: Kalai,


WebFOCUS 8
Windows, All Outputs
 
Posts: 25 | Registered: February 17, 2017Reply With QuoteReport This Post
Guru
posted Hide Post
Currently Information Builders supports Progress through an ODBC adapter on UNIX and Windows. It's documented in Adapter Administration chapter "Using the Adapter for Progress." We recommend using this.

Information Builders does not at this time provide a JDBC adapter for Progress. It may be possible to use the generic JDBC adapter although it's not been tested with Progress. It's documented in the same manual in the chapter "Using the Adapter for JDBC."

1) Information Builders doesn't supply JDBC drivers for Progress (or any RDBMS). You need to obtain the JDBC driver from the database vendor. Please see OpenEdge JDBC Driver

2) Follow the instructions provided with driver.

3) Follow the instructions in the reference above.
 
Posts: 325 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
you still need help. I have it up and running in production. let me know


IWay SM 5.6, 6.01, 6.1, 6.9, 7.0
EDI, XML, XSD, WF 8.0, DM 77,8.0 asp.net, SQL Server
 
Posts: 81 | Registered: February 27, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CLOSED] How to connect the progress database

Copyright © 1996-2017 Information Builders, leaders in enterprise business intelligence.