473,287 Members | 1,709 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

ODBC to Progress Database

1,271 Expert 1GB
My most important client is changing their ERP from Sage to ERP-One+ by Distribution One. The new database is Progress, and they've installed an ODBC for me. I'd like to know if you have any experience with Progress and what quirks or gotchas I might encounter with that connection. I do not, unfortunately, get server access, so I cannot write stored procedures or views or whatever the equivalents are in Progress.

I have already run into one problem which may not be Progress-specific. The order entry / invoice header table has too many indexes (more than 32) so linking to that table with MS Access appears to be impossible. That may be a show stopper for me since so much of what I need to get at is in there. Can you suggest a work-around to this problem?

Thanks,
Jim
Jun 18 '21 #1
0 2830

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: harish | last post by:
Currently my C++ application is using ADO to connect to MS SQL Server database. Now I want to use ODBC instead of ADO. i know that i need to use window APIs I am using SQLConnect to establish...
3
by: Doc | last post by:
Hi all, Hoping someone can make me smart. Have SQL Srv2000 database linked (ODBC) for query. Have my completed Query. Want to save out THAT data to a local area for later manipulation (in Access...
0
by: Anthony Sox | last post by:
Hi I need assistance with connection string parameters for a progress database. Thank you in advance
3
by: Garikayi Mukombachoto | last post by:
I desparately need assistance in connecting to a progress database. Could some one please assist or provide pointers thanks in advance.
5
by: jonathanlim | last post by:
I am trying to append data to my local access database from an oracle connected database. I tried using the default query function but it take a very long time and it sort of hangs there and no...
2
by: Randy | last post by:
Hi,all I met one problem of connecting Access database in asp.net web program. I use ODBC link to Access, the connection string like "PWD=12345;DSN=QADLinkMDB;DriverId=25;MaxBufferSize=2048;FIL=MS...
0
by: jags_32 | last post by:
Hello We use MFG-PRO as our ERP system which in turn uses Progress databases. In the old version of SQL 2000, using DTS packages, we used to set the code page via command prompts and execute DTS...
6
by: jags_32 | last post by:
We have spent days trying to perform a proof of concept and I am dissappointed with SSIS to say the least. We are trying to connect and fetch data from a Double Byte Progress database and the...
2
by: c.a.duevel | last post by:
Hello! I have a really weird problem, here: I'll have to link tables of a sql server 2005 database to an access 2003 database. This works without a problem, but those linked tables get up to...
9
by: Moah Scout | last post by:
Hi all! I have a database which is connected to another db by ODBC Connection string via VBA. What I want is to have those tables succesfully connected through ODBC be accessible in my...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.