Have you or your IT people recreated the ODBC connections?
Upgrades, especially difficult ones, often mean that database structures and enquiries related to them will have changed so old definitions will not work. Or the locations of things have changed. Or it may simply be that the drive mappings (for drive T: in this case) need to be changed.
On the other hand of you can see the data using other programs on the same ODBC connection there may be something more specific about the connection that needs to be reset for Monarch to gain access. Passwords or anything like that in play?
The location of the data files on the server HAS changed.
However, the location for users has not. We map out the Timberline folder to "T:". When we changed the folder location on the server, we updated the network drive map for the users as well.
So for the users, the location is the same.
Passwords ARE in effect.
Do any other applications have direct ODBC access using their pre-upgrade DSN definitions? I'm thinking maybe Excel or something.
Have you created new ODBC connections to see what happens?
Are all the Monarch installation exactly as they were before - no parallel changes to consider on that side?
Could it be something to do with user account permissions on the new folder which is now known as the T: drive?
Just some thoughts - you have probably looked at these things already but I'll throw them in just in case.
You are a thoughtful and clever man. However, the problem was much simpler than I had anticipated. Timberline charges for use of their odbc driver. When I upgraded the application, I neglected to enter the activation code for the driver. A quick talk with tech support at Timberline (Their support is excellent) and the problem was solved.
Thanks for your help anyways.
When I upgraded the application, I neglected to enter the activation code for the driver. A quick talk with tech support at Timberline (Their support is excellent) and the problem was solved.
Hehe! A trick question then!?
And of course one of those simple things that we have all overlooked from time to time. (Many times in my case I have to admit.)
Glad you found the cause and got the fix. Also that you have a supplier with a great Tech Support operation. Such things seem rare these days. My recent experiences have been very mixed. Where service stands out it seems it is often down to the individuals involved.
Have fun with your upgrade.