Link to home
Start Free TrialLog in
Avatar of bethzy
bethzy

asked on

VB and ODBC for Progress

How can I connect a Progress Database with VB, or where can I get the ODBC drivers?
ASKER CERTIFIED SOLUTION
Avatar of a111a111a111
a111a111a111

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of a111a111a111
a111a111a111


ODBC Drivers Available For Progress

Several companies have made drivers for Progress databases, including Intersolv, OpenLink, and Progress themselves.  Drivers are specific to the version of Progress:

Version 6
Esker Tun SQL
Intersolv DataDirect ODBC Version 2.1
OpenLink ODBC (MT)
Progress

Version 7
Intersolv DataDirect ODBC Version 2.5 (16 bit and 32 bit)
Intersolv DataDirect SQLLink (In Beta as of 7/97)
OpenLink ODBC (MT)
OpenLink Lite (16 bit, 32 Bit Small Client, and 32 Bit Large Client)
SCO SQL Retriever

Version 8
Intersolv DataDirect ODBC Versions 2.5 (16 Bit and 32 Bit)
Intersolv DataDirect ODBC Version 3.0 (32 Bit)
OpenLink ODBC (MT)
OpenLink Lite (16 bit, 32 Bit Small Client, and 32 Bit Large Client)


from http://www.innov8cs.com/odbc.htm 
I have used ODBC drivers for Progress from both Intersolv and Openlink.  Neither is perfect, however, currently I prefer the Openlink drivers.  They seem much faster and easier to configure.
Also, Openlink appears much more interested in their Progress drivers than Intersolv.

I have VB 6.0 enterprise.  The "persistent" ADO connection used with the Openlink driver is pretty cool, check it out.