Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a webpart which needs to use a native 32bit DLL for data access (the dll is Advantage.Data.Provider, for the Advantage Database Server DBMS.) As such I'm pretty sure I need to compile it as 32bit. However, my SharePoint server is 64bit.

If I compile the webpart project with platform target as x86, the webpart doesn't appear for me when trying to populate the web part gallery (_layouts/NewDwp.aspx).

(And if I compile the webpart with target 'Any CPU', the webpart appears in the gallery and I can add it, but when I try to add it to a page I get "Unable to load DLL 'ace32.dll'". I guess this is because it's running 64bit and trying to access a 32bit DLL.)

Can I use 32bit webpart in 64bit SharePoint? Or maybe there's another way around this?

share|improve this question

2 Answers 2

up vote 1 down vote accepted

My understanding is that SP2010 won't load a webpart compiled x86 only. Compiling with the target 'any CPU' means it will get Jitted to 64-bit when run inside the 64-bit worker process. That will prevent loading any 32-bit DLLs, as you say in the question.

You either need an 'ace64.dll', or load your db access code in another process somehow.

share|improve this answer

Whats the version of Advantage Data Provider you are using?

I saw this similar thread, which says that the New Release of Data Provider would be 64-bit.

http://stackoverflow.com/questions/2273887/sybase-advantage-database-server-and-64-bit-vfp-ole-providers

Did you get chance to download the new version?

share|improve this answer
    
We're on ADS unfortunately, so can't get the 64bit provider it seems.. –  ngm Dec 21 '10 at 16:44

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.