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

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.

A must for Help Desk and Customer Support. A fully functionnal knowledgebase where you can insert a problem and a solution will appear based on the words you have entered!

Ever wanted to find a special value in a database, but don't know in which table or field it's in. This tool helps you scan for a value in a database with 1 ore more tables in it. Only works on SQL Server. This tool can match exact or "LIKE" querys and has some other features. If you like it, improve it! :) (and tell me about it)

READ THIS° : Do you have so many Source Codes and don't know how to arrange them?. Well, here is the answer to all your problems. The Ultimate Source Code Storage Database utility has come atlast. The program contains whole new features where users can EASILY STORE: CODE NAMES, AUTHOR NAMES, DESRIPTION( Read Me's), PLATFORM, PROJECT LOCATIONS, ZIP FILE LOCATIONS (Backup Locations), RATINGS, DOWNLOAD LOCATIONS, DOWNLOAD DATES, CATEGORIES,COMMENTS and whole lot more. The Code contains BUILT IN advanced SEARCH PROGRAM where users can easily search their code in the Database. Have a look at SCREENSHOT. Users don't have to worry about Zip files that come in unique names, just mention the Zip Location of the code in this program and program will do the rest- by storing the Zip file location in the database. You can EASILY OPEN- Projects, Zip Files, and Screenshots. In the same way you can store author name, readme's, Voting locations, download dates, comments, personal ratings and lotZ more. This program uses a eye catching Visual Styles with Windows Xp like interface. If you want to Print- then this programs ADVANCED PRINT facilty is just for you. This code is optimised for Planet source code users but you can twist it the way you want. This code also contains Easy to Use ADD ENTRY FORM where users can easily add their code and their details to the DATABASE. You will never know How this utility may come in handy for you, until you download the Code. Perviously i was using this utility for my personal use and this time its for you with a bunch of New ADVANCED FEATURES. Please DON'T FORGET TO VOTE FOR ME. Add this code to the Database first.°!!!°

This project will show you how to utlize MS Access as your report generator. If you are tired of designing your report using other third party report generators and if you want to create dynamic reports without making major revisions of your app, then perhaps this project can help you. Be sure to reference the MS DAO library, MS ADO Library and MS Access Object library. If you have comments, email me.If you like it, then vote. Use the following: Username: BetaTester Password: BetaTester

This tutorial is written so that even the beginner will have no problem. It is designed for the absolute beginner. It utilizes the AdoDC and the DataGrid controls. The tutorial is a step by step program to create a simple "Contacts" database with Name, Address, Email and Phone #. This is a VERY easy to follow tutorial with the sample project.

Planet source code cd visual basic jumbo 2002 Suppport this beautifull site by purchasing the full cd of visual basic 2002 jumbo this cd contain many great usefull source codes as well as many tutorials with graphics, for me i try this cd and purchase it beleive me its very beautifull work by lan ippolito Website: http://www.exhedra.com/Exhedra/ProductCatalog/Download/PSCCD_2002VB.aspx

Explains how to hook a 'lookup' combobox to a data field at runtime. Doesn't use the ADO control - uses pure recordset manipulation. Illustrates what the differences are between 'DataSource' 'RowSource', 'BoundColumn', 'DataField', and 'ListField'. M$ documentation is truly bad at explaining this topic.