Results for "Category: Databases/ Data Access/ DAO/ ADO"
Confused how to make a database programming using ADO Code? This project shows you how to make a complete ADO Code database programming with: navigation (move first, move next, move previous, move last), add, update, delete, cancel, refresh, find first, find next, filter, unfilter, sort (ascending-descending), bookmark, and adjust datagrid's column. This project uses reference "Microsoft ActiveX Data Objects 2.0 Library" and database Microsoft Access 97. I made this project by using "VB Application Wizard" in Visual Basic's Project Type Dialog Box and I choose "ADO Code" and "Master-Detail" through "Data Access From". Then I modified the code by adding find, filter, sort, and bookmark procedure - each of them in one form. I made findfirst and findnext procedure because there is no findfirst and findnext in ADO. I added "Match whole word only" checkbox in Find form, also in filter procedure/form. I made "Bookmark" procedure, too. I didn't use ADO's bookmark property. The first time I posted this code, I used Indonesia language for comments in source code. Now I have translated them to English, include Label, Field Name, Help, etc. I hope this will help you to understand the code. Any comments and votes would be appreciated. Enjoy!!!
Although ADO specification does not provide objects to compact Microsoft Access databases, this capability can be achieved by using the ADO extension: Microsoft Jet OLE DB Provider and Replication Objects (JRO). This capability was implemented for the first time in the JET OLE DB Provider version 4.0 (Msjetoledb40.dll) and JRO version 2.1 (Msjro.dll). These DLL files are available after the install of MDAC 2.1. You can download the latest version of MDAC from the following Web site:
This piece of code shows how to connect to mySQL database using Visual Basic, myODBC 3.51 and DAO 3.5. It is very simple for understanding and code is commented. If you think that code is very helpful, you can vote for me.
This add-in brings up the Data Link Properties Dialog box. From there you pick the provider and the database along with other important information. You then have to option to test the connection. When you click the Ok button the connection string is placed on clipboard ready to be pasted into you code.
This project is a database opener which basically opens any MSAccess database w/o knowing the password. The main purpose of the program is to open a passworded database, and retrieve the password. This is helpful for databases with forgoten passwords. The program requires a "Character Set"- this is where the program retrieves several combinations for unlocking the password. if you suspect the database to include numbers and special characters simply include them in the Character Set. the program runs perfectly on high-end machines, but using it on lower-end machines do take awhile. please feel free to comment & vote! :) special thanks to §e7eN for the bruteforce class! =)
ActiveX Data Object Easy Data Control Ocx V1.0.3 is a more Graphical and Easy ADO designed for Total Beginners,but it also can be used by anyone,Forget Newbies Database errors,and hard to understand code,this New Ado works like the Regular Ado but is more easy to use if you don't have any Databases experience..This Ado uses a Smart Property Page that lets you select from your *.MDB *.XLS *.TXT Databases and All this More Quickly..Now you can use Tables in Text Files,and of course Excel and Access Databases.. This Proyect includes a Tutorial for a more easy undestanding... I used NWIND.MDB For Access Examples so check your NWIND location I used: C:\Program Files\Microsoft Visual Studio\VB98 enjoy!!!!! PLEASE REMEMBER TO VOTE!!!!! Updated a Free OCX..only compiled code!! but still more to come (this is yust part of the actual ADOEDC PRO OCX)this free version can have some bugs and some features are not ready.. but is still a great utility for Visual Basic Programers. The ADOEDC Control is an important developer tool in Visual Basic and it's worth getting a closer look at it here. -------------------------------------------------- http://geocities.com/marioflores_code -------------------------------------------------- or download zip from: http://geocities.com/marioflores_code/adoedc.zip ;)
UPDATED! Demonstrating the inner workings of the POP3 connectors and SMTP connectors interoperating in separate ActiveX controls, the structure of the protocols are specified from the RFC sections. The SMTP protocol saves all messages into a Microsoft Access Database (MDB) using ADO 2.1, and users can change the code to link a SQL Server database easily enough if need to, which would be handy, as you can publish SQL Servers over the internet for remote access, or replication the emails between to different locations. But for now I have it set up for a centralised database which can be shared for to instances of this mail server for load balancing and network traffic. There are two types of SMTP connectors SMTP Direct and SMTP Relay both are demonstrated and commented. This is the first release of my mail server and would appreciate any bug findings, I have programmed this in my C:\Exchange directory and no problems found, network drives will cause performance issues and SMTP Spooling errors. This is a grouped project so remember to open the ExchangeStore.vbg file as it will open the custom controls first. To get started create a new account in Outlook 2000/Express or any other email client, point the smtp/pop connections to the your development computer and username=chris password=password. Also please VOTE.
This utility code...will help u how to create PROCEDURE, TABLE in ORACLE and also how to execute procedure in ORACLE. Note : this utility uses SCOTT for login so u must have rights to work with SCOTT otherwise this utility will won't work.
An easy to use tool for SQL Server developers, that I developed in VB. Makes working with a large number of database objects a pleasant job. Features include fast searching of db objects, displaying all their details, reporting, automatic code generation, fast backup and restore, etc among other user friendly options. Complete source code is provided.
SQL Writer Pro (using ADO) is a Universal Data Access (UDA) tool. It lets you query OLE DB data sources, author SQL scripts and queries, return query results to a grid, retrieve provider properties, execute multiple SQL scripts or stored procedures simultaneously, and more! This is a work in progress. I ran out of time before being able to complete this application. If you can improve upon it or complete it, please let me know. Otherwise, enjoy!
To show how to use ADO Data Control
The code demonstrate the use of ADOX (Microsoft ActiveX Data Objects Extensions for Data Definition Language and Security). This will be a series of sample codes that will demonstrate the use of ADOX. For this sample the code will access an mdb file and display its tables and related fields in the listbox. Also supports password protected mdb file.
Grabs UK TV Listings and parses it into and XML format. Similar to the soundforge xmltv project. Command line driven. Read the readme file. Also I'm a lazy sod, so very little comments. And comments are welcome.
When you display data from a database to a DataGrid, you will see that DataGrid's columns width cannot adjust to the longest data in the field. I made one procedure that can fix the problem. This procedure will adjust DataGrids column width based on longest field in underlying source. Enjoy!!!
Confused how to make a database programming using ADO Code? This project shows you how to make a complete ADO Code database programming with: navigation (move first, move next, move previous, move last), add, update, delete, cancel, refresh, find first, find next, filter, unfilter, sort (ascending-descending), bookmark, and adjust datagrid's column. This project uses reference "Microsoft ActiveX Data Objects 2.0 Library" and database Microsoft Access 97. I made this project by using "VB Application Wizard" in Visual Basic's Project Type Dialog Box and I choose "ADO Code" and "Master-Detail" through "Data Access From". Then I modified the code by adding find, filter, sort, and bookmark procedure - each of them in one form. The comments in the source code using Indonesia language (because I am an Indonesia ;) ). Sorry for this. May be I will translate them to English some other time. I hope you understand the code because the name of procedure using English language, for example: cmdAdd_Click, cmdUpdate_Click, cmdDelete_Click, etc. Enjoy the code! Any comments and votes would be appreciated.
On browsing the forum and the net, I see a lot of questions relating to data integrity in a VB form. It's an issue I come up against a lot myself - so here, I have attempted to address some of the issues raised and provide a possible solution. The form is designed around the DAO data reference. It is an attempt to make a bullet proof data form in that . . If the user changes the value in a field and then tries to move to another record, or add a new record, or close the form or whatever . . then the form will pick up the changes and ask if the user wants to save.
Store and extract MS Word Documents (or such other file) in binary mode into a DataBase.
This is a program that sort the grid control without sql.
Connecting to MySQL 4.0.2 using myODBC 3.5 & ADO 2.7 without creating DSN in ODBC DataSources in ControlPanel. In this sample is a code for adding records, showing records in listview removing selected records from list, searching records (you can search for records by name or by surname or both. Inside code is description what you must do before running code.
Listview1 will list all records from a given Data Source SQL qry. It sorts by Date, Number, text etc. It has a very nice find facility and a sql builder. Output data to CSV, XLS, Clipboard, HTML, PDF, Screen. (ActiveReports 2.0Pro) is needed