Hi,
the company I work for has a a Third Party provider DB ("A") that is not accessible via ODBC driver from mine ("C").
I would like to perform - coded - some SELECT... FROM... WHERE queries ; I can via a SQL Server ("B") perform the desire queries and I could via ODBC driver access "B" from "C".
"A" contains several hundred of thousend of recordsets.
I have two options:
a) I could just make a SELECT.... FROM query in "B" and then out of "C" perform my WHERE condition
b) i could make a SELECT.... FROM... WHERE in "B" and get the result in "C"
Questions:
1) does it take the same time to perform a) and b)? and what about memory allocation?
2) how can I pass the condition from "C" to "B"?
3) maybe the most important question: is it possible at all?
Maybe a final info is needed, whereby if it is working in Access should as well work in this case:
"A" is a unix Sybase DB;
"B" is a Sybase SQL Server
"C" is a MS-Access (or eventually a VC++ library)
TIA
filo65
the company I work for has a a Third Party provider DB ("A") that is not accessible via ODBC driver from mine ("C").
I would like to perform - coded - some SELECT... FROM... WHERE queries ; I can via a SQL Server ("B") perform the desire queries and I could via ODBC driver access "B" from "C".
"A" contains several hundred of thousend of recordsets.
I have two options:
a) I could just make a SELECT.... FROM query in "B" and then out of "C" perform my WHERE condition
b) i could make a SELECT.... FROM... WHERE in "B" and get the result in "C"
Questions:
1) does it take the same time to perform a) and b)? and what about memory allocation?
2) how can I pass the condition from "C" to "B"?
3) maybe the most important question: is it possible at all?
Maybe a final info is needed, whereby if it is working in Access should as well work in this case:
"A" is a unix Sybase DB;
"B" is a Sybase SQL Server
"C" is a MS-Access (or eventually a VC++ library)
TIA
filo65
