Home -> Usenet -> comp.databases.oracle -> Re: SQL from access

Re: SQL from access

From: Tlali Phoofolo <phoofe_at_lhda.org.ls>
Date: 4 Nov 2001 02:12:49 -0800
Message-ID: <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 - 11:12:49 CET












Original text of this message