Tip Bank

Question: I have two questions: 1. How can I determine what the server’s lock mode currently is (e.g. WAIT, NO WAIT, etc.), without actually setting it at the same time?

Question: What are the differences between Provider=MSDASQL.1 and Provider=SQLOLEDB.1 in an “Open” “Select” statement? Also, what is the difference (if any) between “ADO” AND “OLE/DB”? And finally, in Visual Basic,

Const HKEY_LOCAL_MACHINE = &H80000002′ get the list of ODBC drivers through the registry” returns a collection of strings, each one holding the’ name of a driver, e.g. “Microsoft Access Driver

Const HKEY_LOCAL_MACHINE = &H80000002′ Information about the CPU’ you can pass a number 1 to the last argument to retrieve’ information on all the processors in a multi-CPU system” Returns

Const HKEY_LOCAL_MACHINE = &H80000002′ read the name and path of the external HTML editor’ configured for the VB environment” Requires the GetRegistryValue functionFunction GetExternalHTMLEditor() As String ‘ Note that the

Const HKEY_LOCAL_MACHINE = &H80000002′ read the value of a setting for the VB IDE from the Registry’ Important: only works with VB6” Possible values for SettingName are’ AlignToGrid (returns 0/1)’

Const HKEY_LOCAL_MACHINE = &H80000002′ Return the number of processors” Requires the CheckRegistryKey routineFunction GetNumberOfCPUs() As Integer Dim keyName As String ‘ loop on the subkeys of HKEY_LOCAL_MACHINEHardwareDescriptionSystem ‘ CentralProcessor ‘

Private Declare Function GetVersion Lib “kernel32″ () As LongConst HKEY_LOCAL_MACHINE = &H80000002′ Modify the name of the registered user and organization” Requires the SetRegistryValue functionSub SetRegisteredUser(ByVal UserName As String, Optional

Const HKEY_LOCAL_MACHINE = &H80000002′ Return information about an ODBC driver” The 1st argument must be an ODBC driver name,’ as returned by the GetODBCDrivers function’ Not all drivers return the