You should really use IBatis!!!!!!!!!!! http://www.learnasp.com/freebook/learn/ibatis1.aspx
It lets you write same code no matter what DB you use and change XML config files and the most efficient provider is used under the covers. UtilityBelt also lets you write identical code no matter whether you use SQLServer or Access and under the covers it uses the fastest way depending on database being accessed. On 6/4/05, Eva Li <[EMAIL PROTECTED]> wrote: > If my application use SQL server database, I use sqlserver. If my > application access both Microsoft access and SQL server, I use > OleDb. > > Eva > > Tony Trapp <[EMAIL PROTECTED]> wrote: > Hey guys I just wanted to know which is better to use when connecting > to SQL server 2000. > > OleDb or sqlserver > > Which one would you choose and why. > > Thanks guys !! > > Tony... > > > > > --------------------------------- > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > > [Non-text portions of this message have been removed] > > > > ________________________________ > Yahoo! Groups Links > > > To visit your group on the web, go to: > http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
