How to Build a similare DataBases on Oracle and SQLServer

From: Laurent <l.moulhaud_at_alfainfo.fr>
Date: Wed, 5 Jun 2002 13:34:07 +0200
Message-ID: <adksvh$nq8$1@s1.read.news.oleane.net>

Hello,
I am looking for some tips to make a software ( VB, ADO) that could handle Oracle and SQLServer.

1/As first left join is not supported by Oracle do i have to

Check which server I am on (client side) and change the script before opening recordset and so - should I better use the funny join of Oracle ( Where tab1.field1 = tab2.fields2 (+) ) for both case what to do for the (+) Is there so spécial kind of oledb that make the translation for me, or

2/ Will it be reasonnable to create similare Store Procédure on both systeme or make the treatment on client side (the application wasn't doing so bad on MSACCESS) 3/Is there special trouble like kind of Recordset not supported,, implicite transaction,..) that we should especialy care about.

thank. Received on Wed Jun 05 2002 - 06:34:07 CDT