.Net Stored Procedures on IA64 SSAS

Does anybody know if it is possible to call .Net stored procedures from a 64 bit Analysis Services Installation? Unfortunately the .Net stored procedures which we are trying to use target the x86 platform and not IA64.

(The procedures use an ODBC driver that is only available to 32 bit applications.)

Any information would be appreciated. The trial and error process gives me an MDX error that says that my stored procedures cannot be found. However, SSAS lets me add the x86 assembly to my database without any problem.

You can't cross 32/64 bit process boundaries within a single process this way. You can't try to load 32bit stored procedure into 64 bit process. Analysis Server is not checking the target platform you compiled you SP for on load, but later as you can see it fails to load it.

If you absolutely must to use the 32bit ODBC driver, you have an option of installing 32bit AS on 64bit platform. But that is highly unintuitive. Take a look if you can find native 64bit version of OLEDB provider instead of using 32bit ODBC driver.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I also would like to add here, that unless you are using COM based sprocs (which are off by default), the .NET sprocs are platform agnostic, just like .NET itself. You can take sproc .NET assembly and deploy it to either 32 or 64 bit server without recompilation - it should work fine.

.dbf file import (duplicate Field Names)

I am importing a file creating by an application which exports the file into .dbf format. Very unfortunately, this .dbf file can have fields with IDENTICAL column_names. Utilizing ActiveX, I create an ado connection to the .dbf file using a visual foxpro drver. However, and not unexpectantly, I can not do the 'select *' from the file if there are duplicate names.

Can anyone make recommendations here that might help?

Oh, this is SQL200 in case that impacts what you might advise!!!!

Anyone out there from MSFT want to make some suggestions?|||

Hi Ellen,

I find it surprising that the DBF file can have duplicate field names. What application created it? Is it a FoxPro DBF or a DbaseIV or Paradox DBF?

I assume you are able to read the table structure with something other than SQL Server, is that correct?

Are you using ODBC or OLE DB? The latest FoxPro and Visual FoxPro OLE DB data provider is downloadable from msdn.microsoft.com/vfoxpro/downloads/updates .