ODBC connection to SQL server (Access Point) - Write Back
Hi Guys,
I have been able to create a write back script which inserts/modifies/deletes records to/from a SQL server database.
When I open the QV dashboard from QV access point (using IE plug in), the scripts works perfectly fine if the computer is on the same domain as SQL server
Issues comes in when:
1) I open the dashboard (through Access Point) from a computer on a different domain (other than SQL server)
2) And, a DSN pointing to SQL server is not defined on local machine
Ideally, when accessing dashboard from QV server it should use the DSN's defined on server instead of DSN's defined on local.
Is there something that I am missing on configuration/settings? I am attaching herewith the script used: