Thursday, January 28, 2010

MAPIInitialize fails with code 0x80010106 in C#

I've tried to use MAPI in C# but MAPIInitialize keeped on failing with error code: 0x80010106.

The clue I found only is that this error code is related to multi-threading.
The answer was simple - set the application attribute:
[STAThread]

Thursday, January 21, 2010

WinSNMP C# wrapper fails in 64 bit systems

Some time ago I wrote a C# wrapper for WinSNMP. Recently I moved to Win7 64 bit and that application failed to run. I thought it's because of Win32 API change, but it seems like the issue was with 32 bit vs. 64 bit.

Solution: (work-around) compile the application to x32:
Right click the project -> Build -> Platform Target -> x86

It could be that I did something wrong in the wrapper, but I really don't have the time to check it out.

Sunday, January 10, 2010

Convert SQL Server Database to Access MDB

I tried looking around the web how to accomplish the following task:
Convert SQL Server Database to Access MDB

I couldn't find any answer online, but on the way to work it hit me: use SQL Server Management Studio "Export". I just checked it and it works like a charm. In 2 minutes I was able to export the SQL Server database to Access MDB.

Just do:
1. Open SQL Server Management Studio & connect to the SQL Server database.
2. Right click the database and select - "Tasks" => "Export"
3. Select the source database & select Access MDB as destination.
Continue with the instructions.