What do most of you use with MSSQL? OLEDB or ODBC?

I've read numerous pages that say OLEDB is a better choice, I know this
is very true with Access dbases, but what about with MSSQL?

I've tested an OLEDB connection with MSSQL and it picks up ODBC dates
just fine, and the Booleans don't need to be converted either.

I've seen numerous pages that say use OLEDB over ODBC with MSSQL, but
I'd like to know other opinions before we switch everything over.

______________________
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com

______________________________________________________________________
Why Share?
  Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation � $99/Month � Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to