I can not get DB Import Plus to connect to my database. I copied the files for version 5 to the scada directory. Made sure all .dll’s is unlocked. Rebooted. I could see the driver but nott use it. I added it manually. Now I can use it but its not connecting.
The builtin DB import is giving me some trouble aswell.
https://imgur.com/dOtITfR
I have 2 rows of data in this example.
However, the communicator is only giving me one row off data. see below
https://imgur.com/SjZpYbb
Even if I select the row count manually to 2. I get the correct row plus one empty row.
The tags I want to get is separated like “tag1″,”tag2”
I used a query builder to get the correct syntax. The query works 100% in sql manager query.
This post https://forum.rapidscada.org/?topic=connect-to-microsoft-sql had the same issue but never explained how he resolved it.
Could be advise me on how to get the 2 values I require?