1. Home
  2. Point-Of-Sale Software
  3. Report or SQL Query from website

Report or SQL Query from website

Let's say I have my own hosted website and domain with MySQL support (not sure if that matters here)...

What I would like to do is pull real-time or near real-time data from my Store Ops or HQ Server database. What kind of solutions should I be looking for?

If this is not possible, I was going to try a "roll-my-own" solution by scheduling SQL queries that output to text files and pushing the files to a web server via ftp using windows task scheduler.

I would much prefer the "pull" solution to get real time data. I guess I would need to do some port forwarding on my gateway/firewall/router to access the SQL Server fron the WAN side.

Any ideas?

Reply to
Jason
Loading thread data ...

I didn't get any responses on this... Is that because it isn;t possible, or it's just too hard to accomplish? Any thoughts?

To give a simple example, I would like to just do a very simple query with Item Description and Quantity and have it updated on an Internet accessible web page in real time or near real time.

Jason

Reply to
Jason

At this point, I am just trying to see if I can access my MSQL Server from the outside world... I have obtained a snipped of PHP code to test whether the PHP script could find the SQL Server. I placed this in a file on a PHP enabled web server.

---start---

---end---

My SQL database server sits behind a NAT router that has a public Internet IP address. I have forwarded ports 1433 and 1434 on the router to the LAN IP of the SQL Server.

The PHP file is returning the first string, "Connection Started," but then returns nothing else.

I have checked using a network tool that port 1433 and 1434 are indeed open.

I can't figure out how to confirm connection to the SQL Server.

Any suggestions?

Reply to
Jason

Oh rats... I just realized that my stupid hosting company does not have the MS SQL library extensions enabled in thier PHP build. That throws a twist into my plans... In fact, it squashes my plans...

Reply to
Jason

I recommend not doing this at all - far safer to push information out to your web site than to open ports and pull it. This is a very bad idea - shame on me for even responding to you...

to answer your question, try running a simple SQL query and see if you get a return - for instance "select getdate()" will just query the current date and time from the SQL Server. I would guess that your connection attempt is not completing, but I've never used php...

you might try adding the port number to your ip address - 10.2.3.4:1433

Glenn Adams Tiber Creek C> At this point, I am just trying to see if I can access my MSQL Server from

Reply to
Glenn Adams [MVP - Retail Mgmt]

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.