I think I may have my problem corrected, but it occured to me that this might be a bigger problem than I originally thought.
I am working on an application that is going to use a .sdf database file to store data. I noticed that while I was at work today blasting away at setting the database up everything was fine. Saved the project, took it home and started working on it here...problem...my Workstation at work is Vista Ultimate 32 Bit...my computer at home is Vista Home Premium 64 Bit...SQL Server Compact Edition doesn't work anymore :(
I found a work around...and it might work...I hope...
But here is the question...since this application is going to rely on SQLSCE (which is made by MS)...when I distribute my application, obviously a copy of SQLSCE will need to be distributed with it...32 bit apps run on 32 and 64 bit systems (generally speaking), but 64 bit apps don't run on 32 bit systems...right?
How can I find out if my user is running a 32 or 64 bit OS, so that they can install the correct version of SQLSCE?
BTW...the error I get is:
Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Lame.
Everything was working fine at the office, but I guess the 32 bit version of SQLSCE is distributed with Visual Studio...I didn't know that.
Is this going to be a major problem when I decide to distribute my app when I'm done?