I have a FM application connected to SQL Server through an ODBC connector.
It works really well, but the issue I am having is the deployment from my development machine to the server.
Even though the ODBC in the server is named the same as the development machine, when I deploy the databases the application goes crazy.
Because it does not find the ODBC, it starts changing parameters in the scripts to random fields and relationships to the next value found in other tables. It took me a considerable time to make it work live.
Now I started developing in the life server which not cool.
Did any one of you had the same issue? if so how did you go about it?
Thank you in advance.