Results for "Category: Databases/ Data Access/ DAO/ ADO"

Counts all valid curly brackets in a c++ source file. Tells where a file's brackets may be out of balance OR tells the user if the brackets are in balance.

A simple hospital system. Can add, update, retrieve and delete records like patient, ward, employee... I think it's helpful for those who want to know about how to update and delete record. Please give your comment so that I can improve on it.

Memory leakage is probably one of the most difficult programming problems to solve. This article tell you why, and how to do it.

Learn how to quickly attach a console to a window for instant output and feedback. Console apps trivialize the ability to output text data in a fast efficient manner. Displaying diagnostic data in a windowed application is not so trivial or straight forward. Have you ever wanted instantaneous feedback on a variable or state in your windowed program at run-time? One solution is to "attach" a console to your window. Through this attached console, your window can conveniently output information. The WinProg source below does just that. WinProg allocates a console window in WM_CREATE. It is through this console that WinProg can communicate what messages are being sent to it. The example below handles various messages in the window handler and then outputs them to the console. By retrieving a HANDLE from my CreateOutputConsole() function, you can then display whatever data you wish with a simple printf-like function - ConPrintf(). Just pass the HANDLE to the console, the size of the output buffer (big enough to accommodate the format string and the optional variables), the format string i.e.("Data: %d") etc...and the optional arguments (if any). Very similar to printf().

Just used for debugging querystring data. Creates an orderd list of field names and the values assigned to each one.

response.write is okay for simple debugging but can become intrusive and cause formating problems itself. This simple script will display your debuging in a pop up window.

Creating a user friendly error handler. This Friendly Error Handler pops up a VB liked dialog box to display error messages.

We recently run into a problem working with a web farm and replication. We where getting a error that the tech people were say it was code and us the code people was saying it was Server related. Well, First we know it only happens 3 out of 10, So it must be happening only on one or two servers. If it was code It would happen on all servers, right??? Well, Lets find out which servers get the error, but how? ServerVariables only returns BROWSER header information and we need machine specific data. A Clustered farm generally uses the same IP info on a load balancer. so how do we get machine specific data. Well, use WSH of course. Three Lines. Hope you enjoy it. This will not work on XP, because the disabled WSH by default. you can turn it on though. check MS Knowledge bases for instructions.

A small script mixes ASP and Javasript to make messages alert or for the debugage.

I saw the earier example of a global error handler written in C#, but needed it written in VB for my company. I translated the earlier work into my version in VB. It was suggested by a couple of people that I provide my VB version, so here it is. I just hope you find it useful. You can visit the C# version at: http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=948&lngWId=10 It was submitted by Joel Thoms on 2/5/2003. Thanks to all that asked me to post the VB version. Special thanks to Charles Richardson for helping me track down a bug. When you paste the code into the IDE, most of the formatting should return.

Have you ever needed to switch the file extension of a large set of files from .htm to .asp but you were worried about other web sites linking to the .htm files? You could create a new redirector .htm file for every file you switch to .asp. Or, you can just download and set up this solution! Just drop this file somewhere on the web server (remember the URL), and then configure the Custom Errors settings in IIS (by default pointing to 404b.htm) to point to this file's URL. That's it!

Ever wanted to configure ODBC Programmatically, from your code without any client configuration?. Here is how to do it. Please tell me what do you think ?! Please note that the code loads odbccp32.dll, that must be available at the Windows\System directory or on the search path, this DLL is installed by default with ODBC32.

Manipulate databases via Microsoft’s ActiveX ADO Libraries. A sample database has been included. Get schema and data information as well as load, store and save blob info to a file. Note: Works with Access 97/2000, Oracle 8i (drivers required), and Microsoft SQL Server 6.5 and 7.0. ---See Readme.txt!---

This article shows you how to put a checkbox in a dbgrid. If the column is of boolean type, then a checkbox will appear. Great Look and very easy;

If your scripts are running too slow, it may be that you have a function that's taking too long to run or that gets called too often. This function profiler watches the all of the function calls and records how much time is spent in each function. All of the documentation is included at the top of the source code.

The following function creates a user. You can execute it under any user you like. [email protected] (Dror Dotan A')

A short routine that backups the tables from an open Access database George Kinney

How do you avoid the "Invalid use of null" error when reading null values from a database?If you try to retrieve a null value (empty field) from a database, you will get the error: "Invalid use of Null". Here is one way to get around this problem: ..

How to copy a database table. This may require some tweaking.... "Bill Pearson"

An easy example of Searching for records in a database. I posted this code last year without an example so here it is.