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

This little application uses SQLDMO to script out objects in SQL Server 7.0 databases (tables, stored procedures, views, defaults, UDTs, full text indexes, etc.), as well as SQL Agent Jobs, Server logins, Operators, Alerts and Backup Devices. It even lets you save DTS packages as Structured storage file. Can be run in GUI mode or unattended/scheduled from the command-line. The code is a nice example of the use of SQLDMO objects, but even if the code doesn't interest you the application should be useful for SQL Server developers/DBAs who want to generate scripts of their DB objects in a more automated way then SQL Server EM lets you. ------------------------------------------------------------ A short text-file describing use is included. ------------------------------------------------------------ This is not drool-proof paper! Use at your own risk. Don't use on production servers unless your local DBA god has given you explicit permission. Dependencies are described in the included text file. ------------------------------------------------------------ A short (third-party) review of this tool and an executable-only download can be found at http://www.myitforum.com/articles/18/view.asp?id=3117 ------------------------------------------------------------ (Update 20020517 (v2.0.1): Added options to the /DB command-line switch to script out only the user or system databases) ------------------------------------------------------------ (Update 20020701 (v2.1): Server names, login names and authentication modes are now remembered between GUI sessions)

To remedy difficiencies in ADO, namely single criteria in the .FIND method. We encapsulated an ADODB.Recordset within a vb6 class module, and created four methods (FindFirst, FindLast, FindNext, FindPrevious) which allow for more that one criteria.

This will show new people to VB or Vb and Database's the basic's of using ADO with VB and access databases. *PLEASE VOTE*

This is to show new developers to Databases how to develop applications with VB and ADO. It is very well formated, step by step. And if you like it Please vote!

This is to show developers (mostly new ones) how to use XML / ADO technologies from within VB. I got the XML source code from a project on this site and put it to use! I hope that this will help someone out!

Store Files to Access-DB and restore them from DB to File and more...

I started this application in order to gather somewhere all the code I receive every day from Planet Source Code (actually I gather the URL’s). There are a lot of improvements in this version, plus some bug fixes. Some of these are: importing PSC e-mails directly from the net, importing PSC e-mails from Outlook, better error handling and trace routines. Check out readme.htm for more details. The database now contains e-mails from Dec 14 1999 until Jun 19 2000. I have change (again) the database, so be careful.

Example on how a template can drastically accelerate development time for a Database app. With this template, you just have to drop the text controls you want on the form, modify their tag property (see file _Notes.txt) and modify the SQL string that the form uses to get data and voilà. The code will take care of the MoveFirst, MovePrevious, NewRecord, MoveNext, MoveLast, SaveRecord, DeleteRecord, Undo, Requery, EditRecord and CloseForm. It will automatically enable/disable the controls based on what the user is doing and his location in the rescordset. There is even options (in the tag property) to set default values and field validation (alpha or numeric). Since it's the tag property that drives most of the features of the app, the code is very portable/reusable. The template only uses UNBOUND forms (i.e. there is NO Data Control) and is well commented.

This code creates and maintains a database of multiple users that may use your program. This supports user flags that YOU specify and define as well as a checkpoint system that YOU build! Documentation and sample projects included.

Connect to SQL Server Database ,and see all tables and columns in Treeview , Datagrid. All Stored Procedures ( Names and Texts of SP ) , Triggers ( Names and Texts of Triggers ) Views ( Names and Texts of Views ), Defaults ( Text and Name ) , Constraints ( Text and Name ) Primary Keys ( relationships ) , Foreign Key ( relationships ). Search Engine , Combo1 > TableName | Combo2 > Column Name , Criteria >> with each letter (or any other character ) you type , you will narrow the result. Direct Connection to Enterprise Manager ( with SQL Namespace object lib ) . You can perform full administration and implementation of SQL server and every Database ( if you have those rights ) : Create Trigger , Stored Procedure , Role , Rule , Default , User def. Type. Find out about Table Properties, Permissions , Dependencies,Delete Table. You can use EM interface for Generate Scripts , Manage Indexes . You can call EM interface for managing SQL server security, New Db user, and use EM's wizards for Import and Export DTS . Everything is commented and Constants are attached in two Word .doc files. With Query Builder you can perform very complex queries , Create tables , Update , Insert , Delete . It supports T-SQL commands , so you can perform (almost) everything as you can with Query Analyzer. Sample Queries , are attached as comments inside module. How to manipulate , easy , with more recodsets at the same time. Practically , this is simple console for administration and implementation SQL Server database ,with using full power of EM. I hope that You can find this app. useful . If so , vote. Thanks.

