We have migrated the underlying database used in all our reports.
We use predominantly free hand SQL connecting using a shared connection to a sybase database.
The sybase database has changed network locations and port number and the connection details have been updated to match this both in the SQL.iNI file, ODBC settings and Connection details in BO.
The problem we are having is that there are hundreds of reports scheduled and any report scheduled are failing when they atempt to connect to the database.
The error message is still displaying the old server name which makes me believe the connection is being cached.
The strange thing is that If i schedule the report to run now it runs OK but the minute i use a schedule to run on an event and specific days it returns the same error referencing the old server.
I have tried recreating the schedules but the same error returns.
For the life of me I cannot find where / how to fix this issue and any suggestion swould be really helpful. or if there is any documentation on such issues then please point me in the correct direction.
Thanks in advance