I see. Two options here: 1. Less secure You could open up the port on the web server (or wherever the MS SQL sits) and have OpenBD.local connect to the database directly. For that to work, you will probably need to enable TCP/IP connection within MS SQL and also SQL authentication. Else it won't work. But, as the title says, this is not very secure as you open up the port to the outside world and potential hackers can try to get into your database.
2. WebServices If there are only a couple of queries you need to make your application run "offline", then I would simply create a couple of web services. You can then fire off those calls to your remote server over port 80 and OpenBD will to its thing and will return to you the correct data. Again, with this solution you might want to send some sort of authentication, so no one else can use your web service to query your database. Kind Regards, Nitai On Mon, Dec 19, 2011 at 6:26 PM, Jason King <[email protected]> wrote: > Let's just say I have a typical OpenBD website for personal pages. The > website uses MS-SQL as it's DB. > > In this case, users just hit the website via port 80 over their browser and > the DB only talks to the webserver. > > For OpenBD Local, the user's app would need to communicate to the DB in the > same way. Can you easily create remote datasources using JDBC? Or would some > kind of SOAP procedure need to be in place? > > Could the database requests be funneled over port 80? Or would it matter > since we'd still most likely run into Windows Firewall where it made an > exception for the APP, not a specific port? -- See for yourself how easy it is to manage files today. Join the revolution! Razuna - Hosted Digital Asset Management Solution http://www.razuna.com/ Razuna - Open Source Digital Asset Management http://www.razuna.org/ Twitter - http://twitter.com/razunahq Facebook - http://www.facebook.com/razunahq Support Platform - http://getsatisfaction.com/razuna -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
