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

The purpose of this class is make easy to generate ConnectionStrings to open ADO databases. Just setting some parameters you can easy open Access MDB with or without password, SQL server using username and password or Windows NT login, DBase III files, Excel Worksheets, Oracle and ODBC. Plus, with a minimum of modification you can easily add support to any other database. Of course that you always can hardcode your connections strings but this class will make this for you on a very friendly way. I'm updated with minor changed and translation of comments to english. Since it's my first submission to planet source code will be glad if I have some feedback positive or negative. I hope that this class can be so useful for you as it is for me. :)

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

This Application is used for quick access to an Oracle Database. The DataFetcher gives you power to Add, Remove, Search, View, Records at a click. DataFetcher also has it's own built in SQL*Net emulator in it! If you access an Oracle database frequently, then this is a must have Application. You must have Oracle Client installed on your machine to take advantage of the ORacle Object used in this code. Please Email for any questions or feedback. Thanks.

Address DataBase Shows VB and ADO

Backup and Compact a MS Access database file (*.mdb). Output a *.csv (Comma Delimited)File.

This shows how to two things, first how to pass variables to a stored procedure on a SQL server, second it shows how to handle multiple recordsets being returned from the stored procedure. This allows for a greater speed then trying to pass the entire SQL query to the server especially when you have several. Please Vote if you like it! :)

Allows users to select any DSN-less ODBC data source, or an MS Access database, to display the tables in it, and select a table, which is automatically loaded into an Excel spreadsheet, complete with column headings (field names). Based on project submitted by Ian Mitchell: http://www.planetsourcecode.com/xq/ASP/txtCodeId.25934/lngWId.1/qx/vb/scripts/ShowCode.htm I just changed it to use ADO instead of DAO, and DSN-Less ODBC data sources, instead of just MS Access. Slight modifications (error handling etc) on august 9, 2001

Finds SQL Servers on your LAN

Allows users to select any DSN-less ODBC data source, or an MS Access database, to display the tables in it, and select a table, which is automatically loaded into an Excel spreadsheet, complete with column headings (field names). Based on project submitted by Ian Mitchell: http://www.planetsourcecode.com/xq/ASP/txtCodeId.25934/lngWId.1/qx/vb/scripts/ShowCode.htm I just changed it to use ADO instead of DAO, and DSN-Less ODBC data sources, instead of just MS Access. Slight modifications (error handling etc) on august 9, 2001

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

Undocumented Trick for calling stored procedures in vb using ADO

This application will take any table from any database, and converts it into a HTML page, with nice looking tables. I have included a database with the entire 2000-2001 hockey season schedule as an example. The user can then view the schedule for any given date and convert it into a HTML page. Good idea if you're a hockey fan and want to update your page with the games scheduled for the day. Please remember to vote for me!

This application was written with the intent to serve as an example of how to use the MSChart control that is shipped with Visual Basic. I've found out, the hard way, that the documentation for Microsoft's chart control is poorly written, if not totally useless! This example might be silly but I garantee that it will help you understand how to manipulate and create graphs, specially for those who work with scientific data (like me).

A complete Database application. Based on ADO Database.It has some new mathematical features. I used here FLEX GRID. Moreover coold design. For more code Please Contact with GENERAL CORPORATION BANGLADESH didar911@yahoo.com tahmina911@yahoo.com

A Simple Love Calculator.. Just Fun.... For more code Please Contact with GENERAL CORPORATION BANGLADESH didar911@yahoo.com tahmina911@yahoo.com

I just put a bunch of controls on a form to play around with it and thought others might be interested in looking at it. Basically it allows you to conect to a mySQL database and ADD, EDIT, and DELETE records. You will need to create a table in mySQL called feedback with the following Fields. Field username Type varchar Size 50 Field emailaddress Type varchar size 50 Field subject Type varchar Size 50 Field message Type Text Requirements: This program requires that you have mySQL loaded somewhere you can connect to it. You must also have myODBC loaded on your machine. This program uses Windows ODBC 0to connect to your mySQL database. Written in VB6

Address Book XP is a contact management and address book organiser. This program currently supports user logins, reminders and some advanced uses of Access XP and 2000. This code was designed for Windows XP with Office XP or 2000. It hasn't been tested on other machines yet but hopefully you guys and girls will be able to help with that. There is a lot of work that needs to be done with this code such as a suitable search engine and some user managemet. If you feel you can add to my program, please be my guest, as long as you mention my name somewhere in there. Comments will be greatly appreciated. Tom

This code will let you repair and compact an Access 97 or 2000 (haven't tested on other versions yet) database. Using JRO, when you call the CompactDatabase function, it automatically repairs the database first. You must have a reference to Microsoft Jet And Replication Objects x.x Library in your project. Also, where I have a DoEvents in the code, there really should be some routine that checks to see when the file is actually deleted. I've tested this on databases that are about 5 megs in size with no problem. If anyone has any ideas (maybe a routine that checks to see when the file is unlocked or deleted), let me now. Thanks and enjoy!!

This code snippet will show you how you can convert an ADO recordset to a delimited text file in just a couple lines of code using the ADO GetString Method. You can easily export a recordset to a csv file using this method.

Everyone knows how time consuming and painful could be query code writing. This application is the MUST for all Database programmers who want to make their life a bit easier. The application allows generate and format chunks of code ready to be used in your application directly from Database. Start the Application and press Help button for further instructions.