Skip to main content
B
BI_106427797-Bedrock
7-Bedrock
June 30, 2023
Solved

Data Logger (V6.13.250.0) was "Unable to retrieve column information".

  • June 30, 2023
  • 1 reply
  • 1912 views

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.


     

 

Best answer by BI_10642779

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.

1 reply

S
SlidingDownhill12-Amethyst
12-Amethyst
June 30, 2023

Triple check the field names in the database and int the datalogger and also make sure the data types match. Speaking from experience... 

    B
    BI_106427797-BedrockAuthorAnswer
    7-Bedrock
    July 3, 2023

    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.

    Terms & ConditionsCookie settingsAccessibility statement