64bit extract data from Progress to SQL

[gah]

Hi

requirement:

to extract data into SQL 2008 R2 from OpenEdge 10.1C

environment:

Progress 10.1C 32bit running on Windows 2003 server (32bit)

SQL 2008R2 64bit running on Windows 2008 server (64bit)


..long story short:

can this be done via SQL SSMS using an OPENEDGE 10.2x 64bit ODBC driver?



have tried to get this to work using 32bit/64bit OE drivers and have had a multitude of issues...some of which I can resolve in 32bit but still fails in SQL Agent job.

If there is anyone who has this scenario and has found a solution, I would appreciate their thoughts.

kind regards gah

 

[RealHeavyDude]

The SQL client (driver) always connects as a remote client (via TCP) to the database, therefore it does not matter whether they have the same bitness (32 vs. 64Bit).

Did you set up the database to accept SQL connections?
Did you set up the SQL security on the OpenEdge database?

Usually the above two are not set up correctly by people who don't know the OpenEdge database.

You could start to provide more details about the error messages you get.

Heavy Regards, RealHeavyDude.