Binary_double Oracle data type support

I'm using RS 2000 and I'm getting an "unsupported Oracle data type 101 encountered" error when attempting to retrieve data from a dataset based on a plsql stored procedure. I'm assuming this is related to a recent update on our Oracle 10g database to convert columns from number to binary_double.

Can anyone confirm if this is the case, and suggest a work-around? Is binary_double supported in RS 2005?

Thanks

RS uses MS .NET provider for Oracle which currently does not support binary_float/double.

The possible workaround is to cast binary_float columns to number in your SQL statement

select cast(my_bin_float_col as number) from ...

BI Dev Studio won't install with June CTP reinstallation

I am attempting to install the BI Development Studio, from the SQL Server 2005 June CTP, on an XP machine. It installed successfully the first time I installed it, along with all other Workstation Components and BOL.

Subsequently I have uninstalled and reinstalled the Workstation Components, but the installation process does not fully install BI Development Studio. It creates the C:\Program Files\Microsoft Visual Studio 8\Common7\IDE directory (where devenv.exe should be located), but this directory is empty other than the PrivateAssemblies and profiles subdirectories. After an installation , the Start Programs menu contains an option for “SQL Server Business Intelligence Development Studio” under "MS SQL Server 2005 CTP", but this shortcut points to the non-existent C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe

There are no installation errors, and everything else seems to install OK, but BI Dev Studio is simply not there..

I have used both Add/Remove Programs, and the Build Uninstall Wizard, to remove the installation before trying the reinstalls.

This machine also has Visual Studio 2003 and a SQL Server 2000 instance, but they were already in place prior to my first successful installation.

Thanks in advance!

This is not a very satisfying answer, but here's how we fixed it.

After running the Build Uninstall Wizard once again, we manually removed all folders and all files throughout the hard drive related to SQL Server 2005 (i.e. 9) and Visual Studio 2005 (i.e. 8). Also all registry entries. After manually removing all of this, the installation worked successfully.

Bottom line: the Build Uninstall Wizard fails to remove quite a few files and registry settings on your machine, some of which prevented the successful reinstall of the BI Dev Studio.