Heres another good example of using a winsock control to access a ADO database over a network/dialup connection. This project shows how to Add/Delete, Read/Write access with ease. Also I have inbedded authentication against the database via the winsock control. This project gives you the functionally to store and retrieve data remotely and keep track off multi-users online with up to date online and offline status's, into a treeview control. you can create personal folders and use drag drop features to move messages around (remotely). Also allows users to compress the database to keep hundreds of message clean and tidy. also this code shows how to export messages and send internal messages to the server to be export by email, by a internet dialup connection. Now works with Windows NT / Windows 2000. email me if it doesnt work. chris@hatton.com
Please Vote....
'**************************************
'Windows API/Global Declarations for :Access ADO/DAO Database via Winsock Control
'**************************************
heaps
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
Re-scan downloaded files using your personal virus checker before using it.
NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
Scan the source code with Minnow's Project Scanner
If you don't have a virus scanner, you can get one at many places on the net
including:McAfee.com
Terms of Agreement:
By using this code, you agree to the following terms...
You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
You may link to this code from another website, but ONLY if it is not wrapped in a frame.
You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
Excellent Job Chris, Very well done neat, and professional looking. All programmers on the BBS need to definatly check this project out!!! (If this comment was disrespectful, please report it.)
I get some errors trying to run the server. Im running VS 6.0 VB full install and get. Line 27: Class MSComctlLib.ImageList of control ImageList1 was not a loaded control class. Line 53: Class RichTextLib.RichTextBox of control RichTextBox1 was not a loaded control class. Line 75: Class MSComctlLib.ListView of control LVMsgs was not a loaded control class.
Can someone help? (If this comment was disrespectful, please report it.)
I am having getting an error while running the server which says "cn As ADODB.Connection" cant find project or library. Can some one help me. thanks in advance redards tariq (If this comment was disrespectful, please report it.)
Hi Tariq You need to download microsoft data access components 2.5 from www.microsoft.com/data or try referencing it with 2.0 / 2.1 that may work. (If this comment was disrespectful, please report it.)
Hello, This is just great ! I've never seen such a complete full working progessional prog here ! I've posted aslo some code on PSC , but you're code & GUI is very very nice! You deserve more than 5 GLOBES !!
Greetings,
If you are interrested to view data between sockets.. for looking , knowing new protocols by own written applications, i've posted here ! called TCP-IP Datalook V1.3
Greetings,
Hopely i can see some more stuff of you in the future !
Peter Verburgh. (If this comment was disrespectful, please report it.)
Great job. One thing missing is encryption of the password field. But all in all it is very neat and works great!!!!! (If this comment was disrespectful, please report it.)
Chris, i was just wondering if you can add some features in this project like sending a file attachement to your messenger buddy...nevertheless this code really rocks! Excellent job man! (If this comment was disrespectful, please report it.)
Oh Man !@!! This is AWESOME !!!! Hei Buddy you are brilliant and you have done it again .... Another 5 from me (If this comment was disrespectful, please report it.)
9/23/2002 6:25:45 PM:
Now that is a well interesting project...just a couple of "On Error Resume Next" thrown in and this code runs on Win2k without probs. A five and thumbs up from me for a great idea & a smart way of getting there! (If this comment was disrespectful, please report it.)
11/3/2002 6:11:56 PM:
Nice Work. 5 Globes! Great UI...
(If this comment was disrespectful, please report it.)
12/19/2002 2:06:16 AM:
Very nice.... excellent
I like your code very much even though your approach is quite complecated, but anyway its working well.
I have a few questions to your sir.
1. Is your code no problem in more than user log-in at the same time?
2. If Pictures are store in database, can access them via winsock?
Sorry for if it bothers you... I'm just interested coz i'm currently developing a program that i want that this feature will be available.
Thank you...
God bless...
Cris
(If this comment was disrespectful, please report it.)
1/31/2003 9:14:39 AM:
Nice piece of work dude !!! (If this comment was disrespectful, please report it.)
5/7/2003 1:01:09 PM:
superb man!! neatest program i hav seen in recent times..cool!! keep ur good work & do provide us with more jewels like this. thank u!!!.
(If this comment was disrespectful, please report it.)
Chris Hatton, I can't say anything... just...: GREAT, GREAT, and, GREAT CODE! I want to give you 10 globes if any, alas... there are only 5 globes here, so I give you all of them. Keep up good work! (If this comment was disrespectful, please report it.)
(If this comment was disrespectful, please report it.)
12/27/2003 1:21:19 AM:
good example (If this comment was disrespectful, please report it.)
1/31/2004 11:09:51 AM:
Great project, thanks for your post. (If this comment was disrespectful, please report it.)
10/18/2004 11:31:43 AM:
At last i found out a great code Its one of the hotest code i ever seen. well great work. (If this comment was disrespectful, please report it.)
1/19/2005 2:18:38 PM:
I don't have any criticism, Instead of it I praise your work. May get success in life. I need propoer guidance of viusal bacis. I am want to be the perfect database programmner in Visual Basic. So that I can full the need of the any individual or any organization. (If this comment was disrespectful, please report it.)
when i download your program, then i run it in vb,at first it was ok and running very well but when i stop it and then run again, it has an error or bug.The message says when i run the office messenger "Invalid operation at current state".Why is it so?Can you help me chris? when i first run the office server and office messenger, it run very well but then the next time i run it, the office messenger has now an error.The office server has no problem,my only problem is the office messenger.Can you help me Chris??? Please reply as soon as possible because i like ur program and its really really great program i've ever seen!!!! (If this comment was disrespectful, please report it.)
i download your program chris and its really really great.I've never seen like this,it's so wonderful and really great to use.But can u help me Chris because when i run the office messenger and office server at first,it was ok and running very well.But the next time i run it again, it has now a bug or an error.The office server has no problem when i run it but the office messenger has an error that says "Invalid operation at current state".Why is it so Chris? Please help me and reply to me as soon as possible because i really like your program. (If this comment was disrespectful, please report it.)
i try to run your program on network with domain but it taking long time to login, and nothing is happening i don't know whats wrong! (If this comment was disrespectful, please report it.)
100 Star for you buddy, very useful job (If this comment was disrespectful, please report it.)
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
By 109 Users
Download code
6/5/2001 9:45:24 AM: 
