On Thu, Nov 25, 2010 at 2:37 AM, Samresh <[email protected]> wrote: > I think you can do something like this. > > Put a Key Value pair in web.config which holds some value that defines > what database needs to be connected to. > Design your Data Access Layer such that the it checks for that value > if value says Access database use OleDb objects to handle the db > operations > else if value says SQL server database use Sql objects to handle the > db operations. > ------------------------------
Your syntax between Oracle and SQL Server is going to be the issue of most pain, not the connector. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell
