I'm using SQL 2005 (SSIS - Integration services) to connect to Oracle R12 using Oracle Drivers. Data appears to be OK on both the Oracle and SQL server DB but on the SQL server Database, precision values are not displayed.
I have a $94.50 on a particular DB view in Oracle
When queried the same table in SQL server 2005 (SSIS), the same value is shown as $94
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…
Configuring and using Oracle Database Gateway for ODBC
First, a brief summary of what a Database Gateway is. A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…