We have several factory locations, so we are trying to link all CMM's together, common versions of PcDmis and Datapage. We would like to dump all of our reports into a common database, so that engineers and project managers from any location can look at results from any other location.
We have Datapage pointed to the correct remote Database, I can manually import XML files all day, but that's tedious and stupid. I also have to manually import CAD, and it's just a headache.
So if I create a local database on my machine, input a Stats command, it dumps no problem. CAD, data, all there, easy peasy. Trying to get PcDmis to link to the remote SQL server or whatever, isn't so easy.
It passes the test connection in the F9 settings, seems to see it, but I get this message when using stats with an offline option,
That doesn't come up until after I ok the prompt to update the database.
Then you need to have your IT department create what is called and ODBC DNS so your computer can connect to the remote server using a name. These are per user so if multiple users connect to that database the DSN needs to be created under ever account.
Then you need to have your IT department create what is called and ODBC DNS so your computer can connect to the remote server using a name. These are per user so if multiple users connect to that database the DSN needs to be created under ever account.