×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to broadcast data from a SQL server to an IP an Port
2

How to broadcast data from a SQL server to an IP an Port

How to broadcast data from a SQL server to an IP an Port

(OP)
Hi all,

Thanks for a great forum.

I hope this is the right topic for this query?

I have the following issue.

I have a server, which has SQL server and a database, for car parking data ( spaces total and spaces left ).

I want to broadcast each car parks spaces left to the Server IP and ports ( about 5, one for each car park ).

How would I go about this?

I have looked at the MS sites, one is https://docs.microsoft.com/en-us/sql/database-engi...

I want to continuously broadcast that data to the IP and ports, so the data is always live.

The server requesting data from those ports, outputs that data onto a website.

Where do I start?

What should I ensure is in place before transmitting the data?



Thanks for your help on this smile

Thank you,

Kind regards

Triacona

Thank you,

Kind regards

Triacona

RE: How to broadcast data from a SQL server to an IP an Port

As you have data in an SQL Server and a webpage for each car park, the natural way would be whatever these sites are written in queries the database.
Why go totally unwieldy and proprietary ways through whatever protocols you think about using special ports? That would be something I could put in perspective, if the clients would be simple IoT devices, bzt even that era is past as the simplest such things, even displays or free/occupied signs could be driven by SoC devices such as Arduino, Raspberry Pi and the like, those could even host a localhost web site.

Since that information is coming from the car parks I wonder why you can centralize the data but not get the local information back locally. Sounds like the system as far as it is wasn't thought out well.

Bye, Olaf.

Olaf Doschke Software Engineering
https://www.doschke.name

RE: How to broadcast data from a SQL server to an IP an Port

(OP)
Hi Olaf,
Thanks for answering smile
Basically this is a very old system, using radio towers to transmit to a central location, as the car parks are far from each other.
The system is legacy and was implemented 20 years ago.

I have been tasked with getting that information onto a web page.
The web page displays all data for the car parks in terms of spaces left, and has an algorithm to change the wording if there are no spaces.

There is not internet connectivity for the car parks just the radio transmitters.
These radio signals are intercepted in a central location.
The data is then loaded into the SQL server db.
We then read this data onto an ip and each carpark is a different port.

We had a different db to do this, but now moved to SQL server db.
And now the SQL server has all the data, as the previous method did not.

So what I want to know is:
1. How do output a query / create a re-occurring query that outputs the data to ip and ports, for example:
Car Park ..................noFreeSpaces..................totalNoSpaces
Yellow.......................0001............................1000



Thanks for all your help smile

Thank you,

Kind regards

Triacona

RE: How to broadcast data from a SQL server to an IP an Port

what was the old process doing? how was it collecting the data and sending to a db? I am not aware of any db that does that natively, always had a intermediary program waiting for data and then writing that data to a db.

look into the detail and the code - not just telling us what the process is (what you think it is!!!) but the technical detail.

Regards

Frederico Fonseca
SysSoft Integrated Ltd
www.syssoft-int.com

FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?

RE: How to broadcast data from a SQL server to an IP an Port

A laptop now is not necessary for car diagnostics - any device with Android on it will do, even a mobile phone. It's called OBD scanner and it's a very useful thing for checking the car condition. I use this one - https://play.google.com/store/apps/details?id=com....

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close