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

a Crystal Report TTX example Shows how to create a report using TTX files, that is you dont need to specify a fixed database for your report. It'll be based on a simple TTX file. Using this you can pass an ADO recordset to the report at runtime. This method solves great deal of problems for many crystal programmers who will benefit from the simplicity of intergrating their report with VB. The report will execute even if the database location changes or renamed. Only you hav to do is change the connection from VB. [supports versions 8 & above.] Read the step by step tutorial and the official crystal guide to TTX available at http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr8_ttxado.pdf.asp if you like it,dont hesitate to vote :)

Allows you to programmatically create an ODBC connection to a MySQL database using the Registry API.

Recovers an Access 2000 password

Sample of using VB access data from a MySQL database (Create Table ,Add ,Edit ,Delete ,Search ,Show and Upload Picture) for beginner. Tester with mysql-4.0.18 for Win32 and MyODBC-3.51.06.exe ***MySQL Server configure (set to no password) username:root port:3306 database:test

This Program explains how to connect ORACLE with VB. How you retrieve table, view and stored procedure of ORACLE. Also featuring subclasssing a Textbox and customizing Progress Bar. If I make any mistake please send me the right one.

A solution for who does not want to use ADO/DAO or ODBC to have access its database in MySQL. With only one DLL you it has the power on all functionalities of the MySQL.

Hi, This project gives you an idea how to access ORACLE through VB and ADO. Project describe How you interacting with ORACLE Table, view, Stored Procedure, Type, Package, Package Body, Synonyms, Sequence etc. I developed an Active X Skin which is used throughout the project. If you want to test the Skin just put the controls (OFrmCtl, Edge Right, Edge Bottom, Edge Region) in a form and run the project. Please close the project from FORM CLOSE Button, otherwise IDE will be crashed. Please check all the menus and form. Now, I’m trying to develop this project in Visual Basic.NET. Resize the form From X Axis and Y axis. Check it out. Using of My developed Active X Skin and other components are strongly prohibited.

Add any BLOB you like to an Access database. For example, add pdfs, docs, mdbs,zips etc. All the different types are displayed in a tree view and you can view them by dragging into a frame and launching their respective application.

A simple PIN Generator with access database. Try it!!!!

[Updated 27/2/05] Make your recordset universal! Use this class to export ADO recordsets into the industrial standered [csv], commercial standered [html] and the power user standered [Excel]. This is an updated version of my previous work, now complete Events, Properties, Documentation and even more options! Fuly optimized and commented. All bugs fixed. A must have for any database devoloper and a must add to any code library!

This is a very usefull code, which i want to share it with u all, as i am working on an accounting package, this package closes it files at year end, and places it in backup database files. But the running year may need reports based on old data, i.e. the date range from the close file. Here is the SQL which can be used to get data form multiply database file in the fastes possible manner.

Hi! This is my first submision. This is a complete address book with picture likes school database to keeps track of your relatives, your friends and your classmates. Look and feel of WIndows XP regardless an operating system. download now! and don't forget to vote me .....

Enter your SQL server's information, and easily select a table (or all of them), and the application will print the Table's Field properties... Great for a quick-reference. ****BE SURE TO SET THE CONSTs IN MODULE1 TO REFLECT YOUR SERVER SETTINGS****

UPDATED!!!!! This usercontrol allows to get/put files in an Access 2000 mdb with one line of code!!! And I've forgot to mention it, if the file is a picture, it is autom. shown !!! Please leave me a comment !

This code will blaze through creating even the longest SQL statements(Jet supports up to 64K). This is an updated version of the SQLHelper post I made about six or so months ago, with various optimizations made since then. I have found it to be very useful, hopefully you can too! All code was written by me and is free for all purposes with the exception of cStringBuilder.cls, which is from vbaccelerator.com.

we have to save data in TABLE i wrote this utility to help beginers in vb for saving data without using the old way LIKE rs!st_no=val(me.text1.text)

This Helps in maintainign the booking, vechicles, contacts and other important aspects of any transport organisation.

this code is made for experimental purpose only. this program recovers the database password created in MS-ACCESS 97. THIS program is created for learning purpose only.

THE PURPOSE OF THIS PROGRAM IS TO CALCULATE INDUSTRIAL PAYROLL IN INDIAN SYSTEM INCLUDING ESI,EPF etc. YOU MUST HAVE LITTLE KNOWLEDGE OF ORACLE TO RUN THIS PROGRAM SUCCESSFULLY OR JUST FOLLOW THE INSTRUCTION AS GIVEN IN README.TXT FILE. !!!!PLEASE VOTE FOR ME.!!!! !!!!PLEASE VOTE FOR ME.!!!! !!!!PLEASE VOTE FOR ME.!!!!

Hello To All This module demonstrates how to perform common operations with ADO. This bas is essential if you want to do any database access with ADO. It shows how to perform common task as well as complex task using ADO. The notes on top of each function is self explanatory. The important feature is that it shows comparison with DAO (the older database access technology)and instructs how to perform similar task in ADO and which parameter to use. Please Rate it. Thanks and Enjoy..