jwcolby
jwcolby at colbyconsulting.com
Tue Jun 30 14:21:09 CDT 2009
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 > >