Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X
Hello community,
The Data Logger poped out a warning window showing "unable to retrieve column information" when I was setting up the column mapping for a tag. My ODBC data source (32bit) had been configured and tested successfully, so as the target table in the database. I tried reinitializing the enviorment and reconfiguring the data source but did not make any progress. The snapshots are attached below. Any suggestions are welcomed and appreciated.
Thanks again for your attention.
Solved! Go to Solution.
Thanks for your help but I found the cause of the problem.
My DSN driver was outdated (SQL Server Ver. 6.02) for SQL Server 2019. Therefore, an compatibility issue showed up when KEPWARE tried to access the data table. Replacing the system DSN driver with "ODBC Driver 17 for SQL Server (ver. 2017.1710) solved the issue.
Triple check the field names in the database and int the datalogger and also make sure the data types match. Speaking from experience...
Thanks for your help but I found the cause of the problem.
My DSN driver was outdated (SQL Server Ver. 6.02) for SQL Server 2019. Therefore, an compatibility issue showed up when KEPWARE tried to access the data table. Replacing the system DSN driver with "ODBC Driver 17 for SQL Server (ver. 2017.1710) solved the issue.