September 22, 2023 at 9:57 am
We are working on a project to migrate a client from a version of SAP Sql Anywhere (Sybase) to SQL Server 2022.
However, we have encountered a challenge.
The current application calls stored procedures and passes parameters, e.g.
CALL TheStoredProc @a, @b-2+@c, @d
However, to my knowledge, SQL cannot receive parameters that contain mathematical operators.
Does anyone know how we can get this working (we are not allowed to change the vendor's application).
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
September 22, 2023 at 10:31 am
If that is the syntax that the app will use, and you cannot change it, won't it fail anyway, because of the 'CALL'?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
September 22, 2023 at 11:29 am
you will need to speak with vendor - and see if the application is already prepared to work with SQL Server instead of Sybase. It may well be just a case of installing a different version of the application or maybe changing configurations (or a reinstall with SQL Server as the target db)
September 22, 2023 at 4:23 pm
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply