I want to test a connection from Microsoft Visual Basic (VB) 6.0 to SQL Server. I tried to conduct the test through SQL-DMO's VerifyConnection property but was unsuccessful. Listing 1 shows the code I used. Where did I go wrong?
If you need to know whether your VB—SQL Server connection is working, you can use the PingSQLServerVersion method, as
Listing 2 shows. This code executes fast...