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

Well This is my First App and my First Submit to PSC. Please take a look. I wanted to make an DataBase. To start simpel i made an Address book. I know there are a lot if this books here. But this one is diferent :). It has the function with Last File Opend, File Asosiation, (with open and print function) printing an DataReport and some other stuff. Im just an beginner with VB6. So comments and stuff are welcome. if ya wana Vote do so if not do not :). Greetz Black-Dextra

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 code will show you how to connect to a mySql Database using a DSN. It is very simple program but it shows the basics.

There has been a few questions on how to use VB to connect to a mySql database. This will show you how to connect without using a DSN. Most of the code is from a ADO Tutorial from this site. I just modified it to show how to connect to a mySql Database.

This is a program which will allow you to test a connection to most databases (SQL,Oracle etc...) and run any SQL query through. The connection to the database is handled using RDO although this could be quite esily changed to ADO if required. To test the connection you will need to enter the desired connection settings like server name, database name and password, DSN name if required etc..

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.

Create a CSV file (ie. for Excel(???)) based on a parsed ADO-Recordset - very cute :)

Some SQL Server actions: - create database - delete database - execute SQL command - execute SQL script

Updated ver 2.0. In a network environment, open a connection to a database, retrieve data, close the connection, work with the data, reopen the connection to communicate with the database again and do a batch update. This app shows you how. ADO data binding without Adodc control, database file creation, table creation, and combo box data listing and click to find a record is demonstrated. I appreciate your comments.

My code is a way to password protect a cd, so that only a certain user can access the setup program, it also allows the user to choose which one of the cd drives its in.

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.

translate from english to : 1)french . ( 3257 words ) 2)german . ( 9600 words ) 3)spanish. ( 7487 words ) 4)italian . ( 5160 words ) 5)portogue . ( 1375 words ) very simple, very fast , searching from a txt file.

Complete repository for all of your code. Include attachments, web links, shortcuts to other apps, organize on user-defined categories, searchable database, want to keep track of who gave you feedack? No problem. Copy and paste into your project, extract routines from existing projects. Share database entries with its Import/Export function. Help file included. If you use this one, you won't need another.

Creates ADO Access 2000 Database

This code is used to convert entire Excel Workbooks to Access Databases. Each Excell Worksheet in the Workbook becomes a new Table in the new Access Database. This codes has a problem processing more than one file at a time without stopping and restarting the program. It looks as if it is processing the file but it never actually imports the next file's Worksheets. Try it and you will see what I mean. Any HELP would be appreciated.

I catalogue this program like an utilitiy this utility generate a function that you can use inside your apps to create an Access 2000 Database With ADO Reviewed Version 1.1.0! Vote Please! Just copy and paste the code generated to new VB project and two references Microsoft ActiveX Data Objects 2.5 Library Microsoft ADO Ext. 2.5 for DDL an Security

By default Access string fields contain NULL values unless a string value (including a blank string like "") has been assigned. When you read these fields using recordsets into VB string variables, you get a runtime type-mismatch error. here is a nice code to get rid of that

This code takes an Access 2000 database and creates a VB 6 class. Greatly reduces the amount of time you spend creating classes based off of your databases!

This uses a Microsoft Hierarchical Flexgrid Control 6.0 which is an OCX control of your VB6. This demonstrates on how to relate different kinds of SQL using ADO. This provides tutorial to all. Don't forget to vote for it.

This little bit of code and table will help you manage tables with linked/split databases. Currently it only handles MDB or Access databases, but it would be a simple task to set it up to handle other types of tables. Basically, with this little code, you can Import a table from another DB, Export and then LINK to data from Current db to another db, or Link to external data in another Db all automatically just by setting the tables in the MOVETABLES table. I'm also going to add some features that will allow you to "upgrade" an external data table with a new Structure for those of you who make a new front end and also change the structure of the back end but you don't have access to the production version of the back end for whatever reason. Should be up sometime today.