View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Patrick Dave Patrick is offline
external usenet poster
 
Posts: 249
Default How do I stop the SQL Login screen when refreshing a query.

Does your SQL server use windows authentication? Domain or workgroup? What
connection string are you using?

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Elbmag" wrote:
|I want to share a workbook that utilizes a ODBC SQL query. When the
workbook
| is opened users a presented a SQL login screen showing the username,
password
| , and SQL server. All the user has to do to clear this screen and refresh
| the data is click 'OK'. How can I prevent this screen from being
displayed
| at all?