Hello,
I'm trying to use a custom query wich will get Points from an external SQL database. I can run the query through Entreprise Manager and it conforms to the Map_Points table structure.
When I transfer the TSQL into the module and add the Connection String, the module simply reports "fetching...", but no Points are shown.
In the "connection String" field I'm using:
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Is this what is expected for the connection string field or am I doing something wrong here?
Can anyone provide samples for a custom query setup on a separate SQL server database, since the documentation doesn't show a connection string for a custom query?
Thanks