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

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

Fill a FlexGrid without ADODC control and without AddItem of FlexGrid Method, with a fasted time about 230% more... with Recordset.GetString() and FlexGrid.Clip methods

A simple method to convert an ADO set to XML and reverse. Extreemly simple!

This article explains how to, using pure code, without having to reference Excel, Access, dBase libraries, etc, export data from one format to another.

Creates an UDL-File (Universal Data Link) from an existing ADO-ConnectionString. Unfortunately the DataLinks-Object in the "Microsoft OLE DB Service Component 1.0 Type Library" provides some prompting dialogs to choose an ADO-Connection, but a save method to get an UDL-file is missing. So I coded this. Note that this wasn't as easy as it looks now, cause an UDL-file is no normal INI-file, although it seems to be one. The first thing is, that it must be saved in unicode. The second and very astonishing thing is, that the second line, which seems to be a missable comment, is very important and must be exactly as it is. Otherwise the UDL-file wont work! Comments and votes are welcome.

to all programmer out there who is like me...download code and don't know how to manage it.. :) this simple program shows and help us (maybe..)to manage code/program/module...u can modified it as u like...i'm new in this area..i'll be glad to have some comment(s) from u to help my programming skills...c ya..

If you're ever wondering what's contained in a recordset you currently have open, here's a quick and dirty way to dump all the data you could want to the Immediate window, which you can view there, or copy and paste into a notepad document or other textfile for printing, etc. I like to keep this somewhere I can quickly copy and paste it into any module or routine that uses a recordset in case I lose track of which field is which. (I've only tried this with VB 6.0 and AO 2.6, but I imagine it would work with other versions.) --Brian Battles WS1O Middletown, CT USA

This application can Extract the existing DAta structure of any SQL Server database and it can be saved in HTML table format.Tables structure of selective tables can be Printed.Table can be taken copy

with this procedure we can handle the queries or stored procedures which returns multiple recordsets - through ADO's

This function retrieves data from MSHFlex Grid and prints it directly to the printer. It determines whether the information should be printed landscape or portrait.

Have you ever needed to view a database on a computer without MS Access? Here's an alternative. It uses ADO 2.1 to open, view & edit MS Access, SQL server, DSN and Oracle databases. There are also a few features to let you add, rename and delete tables as well as purge based on a Date/Time field. Clearly not a replacement for MS Access, but you can distribute it to help troubleshoot. Automatically registers itself as the default database viewer for .mdb files on systems without a default already set. Otherwise, it becomes a second option when right-clicking. Its Biggest advantage is its all ADO. No DAO at all. Now you're able to modify older versions of Access databases when Access itself requires a conversion!! I recommend distributing MDAC 2.5 even if you have a 2.1 application. Microsoft seems to have fixed some of the install problems with the MDAC 2.1. Please Note that you MUST HAVE the Oracle client installed on your PC to use the Oracle connection!!http://www.microsoft.com/data/download.htm ** Updated 3/21/2000 **Added Password support for Access databases.Please vote!

Well, I was trying to make a address book and I couldent think on an interface. So I thought for like 1 hour and I made one and I decided for thoes people out their that want to make an address book, that they could you my interface! If you use this please give me credit and you can re-arranfge it, and do aything to it!

This will allow you to get BMPs (only Bitmaps) from an Access database using ADO. Officially, Microsoft says this about it in MSDN:INFO: Issues Migrating from DAO/Jet to ADO/Jet ID: Q225048 OLE Container Control Many databases, including the SQL Server 7 Northwind database, contain pictures and other objects saved by Microsoft Access. In Visual Basic, you can see the pictures by binding the OLE Container control to the DAO Data control. However, the OLE Container control is not compatible with the ADO Data control and there is no way to access these pictures and display them using ADO. The OLE Container control cannot be used unbound because GetChunk does not retrieve the data in a format compatible with the ReadFromFile method. Please Vote!