[dba-SQLServer] Upsize wizard and named queries

Susan Harkins harkinsss at bellsouth.net
Sat Jan 21 09:28:44 CST 2006


 
IMHO do not waste your time and effort with ODBC. Go straight to ADO-OLE. It
is simpler to connect, to maintain, using its disconnected architecture is
much more stable and the performance is far superior.... With all/most of
the queries in SPs, the whole system will be really optimized.     

========And has the advantage of being readily connected/switched to any
number of products. I advise anyone working with mdbs to use ADO-OLE if
there's ANY possibility of foreign connections or upsizing. 

Susan H. 




More information about the dba-SQLServer mailing list