Very Computer

Quote:> Can someone please advice me of how to connect to a Progress Database
> residing on a Unix box and extract data into SQL Server 2000. Anyone
> had any luck? Which vendors ODBC drivers work best?

There is an ODBC driver out there for Win32 that you can use..

Cya

Peter

I have used Openlinks Universal Data Access Driver and Merant
SequelLink driver. I was not happy with the performance / usability of
these drivers. You will not be able to register Progress as a Linked
Server, as it does not support all the Meta Data functions required to
link it. The performance is also hopeless.

I ended up getting SQL 2000 to call Progress 4GL queries, with output
of query as a text file, and then calling a DTS script to load data
into SQL 2000. I used this approach for a SQL Data Mart that pulled 5
GB data every night from Progress 8.3b / Compaq Tru Unix 64. This
approcah can also be used to do real time Pass Thru queries to
Progress. The only problem you might encounter is parameter passing to
Progress 4GL, as it will only accept 1 command line parameter. If you
need to pass several paramaters, pack them all into a string seperated
by a suitable marker, and then pull that string apart in the Progress
4GL script, prior to executing query. To get this approach to work,
you will need to install Progress 4GL on same machine as SQL 2000.

The OpenLinks Driver is free for 1 Serer / 5 Connections. SequeLink is
approx  12,000 AUD.

The bottom line is that Progress is a very difficult DBMS to talk to.

HTH
Martin