swphillips
Member
I'm having difficulties getting ODBC set up in FactoryTalk View Studio for the purposes of datalogging, and I'm hoping that someone here can clarify the way it works.
I followed this video to set up an ODBC system data source in Windows. The "Test Data source" button at the end of setup confirmed that it could communicate with the database. I then went into FactoryTalk View Studio, and that ODBC source is not available in the datalog model setup menu.
I then used the "New..." button on Factory Talk View's System Data Source selection dialog box to create an ODBC source there. That process was virtually identical to the windows process, and the "Test Data Source" button confirmed that it could talk to the database. Furthermore, the "Create Tables" button in the datalog model setup window was able to actually create the tag, float, and string tables in my database. However, when I tried to start the datalog model, Factory Talk View gave the following error: "Unable to access ODBC data source. (Failed to connect to datasource)."
The curious thing to me is that FactoryTalk's ODBC list and Windows seem to have no correlation to each other. I've tried various techniques to create ODBC sources (using the default windows odbc, using windows odbcad32.exe, using factoryTalk, and doing all those again with "run as administrator"). I've attached screenshots for each of these ODBC data source lists.
My main problem is how to get the datalog model working, but I'd really like to know where FactoryTalk View Studio gets it's lists from. If I check the ODBC entry in the windows registry it only lists the ODBC sources that appear in the windows dialog boxes.
I followed this video to set up an ODBC system data source in Windows. The "Test Data source" button at the end of setup confirmed that it could communicate with the database. I then went into FactoryTalk View Studio, and that ODBC source is not available in the datalog model setup menu.
I then used the "New..." button on Factory Talk View's System Data Source selection dialog box to create an ODBC source there. That process was virtually identical to the windows process, and the "Test Data Source" button confirmed that it could talk to the database. Furthermore, the "Create Tables" button in the datalog model setup window was able to actually create the tag, float, and string tables in my database. However, when I tried to start the datalog model, Factory Talk View gave the following error: "Unable to access ODBC data source. (Failed to connect to datasource)."
The curious thing to me is that FactoryTalk's ODBC list and Windows seem to have no correlation to each other. I've tried various techniques to create ODBC sources (using the default windows odbc, using windows odbcad32.exe, using factoryTalk, and doing all those again with "run as administrator"). I've attached screenshots for each of these ODBC data source lists.
My main problem is how to get the datalog model working, but I'd really like to know where FactoryTalk View Studio gets it's lists from. If I check the ODBC entry in the windows registry it only lists the ODBC sources that appear in the windows dialog boxes.