Multiple Datasources

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vizualz@hotmail.com - 17 Sep 2007 21:21 GMT

Hi,

My webapp is coded to use Oracle as a datasource. One of our
customers wishes to use SQL Server as a database. Is it possible to
connect to either datasource using the same code base if it were to be
coded correctly (i.e. with case statements and such). I'd really like
to maintain one code base but I don't know how feasible this is.

Any help or advice is greatly appreciated.

Thanks!

Reply to this Message

Ralph - 18 Sep 2007 02:02 GMT

> Hi,
>
[quoted text clipped - 7 lines]
>
> Thanks!

Yes, using ADO, it is doeable.

There can be a problem with date formats. But you can easily manage that
with a small conditional routine.

The other possible problem area is if your app builds SQL queries, as the
optimal syntax will on occasion will be different for more complex queries.
Using SPs can avoid a lot of issues.

-ralph

Reply to this Message

VB Forum / Database Access / September 2007

Multiple Datasources