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...
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...