In message
<291595756f51e34ea52a45b3a191dae3f5b...@anorpexbe01.auca.corp>, "Martel,
Henry" <henry.mar...@wearguard-crest.com> writes
We are thinking of changing our application connect to Universe through ODBC
connections. Has anyone had experience doing this?
OleDB or ODBC?
Are there any performance issues or considerations that we need to be aware
of?
If you can use OleDB you're probably a lot better off.
I'm sure somebody will correct me if I'm wrong :-) but as I understand
it OleDB is the main connectivity thing, and ODBC is a layer on top of
it. Best avoided if you don't need to use it.
While it still makes an awful lot of sense to run HS.SCRUB, with OleDB
you don't need @SELECT (all your fields and files are visible, which may
or may not be a good thing :-), you don't need HS.UPDATE.FILEINFO, and
generally there's just less to go wrong!
And in my experience, things do go wrong ... accessing UV using the
MS-Access ODBC as a front end is currently passing dud SQL to UV :-(
Cheers,
Wol
--
Anthony W. Youngman <pi...@thewolery.demon.co.uk>
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site - <http://www.maverick-dbms.org> Open Source Pick
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
