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

Finds SQL Servers on your LAN

I had a datagrid which I needed to output/print, rather than go through the whole printing process I decided to try export it. This code takes values in a datagrid - populated from an access bound datacontrol, and exports the datagrid to a csv file for input into excel.

Open a password protected MDB using DAO or Data control or OLE automation

How to load DAO objects on runtime, open database and select the DAO version from installed ones! Big news for VB5.0 & 6.0 DAO/JET Access97 database application makers: Capacity to select the DAO/JET engine version on runtime! This is my new invention how to load a "installed" version of DAO in runtime. Also this shows how to use DAO as runtime created object! Tested this in VB5.0 And VB 6.0 The coal why to develop this is solve a potential DAO 3.5X App break when a new install of Office 2000/2002 removes the registry entries of older DAO's. This is the number one end user tech support issue in DAO 3.5x referenced applications, even if they are carefully made! The problem might rise again more when people are installing Office 2002 after your app was there. There are two demos how to use this when the System.mdw file is in effect and second sample for unprotected databases. See file: Readthis.txt in the zip, The instructions and exceptional are explained there!

Demonstrates how to add, edit, delete records in a database. Uses ADO for connection. Treeview is included to view the records alphabetically. User has the option if he wants Automatic treeview refresh or manual (see option buttons in snapshot above). NOTE: This is for real beginners.

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.