Re: SQL from access

generic sql for all databases: that a story ! eg sql hints are different, several functions are different etc ...

when you write generic sql, your performance would be realy slow !

Don't worry, nobody change every day his database engine, and once you use Oracle you wouldn't change it anymore ...

I've worked with several DB's ....

Erik
Oracle DBA Consultant.

"Henry Craven" <GospodynNiemandt_at_nyet.net> wrote in message news:<zcbF7.297626$bY5.1172599_at_news-server.bigpond.net.au>...
> OLEDB is preferable as it is faster then ODBC, having less overhead
> and also not requiring the setting up of a DSN.
>
> There are OLEDB providers for most major DataStores.
>
> --
> Henry Craven
> ---------------
> H_Craven_at_bigpond.com
>
> "Tlali Phoofolo" <phoofe_at_lhda.org.ls> wrote in message
> news:284df33d.0111040212.4583ab4_at_posting.google.com...
> > Hi there
> >
> > The best way to connect to databases today is through ODBC. Why ?
> > Because we have to be dynamic when it comes to which tool to use. Try
> > ODBC that connects to Oracle. Then change connection string to
> > "DSN=datasourcename;UID=connectionID;PWD=connectionpassword"
> > Use search replace facility of your editor to do this. After that
> > there might be a need to change certain things in your SQL, though
> > this is not likely.
> >
> > Good luck.
Received on Thu Nov 08 2001 - 12:04:42 CET