Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » SQL
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
SQL
Resolved · Low Priority · Version 2003
Reply Fri 20 Feb 2009, 14:57Delegate Tim said...
Tim has attended:
Excel VBA Advanced course
SQL
Can I write code to incorporate passwords so I can contact SQL servers smoothly?
For upcoming training course dates see: Pricing & availability
RE: SQL
Hi Tim. That depends a lot on the SQL server you're linking to. It is possible to write code which will detect password forms and automatically fill them with the correct login information, but this would be a time-intensive project to simply avoid a login dialog. On the other hand, incorporating passwords when contacting SQL servers is a security issue and will necessarily slow the connection process so it's something we all have to live with, unfortunately! The password setup will obviously be within the SQL software rather than in Excel, as Excel in this case is the "front end" of the process, with the server operating in the background.
Hope this helps,
Anthony
Mon 27 Apr 2009: Automatically marked as resolved.
|