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

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!

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!

Basically I took the most common database commands and wrapped them into an Active X DLL. Step 1 – Compile the DLL Step 2 – Open and run the “Test” program Hope this helps some of you newbies

This code will allow you to populate DBGrids and other bound data controls using a Data Control, SQL, and an ODBC DataBase.

The project has two forms. Both displays charts using mschart control for a data from access table. One form displays a chart(2D BAR) for the first record of the table. The second form displays a chart(2D BAR) for a set of records. 1.Both the charts displays legends. 2.Both the charts displays titles for X and Y axis. 3.Both the charts accepts a title to the chart at the desired location. 4.Both the charts displays data values at the desired location above the data points of each item. 5.Above all, the second chart(in the second form)displays bars in the charts dynamically as and when records are entered. i.e., if there are five records, five sets of data series will be automatically displayed. 6. Column labels and row labels are named in the code itself. 7. Filling colors to each data series is mentioned in the code. To summarize, a customized graphical representation of a set of data from an access table can be created by any user.

My third submission to Planet Source Code demonstrates how to use ADO and the Datagrid Control together. One neat feature of this app is the use of a horizontal scroll bar to move through records. I haven't thoroughly tested this app so don't be surprised if you find a couple bugs. If you're new to ADO or even a novice I'm sure you'll find something useful in this app. Please vote and give me some feedback!

Have you ever wanted data to be returned a page at a time? For example the data you requested returns 200 rows and you want to return them to the user 1 page at a time? Well now you can! PS!! Do not forget to rate this software. This results in more code!! Thanks.

This class will let you create ADO recordsets on the Fly - Without a database.Once I wrote a dll that had to return an ADO recordset, but as I had no connection to a database, I had to write this class and I felt like sharing it.This class will worl only under VB6

This is a veeeery simple code to make one autocomplete textbox that gets the first letters you typed and searches for the most similar word from a table and then completes the rest. No API Calls, No Classes, Only few lines of code in 2 events...Simply save it as a module (.bas) and add it to your project

This is an example of a DAO DATABASE CONNECTION PROGRAM Este es un ejemplo de un PROGRAMA DE CONECTIVIDAD A UN BASE DE DATOS POR DAO. This program contains an english part, for those that speak english. Este programa contiene un parte en español, para aquellos que hablan español.

Allows you to select a ascii file and import it into your database. Example provided!

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.

A simple project which can serve as a good example for use of crystal reports,DAO and dynamic control arrey.

Contains One Class clsCompareDB and a Demo project. Purpose: To compare two MS Access tables in different databases. The code alse demonstrates: ADO Technique to retrieve the Table names from an MS Access Database using the Connection Object OpenSchema Method. ADO Techniques for using a recordset to retrieve Column Name, DataType and Size. This class came as a result of MS Access being so easy to Change. Before I Joined Tier Technology training I was employed by the United States Navy (DP1). Our Managers decided that the MDB file should not be locked in any way. We were requested to train the users what they can do and what they shouldn't do. This gave no Guarantee though. We had several programs that required that several tables in different databases (IE MDB's for different years) be identical in every way. The procedures in question copied information of processed information by Column Index (Column position) or by using For Each (which also relied on the Column Position). Recently I needed this technique to do some debugging on an application I wrote for Tier Technology Training. So I dug this program up. Converted it to a Class and converted all DAO code to ADO code (Just to see if I could do this). Also this allowed this class to easily be converted for use with other databases (Other than MS Access). Author: Joel Isenstadt(iteachvb@aol.com). I am a Microsoft Certified Trainer for Visual Basic and am Currently Employed by Tier Technology Training (www.tiertraining.com)

Last code of mine was about quering tables and i used a little bit SQL In this small code i will try to explain SQLText string. How is it created and working? This series will continue under this name !Lets Create Database Applications-V?

Second code for managing database series. Querying with SQL and basic dictionary application. Enjoy it.

For beginner database programmers.

This code will save and retrieve bitmap graphic files from an OLE Object field inan Access 97 database. The same principle applies to earlier versions of Access/VB, but I haven't tested them. You'll need to use the appropriate DAO library. Let me know if you find a way to save other graphic formats.

This sample project will show you how to easily structure a query to a DataBase. The sample uses the NWND.MDB that ship by default with VB5 and 6 and demonstrates on a searchform how to search on a text from a textBox and use the different comparison operators like =,>,LIKE, etc. NOTE: This is for total newbies that have a hard time figuring this out. I myself had a hardtime in the doc to get an easy explanation on this. Cheers, and hope you enjoy.

since i couldn't find any code that let me connect to an sql data source i got to work and wrote one i think it's real easy and it lets you connect to the sql server while still using a data control