[dba-VB] Messaging For JWC WAS: Syslogs

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
> 
> 



More information about the dba-VB mailing list