Background: I'm a computer science student doing some work for a non-for-profit, and have minimal experience with SP 2007, ODBC, etc.
Overview: I'm trying to create a BDC definition file using the definition editor (found in the SDK), rather than editing a template XML manually. I found this thread to be fairly helpful in getting me started on what seems
to be the right path:
In order to establish a connection to the remotely hosted MySQL database I must provide an ODBC source for the client user/system, correct?
My questions are:
- How does using ODBC affect things once I upload the ADF to the Shared Services Provider (SSP)?
Do I now need to provide a duplicate ODBC Source on the server hosting sharepoint for the BDC to connect to the database?
Apologies if I am not understanding this correctly.
- If the above process is correct, how might I expect this process to change for sharepoint 2010? The organization is looking to roll-out SP2010
View Complete Post