Im using Oracle linux 6.3..where there is no sort of odbc.ini or sys.odbc.ini to set up our own DSN(neither the default DSN).I want to use my type-1 odbc driver for making a java program to contact with my oracle 11g Express edition instance.Tired of many ways to set up DSN in linux on internet,but all went in wain(Because all of them teach me to edit odbc.ini file,which was not present).
You can recommend using unix odbc package,but why should I have to install it as type1 odbc driver requires no additional software?.please help me to set up my own DSN file.Thank You.
I think you're a bit mistaken. The type 1 driver does require an ODBC driver manager, and (as far as I know) there is no ODBC driver bundled with unix distributions. In any case, you should avoid the type 1 driver whenever possible.
The type 4 driver is the one which does not need any other software to run. Get the type 4 driver for Oracle (see our Oracle FAQ page for download links).
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com