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

I needed to query 2 password protected Access databases with a single SQL statement. The Microsoft web page http://support.microsoft.com/kb/113701 was helpful and gave me hope that it may be possible, but was not too clear. I use ADO with VB6 whereas the Microsoft example was for VB3 and the old ODBC. The Microsoft example worked almost straightaway for me if the databases had no password protection, it was the password protection that made it more difficult. Eventually after quite a bit of experimentation I cracked it and I thought I must share this with fellow coders in case they have the same requirement.

Graph designing is one of the most important feature of database programss. This code allows you to design graphs at runtime! It can also read from a database that you can open and display it graphically. It allows you to chose from a list of chart types including both 2d and 3d!,it allows to save graphs to bitmap files!, copy graph to clipboard,print the graph and lot's more.

For people who still use the DAO data control to acess MICROSOFT Access Databases , Here's what's been missing from the control , A way to access a database with a password

Using this code You can easily backup your sql database. There were some code here that used ADO for the backup purpose, here in my code i have used the SQLDMO object for all the sql transactions. Few code are taken from here and are upgraded with comments. Hope you all would like the work

A Library Management System using Microsoft SQL Server database in the backend. This project can also be implemented on Oracle by only changing the ADODB.ConnectionString property. Before working on the project you need to create the normalised tables, I've provided with the (DDL) SQL commands to adumbrate you with the structures for the tables used in the project. My Local Server name is BasuDip you'll need to modify this in the code. A screenshot of SQL Server Enterprise Manager is provided for reference. An updated code on Calculator is also included with the project. Hope you like it, your inspiration is solicited. Please vote and/or post your comments.

This tutorial will show you how to create a Visual Basic 6 project which will generate a report using Seagate Crystal Reports 8.5 Developer Edition. You will save the path of the image files in a MS Access database where it is protected by password. This project will use an external Crystal Report file and will be previewed using Crystal Viewer control.

Basically it is just a telephone numbers directory. You can search for people whose birthdays are fall inside a range of Date so that you could call/send SMS to them to wish them :-). Support Chinese name as other name. Use MS Access 2000 database with password protected. Auto compact database and update birthday when unloading the program. Auto resize MSFlexgrid column width when vertical scrollbar appeared. Use text file for simple program settings and write error log. Easy to use First, Previous, Next and Last records and string Find function. Easy to Add, Save, Edit/Update and Delete records using Hotkeys. Updated 12 October 2007: Leap year bug fixed and also show age in MSFlexgrid. Support empty birth date whether only Day or Month or Year is inserted or combination of 2 or 3 entries. Use Dateserial function to fix date problem. P/S: Searching birthday records stored inside a database is not easy. I hope this program could help someone who are looking for an idea to solve the problem.

Example shows how to connect to an Access database; browse, add, and delete records.

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****

An easy to use tool for SQL Server developers, that I developed in VB. Makes working with a large number of database objects a pleasant job. Features include fast searching of db objects, displaying all their details, reporting, automatic code generation, fast backup and restore, etc among other user friendly options. Complete source code is provided.

The purpouse of this module is to backup and restore mysql databases within a Visual Basic program. Please, don't vote for this one... It is a remake of http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=57138&lngWId=1 which inspires me. It has some improvement on his code: Basically, it take the table creation statement directly from the MySQL engine (so now it publish constrains and indexes correctly) and perfom only on insertion statement per table no matter the number of rows in the table. Also, it prevent MySQL from generating errors because of the constraing and block the tables before the insertion process. Also, it could allows the programmers to give feedback to the user about the process and, last but not least, it is IMHO a bit cleaner.

Database Operations Using Automatically Generated Class This is demo application that demonstrates powerful database functionality of database class automatically generated by CLASSter 2.0. Demo is for MS SQL Server, but CLASSter supports now MS Access, Sybase and Oracle server. Powerful features implemented by class - executing stored procedures, parameterized SQLs, multiple recordsets, batch execution, XML processing. The class code shows full implementation of these features

Demonstrate the use VB/ ADO to connect to a mySQL server/database / table. Show the records in MSHFlegrid. You can also user sql statement to customize recordset

A must for the SQL Server Developer. Combines what developers use with Enterprise Manager and Query Analyser in one package as well as other features including a simple but effective stored procedure debugger, perfect for the beginning SQL developer. Search utility very helpful also. Requires 1024x screen resolution. Can handle multiple selects (max 10) at a time. Be sure to read the readme.txt file for extra features.

Updates CD-ROM collection of the school i'm working on. this project uses a simple ADO and SQL commands. i am just a beginner in VB 6 and this is my first time handling ADO. This program also can print, try it.

This app uses ADO Data Control connection to a MS Access database. This will help in beginners to learn ADO connection useing ADODC. If still my codes are not clear for you, you can mail or contact me if you like. Vote for this app, thanks.

**Niro Professional Address Book** This is my second use of database. This is an address book with password protection, ect... I've worked hard so please vote! Watch up the screen shot!

Create SQL Insert scripts for Oracle, SQL Server (not 100% tested for SQL Server) to populate a table. This was a quick and dirty tool to allow me to provide data from a test database to a client who did not have a DBA. I would e-mail him data scripts and he ran the scripts. Great for populating databases. There is room for improvement and I have done about all that I want with this.

Keeps track of student record and payments. It also tracks student with old account and credit it to new account..

See the project for much details !