I wonder if some can help me.

I have a client who has a system created in Progress.

He needs to the system to be able to write data to a Microsoft Access
database.

He has been informed that this requires an Access ODBC driver that
costs £250 per seat. And this would take 3 days programming to
achieve.

Has anyone undertaken the writing of data to Access, and is the above
correct ?

Thanks, D

mcderd (AT) yahoo (DOT) com (Dennis) writes:

Why?

Depending on the server running the Progress database, it may
already have client networking licences that provide ODBC.

I don't do anything relating to Access "databases"; not since my
first experience with Access. Some of my customers do that
themselves; obtaining data by ODBC connection to a Progress database.

It's their "toy applications" that extract the data from the main
ERP system's database. Those applications have been known to kill
network performance through ill-composed queries that return
gigabytes.

The ERP system doesn't and shouldn't write to Access databases.

--
/"\ Bernd Felsche - Innovative Reckoning, Perth, Western Australia
\ / ASCII ribbon campaign | I'm a .signature virus!
X against HTML mail | Copy me into your ~/.signature
/ \ and postings | to help me spread!

On Windows you can use ADO from Progress to get to Access, SQL Server
etc. There are examples of this on the Progress knowledge base.
have used this technique to do bulk copies of data from Progress to SQ
Server. I have some generic "adocopy" code that might be a good star
for what you need. If you want to discuss this just drop me a privat
message and I we can connect by phone or email

--
ccotter

Hello ccotter3,

Thanks to responding to my post about this subject.

I sent you an e-mail but it bounced.

The problem is that the company supplying an application in Progress
has been asked to populate an Access database with data that is to be
synchronised with the companies website (which has an Access back end
database)

The company are claiming that they have to buy ODBC licences to write
to Access databases, they claim these cost £250 per seat and it will
take 3 days programming to set up.

This seems excessive to me, I would have assumed they would have made
a connection then just run an SQL INSERT query ?

Your generic "adocopy" code would certainly help me understand what's
involved a little better.

Regards, D

ccotter3 <ccotter3.1etezm (AT) progresstalk (DOT) com> wrote

In order for a Progress client to connect to Access, it needs something
called a DataServer product. Think of it as a protocol translator. A
progress client has NO idea how to talk ODBC without a DataServer.

The client makes a connection to the DataServer which in turn makes an
ODBC connection to the access DB. It is probably like this:

ProgDB
--<Proprietary>--PrgClient--<Proprietary>--PrgDataServer--ODBC--Access

with the data shuffling logic happening on the PrgClient.

Now here is a different way, if you are on Version 9 or better, the
progress RDBMS has an ODBC connection built into it.

This means that an Access client can connect to an ODBC based data
source and talk directly to the Progress database.

Now this has some dangers, because access is not known for it's
optimizations and power (go by MS SQL Server if you want that!) Also,
you may need to buy another connection license to the Progress DB for
the additional user that Access connection represents. Third - if you
don't know the schema for the application, the people who do may want to
keep that a trade secret... .


In article <79e6b45c.0410280143.68d32b2d (AT) posting (DOT) google.com>,
mcderd (AT) yahoo (DOT) com (Dennis) wrote:

Hello Scott,

Thanks for your response.

From what you say it may be the DataServer product that this company
claims costs £250 ?

Can anyone shed any more light on what ccotter3 said about doing this
with ADO ?

Thanks D

In article <79e6b45c.0410290047.3e569c29 (AT) posting (DOT) google.com>,
mcderd (AT) yahoo (DOT) com (Dennis) wrote:

I know they are a little pricey. At least the Oracle one is.