Question: I am using SQL Server 6.5 for my database needs and Visual C++ as a front-end. The problem is that sometimes when I switch on the server (where the

Question: Can I use ADO-connected recordsets with MTS? From the information I can find it seems that MTS does not handle them. Answer: You can, but the question is, do

Question: How does Spy++ make the borders of a window blink when you select “Highlight” from the right-click menu? I have a MouseProc in the hook chain, so I can

Question: I am a young programmer trying to learn C++. I have finished the three books that I own, but none of them cover queues or stacks. I have searched

Question: How do I redirect the output of a SQL query to a file? Answer: Use the isql command-line switches to redirect the output of a query to a file.

Question: I have a query that retrieves a field which is a foreign key in two tables. The tables are organization_name and person_name. Each instance of the foreign key is

Question: I want to show my users when a record was last updated. Is there any way to display the timestamp field? Answer: The timestamp field is not a good

Question: How do I take a SQL 6.5 database that is residing on one machine and move the entire database to another machine? Answer: I have three methods for you

Question: I’m running Windows NT 4.0 (Service Pack 3) and have developed an ActiveX Server (EXE) using Visual Basic 6 (Service Pack 3). How come whenever I try to create

Question: I have scoured the Web and can’t find any information on where to obtain BIOS version/name information. As far as I can tell, there are no APIs or C

Question: From the code below, I get output: ‘asdf’ which is correct. But when the VB program is closed, it says VB6 has preformed an illegal operaton and will be

After upgrading your system to FrontPage 2000, you may get an error message when you try to run the FrontPage Server Administrator from the Windows NT Option Pack group. The

It is useful to follow these guidelines when you develop COM components that need to talk to VB. 1. Only use VARIANT data types in your interface . Although VB

Because GUID are 16 bytes in size, you don’t want to pass them by value. Instead, you should pass them by reference. This is why Queryinterface takes a constant reference.

You can experience a great increase in database performance if you utilize connection pooling. Creating a connection to a database takes a lot of time and resources. If every you

‘ the name of a control given the corresponding VBControl object’ (accounts for items in control arrays)Function VBControlName(vbc As VBIDE.VBControl) As String Dim index As Long index = vbc.Properties(“Index”) If

‘ Returns the nesting level of a TreeView’s Node object’ (returns zero for root nodes.)Function NodeNestingLevel(ByVal Node As Node) As Integer Do Until (Node.Parent Is Nothing) NodeNestingLevel = NodeNestingLevel +

Every now and then you need to fill a TreeView control with some random data, for example when you want to test a routine and you don’t want to write

‘ Convert to uppercase, lowercase, or propercase the text that is’ currently selected in the active code windowSub ConvertSelectedText(VBInstance As VBIDE.VBE, Optional conversion As Long = _ vbUpperCase) Dim startLine

‘ Returns a value >0 if Node1 is a parent (or grandparent) of Node2’ Returns a value

Internet Information Server (IIS), by default, uses an apartment-threaded, or single-threaded, threading model. This design choice was made because many Web sites still used Access as the database backend. Access,

What is wrong with this code snippet? #include #include using std::string;using std::list;class Node {/*..*/};int main(){ list ln; //error} If you try to compile this example, your compiler will issue numerous

When a long line of a quoted string has to be broken, you can use the line continuation marker as described in the tip Use the Continuation Marker Before a

The java.util.Random class has a public int nextInt() method that returns a randomly selected integer, but there is no innate method in that class to create a random number over

Many implementations still do not support exception handling very well. Therefore, you can implement, using global variables and passing a parameter to the constructor, instead. However, on implementations that support

Constructors have no return value (not even void). Therefore, you have to use alternative techniques of reporting errors during object’s construction. There are three common techniques of reporting such errors.

This function is useful for returning a portion of a string between two points in the string. You could, for example, extract a range name returned by Excel found between