Since MS-Access doesn't support accent insensitive queries by itself (MS SQL Server does as far as I know), I had to create a function that would fix the problem. With this function, it is possible to turn any SQL query into an accent insensitive query. With a few little modifications, it works great with ASP too!

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!

Improved code production, index/relation handling and now supports Queries. Database Coder analyses an Access Database and produces the code to create a blank copy of it. Supports Tables, Fields, Indexes, Relations and Queries. Interested in comments. Updated 26 May 2000: Improved handling of default field values and minor bug fix.

The problem with Access databases is that when you delete records, the .MDB file doesn't shrink. It just grows and grows and grows – until someone either compacts it or you run out of disk space. This tip will show you how to compact a JET database up to 100 times!

Provides a wrapper around ADO future proofing your code and making accessing your database much easier. Ensures all your code is standard and uses the best data base access techniques. Also provides functions to convert a recordset to HTML or CSV format - handy for web pages as well as client/server applications. WOULD love your feedback, feel free to contact me directly or submit comments.

Hi,Family Address Book v3.0 - Final Update has been released on October 03, 2000. Please don't be fooled by the name, it is not just a simple address book - check it out and you will see. This time around I mostly use ADO instead of DAO and now the user is allowed to add or remove any category of their choice. DAO is only used to create the database, every thing else uses ADO. It has a lot of features such as Personal Contacts, Personal Internet Links, Search and Printing, Personal Reminders and also Sending Email using the vbSendmail component found on http://www.freevbcode.com. Please read the file readme.txt before you begin. All the source codes are included so you can compile the code for yourself. Please leave your comments or feedbacks And Remember to VOTE!!!. Last Updated : October 03, 2000. The ZIP File Contains a SELF-EXTRACTABLE FILE with the Source Code. If you hav any suggestions for the next version please let me know.

This is a family address book program created using VB6. Its main purpose is to store personal address book information for each member of a family. THIS IS AN UPDATED VERSION OF THE ONES THAT I CREATED SOME TIME AGO. THIS VERSION HAS ALOT MORE FEATURES SUCH AS PRINTINING / SEARCHING, Personal Internet Links ETC. IT ALSO USES THE LISTVIEW AND TRE VIEW CONTROL TO GIVE IT A BETTER INTERFACE. REQUIREMENTS Microsoft Windows Common Control 5.0(SP2) - COMCTL32.OCX Microsoft DAO 3.51 Object Library. Please write any question comment or suggestion. Tell me if you find any bugs. Note : Read the file readme.txt before you begin using it. If you are running the program for the first time you have to allow the program to Create the Database file. Filesize : 296KB. CHECK IT OUT!!!. Author : OmarSwan.

Hi, This is new version of a family address book that I released some time ago. Please don't be fooled by the name, it is not just a simple address book - check it out and you will see. This time around I mostly use ADO instead of DAO and now the user is allowed to add or remove any category of their choice. DAO is only used to create the database, every thing else uses ADO. It has a lot of features such as Personal Contacts, Personal Internet Links, Search and Printing, Personal Reminders and also Sending Email using the vbSendmail component found on http://www.freevbcode.com. Please read the file readme.txt before you begin. All the source codes are included so you can compile the code for yourself. Please leave your comments or feedbacks And Remember to VOTE!!!. Last Updated : October 03, 2000. The ZIP File Contains a SELF-EXTRACTABLE FILE with the Source Code. Note : the bugs with the vbsendmail component has been fixed. If you have any suggestions for the next version please let me know.

Hi,Family Address Book v3.0 - update 3 has been released on September 25,2000. Please don't be fooled by the name, it is not just a simple address book - check it out and you will see. This time around I mostly use ADO instead of DAO and now the user is allowed to add or remove any category of their choice. It has a lot of features such as Personal Contacts, Personal Internet Links, Search and Printing, Personal Reminders and also Sending Email using the vbSendmail component found on http://www.freevbcode.com (DLL File include in this ZIP FILE). Please read the file readme.txt before you begin. All the source codes are included so you can compile the code for yourself. Please leave your comments or feedbacks And Remember to VOTE!!!. Last Updated : September 25,2000. The ZIP File Contains a SELF-EXTRACTABLE FILE with the Source Code.

This is an application that allows you to connect to a database and view all the properties of a stored procedure and writes the VB and ASP code for you to run each particular sproc you are viewing. It is a pain to have to write wether a sproc parameter is inout or output and what type of parameter and what is the max length...etc. Just point to the sproc and all the code is created. There's even setting based on how you would like the code written for you.