Search code examples
node.jsexpressopenedgeprogress-db

How do I establish a connection to an OpenEdge database

I'm trying to connect to the OpenEdge database so that I can perform queries on it. However, I'm having trouble figuring out how to connect to it to make these queries.

So far I've tried making a config file, but I'm unsure how to establish a connection to the server using it:

"HMMv10": {
    "dbConfig": {
    "connectionString": "DRIVER={Progress OpenEdge 11.3 Driver}",
    "UID": "SYSPROGRESS",
    "pwd": "***",
    "host": "host.local",
    "port": "18210",
    "db": "hmm10"
    }
}
Solution

  • I'm putting up what I found to be the answer just in case anyone else is looking for this. Using a REST API in NodeJS I used npm-odbc and the OpenEdge odbc drivers to connect to the database. Even though the npm-odbc package only mentions Unix it does in fact work on windows.