Oracle on a UNIX box (OpenInsight Specific)
At 13 MAY 1999 10:49:27AM Tony Hensby wrote:
Does anyone know if you can still connect to Oracle using ODBC when oracle is on a UNIX box.
At 14 MAY 1999 10:34PM Bob Carten, WinWin Solutions, Inc wrote:
Yes you can. You may need to buy a layer (sql_net?) to take care of the mapping. Avoid straight ODBC access to your data tables if you can, as security becomes problematic. You grant a user rights to the payroll system so they can use your tightly controlled screens, the user immediately uses an ODBC connection from Excel to have their way with the data. Middleware products, such as Intersolv's ODBC gateway, can help you maintain control. Oracle probably offers a similar layer. OICGI offers another way to provide easy but tightly controlled access to your ODBC data.
Hope this helps
Bob