3) Alternatively this field can be an ODBC driver specification that eliminates the need to create a DSN or Data Source on the server. As an example:
DRIVER=BIOVIA Oracle 7.1;AUT=0;EDP=1;PRR=1;HOST=dbHost;UID=dbUser;PWD=dbPwd;PORT=1521;SID=dbSid (the AUT=0, ... settings reflect the correct defaults of 'Application Using Threads', 'Enable SQLDescribeParam' and 'Procedure Returns Results').
Note: could you please help me with the exact syntax to connect ODBC and JDBC. Ff you can send me example protocols helps me.