jwcolby
jwcolby at colbyconsulting.com
Tue Jun 30 14:40:41 CDT 2009
As I said, I will be looking at this stuff. I too am out of my league here. John W. Colby www.ColbyConsulting.com Max Wanadoo wrote: > So, why not use NET SEND? > > Using Stuart's code you have the machine names on the net if you want to > pick one. If you want to broadcast to all send to * > > > Max > > > > -----Original Message----- > From: dba-vb-bounces at databaseadvisors.com > [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: 30 June 2009 20:21 > To: Discussion concerning Visual Basic and related programming issues. > Subject: Re: [dba-VB] Messaging For JWC WAS: Syslogs > > Drew, > > >If you want to play around with it, what you need to do is use UDP to > 'broadcast' a hello and > goodbye message, to alert everything on the subnet. (And you have to filter > that message on the > broadcasting machine, cause it'll pick up it's own message). In that > hello/goodbye message, you can > include all the info you want (username, computername, IP,etc). Then it's > just a matter of using > TCP for direct comms between two machines. > > In fact I don't want direct comms between machines, I want precisely > "broadcast" messages. "Hey > everybody, I added a new record in tblX". Any machine receiving that > message promptly refreshes the > cache for that table. > > "Hey everybody, we are shutting down the BE in 10 minutes, get out". Any > machine receiving the > message pops up a message to the user telling them to finish up and get out > of the database. > > That kind of message. I really don't care about sending to a specific > machine, I care about sending > to ALL machines. > > John W. Colby > www.ColbyConsulting.com > > >> Native does put a crimp in things. TCP/IP communications is pretty easy >> with a Winsock control. It can be done with API's but it's a pain, and >> you need to deal with callback functions, which have issues in and of >> themselves in Access 2000 and on. >> >> If you were ok with an .ocx, I could whip that up, if you need something >> native, that would require callbacks, and a lot more coding. If you >> want to play around with it, what you need to do is use UDP to >> 'broadcast' a hello and goodbye message, to alert everything on the >> subnet. (And you have to filter that message on the broadcasting >> machine, cause it'll pick up it's own message). In that hello/goodbye >> message, you can include all the info you want (username, computername, >> IP,etc). Then it's just a matter of using TCP for direct comms between >> two machines. >> >> Drew >> >> -----Original Message----- >> From: dba-vb-bounces at databaseadvisors.com >> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby >> Sent: Tuesday, June 30, 2009 12:45 PM >> To: Discussion concerning Visual Basic and related programming issues. >> Subject: Re: [dba-VB] Messaging For JWC WAS: Syslogs >> >> Drew, >> >> I really want this but it has to be vba native, no OCXs. I am familiar >> with OCXs that are part of >> Access, and that is OK. >> >> This would be used with my framework and I cannot guarantee that i can >> register anything. It has to >> just work. >> >> John W. Colby >> www.ColbyConsulting.com >> >> >> Drew Wutka wrote: >>> Is this something you really want? >>> >>> It would be pretty simple to create an OCX that you could have on a >>> hidden form, that would 'see' all running instances of your >> application, >>> and be able to 'communicate' to them. >>> >>> There is one quirk. It'll work on a standard network. However, if >> your >>> network is subnetted, it would only 'see' what's in the local subnet >>> (because the best way to do this is to send out a broadcast 'hello' >> and >>> 'goodbye' message). To work with a subnetted network, you'd have to >>> come up with a 'server/client' scenario, so the server would see all >> the >>> connected users (sort of like a custom DNS server). >>> >>> If you aren't worried about a subnetted network, let me know, I am >>> pretty sure I can whip up an OCX to do what you want. >>> >>> Drew >> _______________________________________________ >> dba-VB mailing list >> dba-VB at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/dba-vb >> http://www.databaseadvisors.com >> >> The information contained in this transmission is intended only for the >> person or entity >> to which it is addressed and may contain II-VI Proprietary and/or II-VI >> Business >> Sensitive material. If you are not the intended recipient, please >> contact >> the sender >> immediately and destroy the material in its entirety, whether electronic >> or >> hard copy. >> You are notified that any review, retransmission, copying, disclosure, >> dissemination, >> or other use of, or taking of any action in reliance upon this >> information >> by persons >> or entities other than the intended recipient is prohibited. >> >> >> _______________________________________________ >> dba-VB mailing list >> dba-VB at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/dba-vb >> http://www.databaseadvisors.com >> >> _______________________________________________ >> dba-VB mailing list >> dba-VB at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/dba-vb >> http://www.databaseadvisors.com >> >> The information contained in this transmission is intended only for the > person or entity >> to which it is addressed and may contain II-VI Proprietary and/or II-VI > Business >> Sensitive material. If you are not the intended recipient, please contact > the sender >> immediately and destroy the material in its entirety, whether electronic > or hard copy. >> You are notified that any review, retransmission, copying, disclosure, > dissemination, >> or other use of, or taking of any action in reliance upon this information > by persons >> or entities other than the intended recipient is prohibited. >> >> >> _______________________________________________ >> dba-VB mailing list >> dba-VB at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/dba-vb >> http://www.databaseadvisors.com >> >> > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > >