Question: odbc how to connect oracle?
Answer: In the Windows Control Panel, double-click Administrative Tools. ... 
Double-click Data Sources (ODBC). ... 
Select the System DSN tab and click Add. ... 
Select an appropriate Oracle driver and click Finish. ... 
Specify the following information in the Oracle ODBC Driver Configuration window: ... 
Click Test Connection.