|
Either install the oracle instant client or install the full oracle client with odbc support.
Suppose you install the full client which I usually do to c:\oracle
then you can find a filename tnsadmin.ora, this one contains the settings to your databases (for remote and local databases). Check out www.orafaq.com/wiki/Tnsnames.ora for details. here you need to add your database names. Be aware that remote databases must of course have the correct ip and correct port number and sid (your dbadmin should know those). For a local db you can use the example given (check the port numebr tho).
Have oracle in your path and reboot (if needed). Start your c:\oracle\bin\sqlplusw.exe and enter your username, password and sid. If this does not work then you have a setting wrong or your firewall is stopping you. Basically it should work.
After that you should be able to get your oracle working via odbc or via .net drivers fairly easy. You can use ms access or a free tool like foxysql or freesql to check that.
You can use the microsoft odbc driver for oracle but also the oracle odbc driver from oracle itself (which is what I prefer).
The difference between the two is that a timestamp datatype doesnt work properly in the microsoft version and that a clob and blob seem to work somewhat different in the microsoft compared to the oracle driver.
I myself always prefer the microsoft odbc driver.
This should get you started quickly.
The instantclient can be set up easily as well but you'd miss some of the tools that are handy. But setting up both will cause trouble so be warned..
|