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

This SW allows you to create complex SQL sentences, working with the Dictionary of the Data Base in use. This sentences can be saved to use it later. IMPORTANT: This SW was made in Spanish. As I drop the source code, change it to English is easy. Advances: -Works like the ISQL command. -You can select the number of records to be recalled, and the timeout. -The response will be separated by ASCII 9. Pass it to an Excel Worksheet to work with the results. -You can create the masks for: insert, select, update, delete of the tables. -You have a create table/index template. -The sentence can be converted to a string to pass it trough the clipboard onto your VB project. -You have an internal buffer, to work with two 'clipboards'.

Allow easy input and retrieval of images into an SQL database. Includes class file for easy implementation into your own program and a second project based on making the class into a dll for a IIS server. Will allow you to show pictures from you database on a webpage, input pictures into a database, remove the picture, retreive the picture plus more...

This code is an update of my previous submission. I put in code to convert database info to a comma delimited file, and to fill a listbox with data. I'm still working on it to do more things (SQL searches, etc.), and I'm going to do images,and things like that. I'm also going to improve the conversion to HTML to make it even better. Have fun with it!

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)

This code connects to a given SQL server and database and returns field info from a specified table. Handy if you need a quick printout of a table definition and you don't have time or patience to wait until EM has launched and connected to the server.

To show the ease of adding any Crystal Report to your VB application

This copies, renames or deletes stored procedures on an SQL server. Also the ability to copy procedures cross database, or even cross server. This thingy is way easier and faster then the import/export wizard.

CreateMDB will analyze and dump the sturture of an Access database into a BAS-module, you can include in your own project. From your own project you can now create an access database on the fly. This project is using ADO/ADOX v2.5 but will also work on v2.1. Updates in v1.0.13 : Minor bug regarding Nullable columns fixed. Updates in v1.0.12 : Minor bug regarding table description fixed, and found a solution regarding Nullable/Allow Zero lengh. Updates in v1.0.11 : More tableproperties added and a MRU list added to menu. Updates in v1.0.10 : Password dialog added, and some minor code updates. Updates in v1.0.9 : Support for Queries aka Views and Procedures and improved Errorhandling.

If you want to build an application that can work with several database engines, the main problem you will have to deal with is the different ways for specifying date expressions. This class will allow you to forget those differences. You can enter date strings in any format "dd/mm/yy", "mm/dd/yy", etc.. The class will validate the correctness of the date string and convert it into an expression you can use. Works for SQLServer, MySQL, Access, Informix and Oracle, and it's easy to add more engines.

A quick little app for querying an OLEDB / ODBC database

I think Flexgrid is Important in any Database Project. I made Readable / Writable Flexgrid for convinience to Add / Edit Data.

Rick's codebank is a simple application which, I believe, would be a good learning tool for beginners. When I was first starting out with VB it was nearly impossible to find a complete working project to learn from. Books and manuals talk all around a subject but never really show you how to do anything practical. They give you a few snippets of code, but never a project complete enough to give you the big picture.

This is a Sales and Inventory created in Visual Basic 5 for the fulfillment of the BSCS course in Asian College of Technology in Cebu City, Philippines. It is originally programmed by Jerson Chy(super programmer) and was re-designed by Ted Antonio(computer hacker). Hope to receive messages on this system..It is complete and very useful and it can even be sold to anyone who wants it...Happy selling this product

This code demonstrates how to use a connectionless recordset.

Example for data validation, database and data manipulation. If you like to see implementation for Search and Filter than take a look at ABCStores_02. Please vote.

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!

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.

Undocumented Trick for calling stored procedures in vb using ADO

Add / Remove User Using Access Database User: ADMIN / Password: admin / Level: Administrator

This program, show many statistic about your Data Base And it convert your data base to HTML and SQL format. Please, Vote for my source code...