To create an Oracle DSN with the dbdsn utility, use the following syntax:

dbdsn -w data-source-name -or -c configuration-options

The configuration-options are described in SQL Anywhere 16 - Oracle ODBC driver.

For example:

dbdsn -w MyOracleDSN -or -pe -c "Userid=dba;Password=sql;ServiceName=abcd;ArraySize=100000;ProcResults=y;enableMSDIC=n"

See Data Source utility (dbdsn).

 See also