Hi,
We are doing an interface with a proprietary database which has the extension as .rbm. we are using ODBC adapter to communicate with that database. we are supposed to fetch data by joining 3 different tables. But unfortunately we couldn’t get the syntax. if any one has worked previously with database (.rbm) using ODBC, kindly provide us the SQL grammer so that we can write queries/storedProcs with dynamic parameters thru adapter.
Version: Biztalk 2006
Driver: Dr. DeeBee ODBC Driver Kit (Bronze Edition) provided by Custom
database
Adapter: http://www.codeplex.com/ADOProviderEngine
with regards,
Ravi