‘Check if the specified OLEDB Provider is installed and registered correctly”Example: check the Jet 4.0 OLEDB Provider’MsgBox “The specified OLEDB provider ” & ‘ IIf(CheckOLEDBProvider’ (“Microsoft.Jet.OLEDB.4.0”), “does”, “does not”) &
If you have defined a default document for a given IIS virtual directory, any link pointing to the directory will actually point to the default document for that directory. However,
‘ this should be a module-level or global variable, so that’ Word is instantiated only onceDim MSWord As New Word.Application’ check the spelling of a word” returns True if the
‘ Getting the HTML code of any page on the web’ NOTE: requires the Microsoft XML library’ Example:’ Text1.Text = GetHtmlPageSource(“http://www.vb2themax.com/Default.asp”)Function GetHtmlPageSource(ByVal URL As String) Dim objHTTP As New XMLHTTP
When you use a COM or COM+ from a .NET application and then you set the object reference to Nothing (or let it go out of scope), the object isn’t
SQL Server’s views are updateable, but it is possible that when you insert a new record or update an existing record, the record added or modified doesn’t logical belog to
Many developers mistakenly believe that any error inside a transaction will make the transaction fail and automatically rollback. However, this is true only for fatal errors, such as most errors
Private Declare Sub CopyMemory Lib “kernel32” Alias “RtlMoveMemory” (dest As _ Any, source As Any, ByVal Bytes As Long)’ Uncompress a block of data compressed with RLECompress” Returns TRUE if
You may retrieve a few important information about a connection to SQL Server by querying the server through appropriate @@ global variables. For example, the following routine takes an ADO