Hello All,
I have a query table that is refreshed from a sql server. I have the connection string figured out
but, when I try to use it on someone's computer who doesn't have a datasource setup, it prompts them to do so with the ODBC Administrator program. Is there a way I can do this programatically?
user's connection is to a SQL database.
Update: Okay, found out about DSN-less connections currently using
However, the "Select Datasource" window still crops up. How do I set up the connect to avoid any prompts to "select Datasource" as that is a manual, technical process
Update: for servername, had to specify ip address as some end users were accessing remotely.
Bookmarks