Move GSS from 32bit Win2003 to 64bit Win2003

[Migration User]

I'm attempting to decommission our older 32bit Windows Server 2003 server hosting Ghost Solution Suite 2.0 (was upgraded from Ghost Solution Suite 1.1 previously) and move our database and settings over to a freshly installed GSS 2.0 on a 64bit Windows Server 2003. After attempting the procedures mentioned in a previous forum post on moving the data base and extracting the registry information from one server to another, I ran into a problem.

After copying over the old database and applying the appropriate registry changes, Ghost Console reports when starting up that it can not read the database file, indicating a Sybase error as follows:

28000 [Sybase][ODBC Driver][Adaptive Server Anywhere]Invalid User ID or Password

After doing some investigating on the differences in the original installation and the new one I performed (I had not performed the original installation, and no reference material for me to check) I found that there is an ODBC driver installed on the original Server for Adaptive Server Anywhere on the original server, but not on the new 64bit server. Is this something I need to add manually to the new 64bit server, or was this a remnant of the original GSS 1.1 after it was upgraded to GSS 2.0?

Any insight would be greatly appreciated, as I certainly don't want to manually add all of our tasks, AI Packages and such... that's almost 300MB worth of data.

Thanks!

Dustin Mitton
Server Operations Specialist
Sunrise School Division
Oakbank, Manitoba, Canada

[Migration User]

Unfortunately, the old procedure I developed for moving the database doesn't quite work properly in build 1533 of the server, which is the 2.0.1 version; unfortunately there's a small bug I introduced that stops the process server importing the database password information properly.

I've written a script that automates the database backup/restore process for GSS1.1 and GSS2.0 which you can get by registering with a Google account at http://groups.google.com/group/gss-scripts - the database backup/restore scripts can be used to easily move servers as well.

As for the ODBC drivers, actually they are probably present and working fine on the 64-bit system, it's just you can't see them in the ODBC control panel. One of the peculiarities of 64-bit Windows is that 64-bit programs can't use 32-bit DLLs or vice versa; ODBC drivers are DLLs, and so for our (32-bit) executable we install 32-bit ODBC drivers.

However, the ODBC control applet (odbcad32.exe) is a 64-bit program on 64-bit Windows, and is completely unaware of the 32-bit ODBC system. It doesn't know the 32-bit drivers or any 32-bit data sources exist. To work with ODBC on a 64-bit windows system, you have to know to manually run the 32-bit ODBC control panel applet, which doesn't have a shortcut anywhere.

To run the 32-bit ODBC applet, use Run from the start menu and use this as the file name:

%WINDIR%\SysWOW64\odbcad32.exe

That should let you see the providers which have 32-bit drivers installed, and any data sources defined for them.

[Migration User]

Thanks Nigel, I'll download the scripts and give it a try.