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

Hi folks, The purpose of this code is to scan a database's table and then export them into a number of text files. Simplely change the name of the ODBC. Cheers

if u have SQL running on NT this code help you in connecting with SQL server by passing some parameters Like Provider,User,Password etc.After established a successfull connection u can choose tables from the combobox and automatically all records will be shown in datagrid from selected table.

I have used SQL queries for Add, Modify, Delete, Update and Search in the databases. Everything neatly coded and commented for each line. A very good example for beginners, who needs to know the coding standards for connecting to the database using ADO. Comments appreciated.

This database comparison tool can compare 2 databases for differences. It can give you missing Tables, a script to create it... Check 2 tables for missing cols... Right now this works with only MS Access Databases... planning to include SQL Server and Oracle too.... This uses ADO objects... so mdac 2.5 is required on your machine. This is available in Microsoft's Website.

*** A1 Database Copmarison Tool.... Can compare 2 databases for missing Tables.... Can compare 2 Tables for columns and report the missing one's... Generate the Create Table Script... Run the generated script on Target database.... lot more to come.... Uses ADO DB Objects... Can connect to MS Access NOW... SQL Server , Oracle , Foxpro etc ... later...

Allows user to connect to database(Access or SQL Server), view schema(tables, fields, databases). It's main feature is to allow the user to point and click their sql queries using an updatable text file containing sql constants and a treeview of the actual database. Please let me know what you think.

SQL Server Viewer-Updated: Connect to SQL Server, Select Database, Tables, Views, Procedures, Parameters, Datatypes, execute queries, save queries, open queries. Very useful for working on MSDE Servers! Feel Free To Contact Me With Questions/Comments.

This code demonstrates a simple way to save Images (or any binary data for that matter) into a database... I would like to receive all kinds of comments and suggestions so, please give the same...

We recently run into a problem working with a web farm and replication. We where getting a error that the tech people were say it was code and us the code people was saying it was Server related. Well, First we know it only happens 3 out of 10, So it must be happening only on one or two servers. If it was code It would happen on all servers, right??? Well, Lets find out which servers get the error, but how? ServerVariables only returns BROWSER header information and we need machine specific data. A Clustered farm generally uses the same IP info on a load balancer. so how do we get machine specific data. Well, use WSH of course. Three Lines. Hope you enjoy it. This will not work on XP, because the disabled WSH by default. you can turn it on though. check MS Knowledge bases for instructions.

Make MSHFlexGrid Editable without help of any textbox or other control

As a lot of other people's reasons for posting source I post this because I couldn't find any help with the MS Data Environment. So after playing around with it I finally got it to do what I wanted it to. This Example is composed of basic ways to manipulate the Data environment. Add, Edit, Delete, Search, and pull report information. Use of ADO Transactions is also covered. Hope you enjoy it and learn something. The example uses the basic contact database concept. Please vote if this code is useful.

A complete database application. Sorry, but the program is in Portuguese(brazil), I'm uptade to English soon. It is Intermediate because the code is not commented. Please vote for me or leave a feedback!

Add Your data to Access Database/Edit/Delete/Add to the main DB.

This code will import textfiles into a MS Access database using different kind of seperators. A MUST SEE CODE! It works great and can be used for a lot of things!

This COM app was developed as a drop-in module to access databases across the corporate network in a variety of applications. I'm posting it here to get feedback - am i doing the right thing, could i change it in any way? make it better? all comments (constructive!!) appreciated!

A simply utility to search US postal database. You can search by city, state, areacode, zipcode, or county.

Planet source code cd visual basic jumbo 2002 Suppport this beautifull site by purchasing the full cd of visual basic 2002 jumbo this cd contain many great usefull source codes as well as many tutorials with graphics, for me i try this cd and purchase it beleive me its very beautifull work by lan ippolito Website: http://www.exhedra.com/Exhedra/ProductCatalog/Download/PSCCD_2002VB.aspx

SQL Server Enterprise Manger clone (demo only, not complete). This demo can demonstrate that how to use SQLDMO to create your own SQL Server Enterprise Manager which may perform every job the Enterprise Manager can do. In this demo, the following things are included Enumirating SQL servers on the network Logging on to any Selected Server using Windows Authentication or User Name and PWD Getting List of all Data Bases Getting List of all Tables Getting List of all Stored Procedures Getting List of all Users Getting List of all Views Getting List of all Roles Getting List of all Rules Getting List of all Defaults Getting List of all User Defined Functions Getting List of all User Defined Data Types Getting List of all Accessing properties of each object listed above like date creation, owner etc. Creating New Database Creating New Table Creating New Stored Procedure Deleting Database Creating Table Creating Backup of Database Restoring Backup More things can be done by understanding the way these things work. Not very hard, just simple It will work only if you have SQLDMO Library, If you have SQL Server installed, then it will work definatelly Sameers (theAngrycodeR)

Simple program that views a database, transacts custom SQL statements in SQL Server 2000. The SQL-VB connection established here is the foundation of many front-end applications in RDBMS nowadays. This project uses ADO programming techniques.

We had a client who 'accidently' copied one databse table into itself causing duplicate records. Unfortunately Access only allows 10 columns in its De Duplicate wizard and we had twenty! This code allows you to pick the database you want deduplicating, lists the tables and the fields within the table so that you can chose the 'key' fields to deduplicate on. Then it creates a table within the database which contains all of the deleted duplicates from the table you chose. It assumes that you don't mind which instance of a duplicate record you want to keep and it uses Jet 4.0. Also if you run the appliaction twice on the same table you will loose all of the deleted records from the first session (it dosent create a second instance of the deleted table). It also dosen't contain Error trapping as I use Aivostso's VB Watch addin that creates error trapping for you. However, leaving that in would add superflous code so I have omitted it here. This code was wriiten on the quick but it has ben used in anger with correct results. Any constructive comments will be appriciated.