Hello, First use SQL Plus to check the connectivity with Oracle. If it is not working then check whether your ORACLE_SID variable is set or not. If not set it with the value which you have given at the time of Installation for SID.
Hi Guru, i guess, if you have already registered a DSN name for the DB (IS it Oracle?), then from windows(I hope your's is a windows system)->control panel->admin tools->data sources(ODBC), you can test your connection. [I am sure you know this process]. Other than that, you are using Type 1 driver, so no need to think about any SID stuff to connect to Oracle, your code is Ok.