Panopea Consulting - iMIS Blog

Sybase ASA Support Ending in 2006

Today, ASI made this announcement regarding support for Sybase Adaptive Server Anywhere:

Beginning with the iMIS 10 Maintenance release in late 2006, please be advised that ASI will discontinue development, testing and support for the iMIS 10 Product on the Sybase (ASA) platform.  The upcoming 10.6 release is the last release in which iMIS for ASA will be supported. Beginning with the release after 10.6, release date not yet scheduled,  there will no longer be an upgrade path for ASA and Technical Support will no longer be able to support your questions regarding the use of iMIS 10 running on a Sybase (ASA) platform.   Your application may continue to run on Sybase, but such use is at your own discretion.

As of the 10.6 release, scheduled for 1st quarter of 2006, e-Series will no longer be available to ASA customers. Affected customers have already been notified. Once 10.6 is released, no further fixes will be made to issues found in iMIS for ASA.

Installing Sybase on Win 2003 Server

Earlier this month a client got a new server with Windows 2003 Server as the OS. Their network tech guy installed Sybase ASA. As you know iMIS uses a very old version of Sybase -- version 6, released long before Windows 2003! After the install of Sybase ASA onto a new Windows 2003 Server, the service could not be started. Within Service Central the error message said "Error 6 invalid service handle." It generated an error message in the Event Log of "invalid Win32 application".

What to do? I found some references on the Sybase site about other products which led me to believe the problem was about long file names. I found the following solution to be successful in getting the Sybase database service to run:

Step #1 - Make a change to the registry entry at HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ASANYs_MILLENNIUM

I changed the ImagePath to add double quote marks around the path for c:\Program Files\Sybase\Adaptive Server Anywhere 6.0\Win32\DBSRV6.EXE.

You can click on the image above to see a larger view of it.

Then here are screen shots of the actual edit I made:

   

STEP #2 - I also had to add the double quote marks in the Configuration settings of the MILLENNIUM service. The path to the Log file (the path that follows the –o switch) needs to have quote marks around it.

Hope that helps some of you out there in the iMIS world.