Question: I want to extract/insert data by linking one Access table with a SQL server table through VB code. So far, I am not able to to it (using ADO

Question: I have two questions: 1. How do I make an EXE file without a interface (no form)? 2. How do I make that EXE file take arguments and how

Question: I am endeavoring to provide a graphical booking sheet metaphor (i.e. timeslots v. names) in an ActiveX Document. The third party grids I’ve tried, purchased and tested don’t allow

Question: I need to upgrade my Installshield, so I have been researching available products. Both Installshield and Wise (and others) seem to produce excellent installers. However now that the Windows

Question: What is the syntax for accessing a FoxPro 2.5 table using an ADO connectionstring? I want to be able use a DSN-less connection and access different tables depending on

Adding the Option Explicit line to an ASP file that is scripted in VB Script forces you to declare each of the variables that you use within your VB Script

While SQL Server uses 2049 as the cutoff year for interpreting dates, OLE Automation objects use the year 2030. To provide consistency in date values between SQL Server and client

In ASP, pairs are used to indicate a server-side script. It is a good idea to put this pair on the same line whenever possible. Because the ASP engine reads

Because the ASP engine reads and interprets every character in the file, adding comments in the ASP page increases the work of the IIS. Although the HTML page that is

It is a good idea to build a separate error-handling ASP page and call it from the code whenever it is required. Besides being a modular approach, it also improves

A common user scenario in a development environment is where the code typically opens a connection, executes a row or non-row returning command, processes results, and closes the connection. For

The File DSN usage should be avoided whenever possible. Instead, use System DSN; it is, on average, twice as fast. Also, File DSN is less secure because the database name,

SQL Trace can monitor, filter, and record all of the calls sent from the client applications to the server. It often reveals unexpected application overhead due to unnecessary calls to

RDO is an object interface that is closely tied to ODBC and is optimized for accessing SQL Server databases, especially from Visual Basic programs. It has little performance overhead on

ADO 2.0 includes few optimizations when it is marked as an Apartment model in the Registry. It determines the threading model from the Registry at DLL load time. The scaling

Question: How do I find out the top-five best sale items? I want the maximum five items to be listed. Answer: In version 7, SQL Server has conveniently provided the

Question: What is faster: two LIKE statements or one BETWEEN? ((MyData LIKE ‘02105_’) OR ((MyData LIKE ‘02106_)MyData BETWEEN ‘021050’ AND ‘021069’ Please advise. Answer: When trying to decide which is

You can access all variables directly by calling Request(variable) without the collection name. In this case, the Web server searches the collections in this order: QueryString Form Cookies ClientCertificate ServerVariables

Question: I have installed Windows 2000 on my laptop. I would like to create an emergency start disk akin to Windows 98. My current partition is FAT32. I created a

Question: Does Microsoft plan on implementing dual processor support in Windows “Millenium” and will it be based on NT? I’m just trying to decide whether I should upgrade my Win98

Question: I have two PCs at home which are used by various members of my family. I want to connect them as a small network. Can I do this by

Question: I need to schedule a batch file to automatically run at night. I have tried every variation of the “AT” command from a command line on the Windows NT

Question: I would like to know for containment (having objects as data member), what is meant by “if the inner class object’s constructor requires parameters, the initialization syntax must be

Question: I have 20 predefined strings that I want to put into an array of strings. Here is my idea: #include static std::string array[20]; If I do just this, I

Question: I am not sure if it is good when I use the assert macro in the following code: int sum(int number)// Precondition: number => 1// Postcondition: return sum from

‘ return a file path not longer than the number of character’ specified in the 2nd argument” If necessary, it replaces directory names with ellipsises” Author: Fred Block’ CuzWare Systems’

Private Type POINTAPI x As Long Y As LongEnd TypePrivate Declare Function SetPixel& Lib “gdi32” (ByVal hDC As Long, _ ByVal x As Long, ByVal Y As Long, ByVal crColor

‘ —————————————-‘ The Rotator class module” A class for printing rotated text to a ‘ Form, PictureBox or the Printer” Author: Timm Dickel ([email protected])” —————————————-‘ Usage:’ Dim rotTest As New

Private Declare Function OemKeyScan Lib “user32” (ByVal wOemChar As Integer) As _ LongPrivate Declare Function CharToOem Lib “user32” Alias “CharToOemA” (ByVal _ lpszSrc As String, ByVal lpszDst As String) As

Option Explicit’————————————————————————‘ This enum is used by both InstrWordEx and ReplaceWordEx” It uses a binary value to determine what separator characters are allowed’ bit 0 = allow spaces’ bit 1