Several users of our PostgreSQL app data prefer to see query results in Excel. This seemed straight forward enough using a System DSN but as more detailed Excel files were developed, it was discovered that each query (one per worksheet tab) required its own user/password login. Quite frustrating when there might be 4 different queries of interest.
Might anyone have insight in having all queries performed with a single login?
Douglas
Can you describe your technique in a bit more detail? I’m not sure what it is you are doing? Are you running the queries from Excel to a PG database and you need to login in Excel to access the PG database? Is Clarion involved somewhere in the process?
Yes, the queries all come from Excel (ie select * from myPGview). The login is for PG authentication.
When I create the Excel files, a System DSN is declared for the connection. This looks to save the connection string in Excel without a username/password. My Excel understanding for the user is that a User DSN (including login/password) could be defined with the same name as the System DSN and Excel would pass this for aunthentication. For some users, this technique does indeed work when the Excel file holds only one query, but if multiple queries are included, Excel seems to request multiple logins. The result is something like requiring a PG login for each browse in your Clarion app – not likely a happy user feature.
Douglas