[stackoverflow] [progress Openedge Abl] Progress Odbc Two Database On Same Server In A...

Status
Not open for further replies.
D

Darken

Guest
I'm trying to get a dataset from a single query using 2 Progress ODBC on the same server but different ports.

Connecting to a single database works fine and return results in the dataset. I've searched for more than 5 hours online but I didn't find any working solution.

This is an example of connection string for my odbc connection :

DRIVER={Progress OpenEdge 10.2A Driver};HOST=myServer;PORT=9001;DB=myDB1;UID=myUser;PWD=myPassword;DIL=READ UNCOMMITTED;

I really don't want to merge 2 differents dataset as the tables I'm querying are quite large. I saw examples with msaccess databases and sql server databases, but nothing with ODBC connections. Is that even possible?

I tried something like that but i'm getting a syntax error:

SELECT a.*
FROM myDB1.PUB.Customers a
INNER JOIN [thewholeconnectionstring of DB2].PUB.Sales b
ON a.SomeID = b.SomeID
WHERE a.SomeField = 'SomeFilter'

Continue reading...
 
Status
Not open for further replies.
Top