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

vbs script code , using recursion , collections , this code convert xml files into sql recordsets. Usefull for search purpose , news management etc...

In this example I try to show you how to connect the ADO object to Excel file directy , without copy any data from the Excel file to DataBase first ( like MS access) , plesae vote for me :)

A nice student database with a very user-friendly environment. (an idea of Mr. R. A. Baltazar)

Este codigo facilita las conexiones mediante el ODBC creando un DSN segun el driver (class) que se este usando (Access, Dbase, Paradox y MySQL 3.51 en esta versión). Estupenda herramienta para los programadores de aplicaciones que usan bases de datos tales como Paradox o Dbase. Duda o sugerencia favor de ponerse en cotacto conmigo. With this code, u can connect to many databases formats using ODBC, like Paradox, Access, Dbase or MySQL, with a short numbers of lines and easy. Try it :-)

Automatically generate a function to create an Access 2000 Database With ADO. I catalogue this program like a utility. This utility generates a function that you can use inside your apps to create an Access 2000 Database With ADO Reviewed Verion 1.1.0!

Created for a barcode scanner. it stores the price, barcode and product name for an item. You can do a search for items by product name or by barcode. Also has an attempt at a registration enabled program which requires a valid username and password to register the program.

While searching for a way to repair a corrupted database file, that couldn't be fixed with just Repair and Compact, i found this undocumented option that prooved to repair and optimize my database file. Read the whole article. Any comments or feedback are welcomed.

I have received a lot of responses to my code posted earlier ( a generic object that assisted in returning recordsets from Oracle). Most of these questions have been in the domain of the stored procedures themselves. Hopefully this article and example stored procedures will help clarify.

This code demonstrates how to access a POSTGRES SQL database on a LINUX box via an ODBC connection. The demo ( using RDO ) shows you how to create a table, wipe a table, insert data, select data, modify data and write the modified contents back to the database.

This code allows for multiple record updates to be grouped into a single batch style transaction. You can then either committ changes to multiple records, or rollback the changes in the case of errors or conditions not being meet. This code is ideal for month-end processing, or in a situation where there is the possibility of errors being generated.

THIS CODE IS NOT THE SAME AS THE AUTO_COMPLETE FEATURES FOR VB5 LISTBOXES AND COMBOBOXES. This code is a class-module that enables VB6 DataCombo controls to function like MS Access combo-boxes. It adds an auto complete feature whereby when the user begins to type text in the combo it automatically searches through the list and completes the entry

if mdb_dsn_connection doesn't exist... then make it

To upload and retrieve ORACLE BLOB File using ADO Recordset. Never try with other than ORACLE database, but i think i can ...

To Provide a Recordset Template (view,execute,edit,Add new) To Provide a Database Connection Template (ORACLE and MS Access)

It allows the user to access Oracle Stored Procedures from VB, including getting ADO recordsets back

To show how to get table name and query name using ADO . This code also shows the connectivity with EXCEL

Shows how to use INI files as highly flexible,huge databases!!

Cant remember the important things in your busy schedule? Then have this code (Using MS Access Database). This code reminds you on the date and time set by you by a popup window which will be on top of all running applications. Prpoerly commented. You can reschedule the reminders. Can mark them as pending a or done. At start up checks all the reminders which are not shown previously bcoz this application was not running at that time.when you close it (by X) then it will be in the system tray.Dont forget to vote for me.

This is a Report program desiged for an export corporation. It Uses ADO. You can add, edit, sort, search and print(with printpreview). Additionly you can set autobackup for defined times and can add logon feature, systemtray icon and more...

These Functions will allow you to determine WHO is logged on to the Acces Database as well as HOW MANY users are logged-in. As always the code is FREE, if you want support can consult me in my professional capacity. ENJOY