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

This project demonstrates populating a Microsoft Access database dynamically into a treeview and listview control, by using loops and arrays. Also added the common Add/Edit/Update functions into the database for those who wish to learn the basics functions of ADO. Another purpose of designing the code the way I have with objects is so you can reuse the listview and treeview modules just in case you wanted to load the same information into another treeview or listview control, with out adding extra code. Once any database is loaded you can also edit the values in the treeview with the label edit functions. (F2). anyway there are lots of code samples available in this project. if you like this code please vote. Thanks.

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.

Updated!! Ado project now supports multi-user connections and is much more stable than ever before. if you have more than one connection open, the server now refreshes all clients connected when a new job has been created or modified. Server keeps a real time status of active and disconnected users, great great over vpn, or internet connection. ADO Project allows remote users to access a database over a network/dialup connection. You will be able to access the database fully, with Add/Delete, Read/Write access. Also i have inbedded authentication against the database via the winsock control. This program is simply for basic job tracking, from inhouse, and for remote access areas. Bascially how this works, It sends the server a few commands/strings, and the server generates the sql statement and sends back the results, to the client winsock application, it then recieves the information and displays it out into a listview control with columns

This code is the beginning of a library circulation program. Two of my freinds and I woked on this. It doesn;t have many of the feature implemented, but Take a look, show different was of accessing databases. Login:David Smith Pass:98022 The Use Administration >Books to get barcode numbers And use Administration > Patrons to get patron Numbers Then Use Signout. Try double clicking on a book Please send any comments to the feedback or daveismith@hotmail.com

zwo routines for easily retrieving Table- and Fieldnames of MS-Access-Databases

This code will teach a user how to save their data and also how to retrieve it. Very easy to understand if you read the ' comments. :) Enjoy!

Just used for debugging querystring data. Creates an orderd list of field names and the values assigned to each one.

Connect to text file(s) and perform advanced queries using ADO. You can even return recordsets on CSV file without a header.

This Module allows easy connection to SQL Server 2000, ODBC, Access 97 and Access 2000 databases. The code is well commented, so may also help a beginner to get started with DB programming. If you use it, please rate it, and i look forward to any feedback you might have.

This Is a great module, which loads data from a recordset into a listview without all the usual hastle. If you like it please rate it and vote for me. Thanks

A simple, and easy to understand code, whick lists the tables etc. in a microsoft access database. The code uses ADO, so it is handy for beginners to follow while learning. Sorry forgot to comment it.

A quick little app for querying an OLEDB / ODBC database

This sample project shows how to scan a network for all domains, then list either all servers on the domain or only the SQL servers on the domain. It uses the NetEnumServers API call and a NetEnumDomains function found in the NIMM.bas module which was originally written and posted here by *Patrick Herbst*. The NIMM.bas module has a TON of features for network management. FANTASTIC JOB Patrick! Thanks also goes out to Michael Monaghan for directing me to the posting that LED me to this solution. Even if this sample is the greatest thing since sliced bread to you (doubt it), please do not vote for this module, 99 percent of the REAL CODE was not written by me. I used alot of ideas from alot of authors (including Microsoft's technical articles).

Store name and address information with associated call logging. I use it to track calls to job agencies while I'm looking for contracts.

3-TIER Test project illustrating high performance Data Access for SQL Server using ADO command objects and Stored Procedures in a 3-TIER ENVIRONMENT USING VB CLASSES for Insert, Update, Delete and Select. This project runs on Northwind db.

This VB test project demonstrates how to insert, delete, update and select from a Microsoft Access database using parameterized stored queries and ADO command objects. .mdb file in included.

***UPDATED 02/19/2003*** This is a quick and simple documentor for SQL Server. It returns a list of registered Servers in your EM. You choose the one to connect to, then you choose the database - once connected it will return a list of Databases - then you choose what you want to document and how you want it returned in an Excel Spreadsheet. It's well documented code so you should be able to make changes without much pokin around.

UPDATED - 12/07/01!!! This kind of goes against my article earlier this this week. In a new environment I was able to do two things. I was able to query a list of DTS Packages from my Server and then execute a chosen Package remotely. This can be easily modified to accept collections and remotely fire multiple Packages on a timer (which is what I'm using it for). If you downloaded the zip file earlier you may want to download it again since I've updated it and revised some of the references. NOTE: If you use a DSN connection it must be pointed at the MSDB database to get the list of DTS Packages, not the Database you are trying to run the DTS Packages Against.

Have you ever wondered how to remotely fire a DTS Package in SQL Server 7 from a Visual Basic Application? Me too... So through rigorous research and aggrevation I figured out a very simple way to do this.

visual user interface to construct a query