How to Connect to SQL From VB6. If your business does any programming in Windows, then a basic knowledge of VB6 programming concepts is essential.

Figure 2. Successful Azure PowerShell Connection Output. Although this next step might have been set for other reasons, you must have a server firewall rule setup to allow incoming SQL connections ...

When creating automation scripts to discover, add, update or remove records from a remote SQL database, you need to make sure your script can successfully connect to the database.

Tom Fenton shows you two ways to overcome the gotchas when setting up an ODBC connection to a remote database. This article is a follow-up to one I wrote in August 2017, "How To Set Up a SQL Express ...