:I have one application with fron-end developed in Omnis 7 and backend in
Sybase 10.0.3 and OS is Solaris 2.6. I didn't have code for front-end. Currently we want to upgrade database to Sybase supported version 12/12.5 .
Is it possible to upgrade database without affecting application. What will be the impact on application due to upgrade. Any known issuse in Sybase upgrade from 10.0.3. Any suggestion are highly appreciated.

Hiya,

Technically the upgrade should work from SQL Server 10.x to ASE 12.x. However, this may not be supported by Sybase, at least from the documentation you need to make sure you are at least at ASE 11.0.3

You need to perform a lot of testing and application aclamatization prior to the production upgrade.

Cheers
Willy

Due to this upgrade do I need to make any changes in Fron-end tool connectivity. My front-end is develpoped in OMNIS 7 but we don't have any code for fron-end.

Can you suggest what are the risk involved in upgrade.

you possibly will run in some trouble, if the application is dependent on features of an old sybase client and its dlls.
You might need to set proper sybase environment variables, if the boxes shell use your old appication an newer appications which need sybase client 12.5

you should check the sybase documentation whats new in ase which will give you some hints on what might go wrong

bernd