Re: SQL from access
From: Henry Craven <GospodynNiemandt_at_nyet.net>
Date: Sun, 04 Nov 2001 13:16:15 GMT
Message-ID: <zcbF7.297626$bY5.1172599_at_news-server.bigpond.net.au>
Date: Sun, 04 Nov 2001 13:16:15 GMT
Message-ID: <zcbF7.297626$bY5.1172599_at_news-server.bigpond.net.au>
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...Received on Sun Nov 04 2001 - 14:16:15 CET
> 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.