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.
How did you create a database on the remote server?
I honestly couldn't answer that, our IT guy hooked all that up. Probably directly from Datapage, as on of our other locations is already using it. They are also having to manually upload results and CAD files to it though.
I can dump locally, and using the DataImporter tool, have it check and upload to the remote server. I just cannot do it directly from PcDmis.
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.
We have one, and PcDmis passes it through the test connections. Right now I have Datapage working by automatically saving XML files locally, then using Dataimporter to grab them and upload them to the database, but that's not how I would like it to work. I would like it to automatically do it all like it did for the demo after a prompt to save.