Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Srujan4994
Starting Member
7 Posts |
 Posted - 2014-12-24 : 01:10:51
|
| Hi,I have a report model which was previously using .Net Providers\OracleClient Data Provider data source connection. Now i have connected it to .Net Providers\SqlClient Data Provider. But when i am adding a new column in the dsv all the existing links are breaking down.Although i figured out how to add a new column i am facing different issue now. I can add a new column by refreshing all the dsv. But as the dsv was previously pointing to .Net Providers\OracleClient Data Provider and as i am refreshing it by connecting to .Net Providers\SqlClient Data Provider all the datatypes are getting converted.(Eg: Int64 from Oracle to Decimal in SQL) which is throwing errors during autogenerate process. Can someone help me find a solution/alternative for this? Thanks in advance.Thanks,Srujan |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-12-24 : 08:58:56
|
| well, for starters, is the column that is Int64 in Oracle defined a decimal in SQL Server or as bigint (same as int64)? |
 |
|
|
Srujan4994
Starting Member
7 Posts |
Posted - 2014-12-29 : 07:52:02
|
| Hi,The datatype of column is Numeric(18,0) in SQL and Number(18,0) in Oracle.Thanks,Srujan |
|
|
|
|
|
|
Report Model and DSV