Re: SQL from access
Date: Sun, 04 Nov 2001 13:16:15 GMT
Message-ID: <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 Sun Nov 04 2001 - 14:16:15 CET