How to set your ODBC connection on 64 bit Windows Server

Sometimes we need to move your server from 32 bit operating system to 64 bit, but you have to make sure that your application support 64 bit. I have HR application that connect to our SQL Server 2005, it was running on 32 bit but i had to move it to 64 bit. I set the application and tried to connect to database, it seemed everything went well. But when i try to start the application it said that odbc is not set and bla bla bla…. I check my ODBC setting again, I believed it was there but the question is why?  I asked my uncle abot this and it said that some of visual basic application is rely on 32 bit ODBC. If you’re on 64 bit windows system yu must make sure that you’re setting the right ODBC.

• The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
• The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.

Make sure you load the 32 bit ODBC and set your system DSN there. After setting my ODBC connection, I tried to lunch the application one more time and it works this time Thank’s to Allah.

source : http://support.microsoft.com/kb/942976

Migrating Novell GroupWise 7.03 to Ms. Exchange 2010

Finally it’s time to move from Novell GroupWise to Ms. Exchange 2010.

It’s been 13 years i’ve been using GroupWise since version 4 to version 7 and now I have to get use to Microsoft Exchange. It’s a big project since we have to move not only mailboxes and contacts but also We’re moving our E-Directory to Active Directory.

I’ve been searching and doing some research on this migration process, our neightbourg in UK were using tools call Quest which cost about USD 30 per mailboxes and also they hired external consultant.

After 2 months doing research and experiment on my personal lab, thank’s to msexchange.org, support.novell.com, microsoft.com and other forums website, I manage to do this migration my self without to spend any money. All you need is read, try and error plus documentation. I am also had created documentation on how this migration process, if you need it please drop a comment here and your email.

Finally i managed to move all the mailboxes, calenders, task and contacts. Another task waiting for me is to install Office communication Server in our office.

Thank’s to Allah swt for everything and also to my family for supporting me and make me believe that i can do this project.