Everytime I test my Datapage+ 2013 connection to my Excel Spreadsheet PC DMIS 2103 crashes. I am on a 64-bit Windows 7 machine with 32-bit office. I tried setting my ODBC connections inside the %system%/Syswow/ folder as well. I even went so far as to redirect the control panel settings to the %system%/SYSWOW/ folder. Still PC-DMIS crashes every time I test the connection.
Okay could it be crashing because its not available in 2013 yet but the options are there? if so how do I install a working DP+?
RonDog -- Yes it crashes when I try to test the database in PC-DMIS. Reason I am trying to use the ODBC connector for 32-bit programs is the Microsoft office install is 32-bit. Unless its been fixed you have to setup the connector in the %system32%/SYSWOW folder. How excel fits is that's the format my users want the data to be compiled in(excel). My level of knowledge here is limited as I am the IT person trying to help our Quality department on this project. Are there any kind of training materials on the subject I can read?
Ok. I know what you are doing.
PC-DMIS is expecting to write to a pre-configured Datapage+ database. I know you can see other databases in the ODBC list but you should stick to the ones created by Datapage+. All this means is that PC-DMIS is not checking to verify the database is valid before running whatever tests they run (and therefore it crashes). The ones you are manually creating are not valid Datapage+ databases.
You are correct that you need to use the ODBC configuration options for the 32 bit sub system if you want to manually setup the connector that will be seen by a 32 bit program. I have had to do this myself on occasion.
You cannot send stats data directly from PC-DMIS to Excel even if you setup the ODBC connector properly; this is only used to send to a Datapage+ database. The database tables setup by Datapage+ look like a giant mess so if you were thinking of using some other database driver you likely find it tough as you would need to manually create all of the tables. I looked at this once and was very disappointed by what I saw.
Okay could it be crashing because its not available in 2013 yet but the options are there? if so how do I install a working DP+?
RonDog -- Yes it crashes when I try to test the database in PC-DMIS. Reason I am trying to use the ODBC connector for 32-bit programs is the Microsoft office install is 32-bit. Unless its been fixed you have to setup the connector in the %system32%/SYSWOW folder. How excel fits is that's the format my users want the data to be compiled in(excel). My level of knowledge here is limited as I am the IT person trying to help our Quality department on this project. Are there any kind of training materials on the subject I can read?
Ok. I know what you are doing.
PC-DMIS is expecting to write to a pre-configured Datapage+ database. I know you can see other databases in the ODBC list but you should stick to the ones created by Datapage+. All this means is that PC-DMIS is not checking to verify the database is valid before running whatever tests they run (and therefore it crashes). The ones you are manually creating are not valid Datapage+ databases.
You are correct that you need to use the ODBC configuration options for the 32 bit sub system if you want to manually setup the connector that will be seen by a 32 bit program. I have had to do this myself on occasion.
You cannot send stats data directly from PC-DMIS to Excel even if you setup the ODBC connector properly; this is only used to send to a Datapage+ database. The database tables setup by Datapage+ look like a giant mess so if you were thinking of using some other database driver you likely find it tough as you would need to manually create all of the tables. I looked at this once and was very disappointed by what I saw.
