I've done a little bit of research lately about connection to SQL Server via the internet. Here is an article from MSDN that discusses it. http://msdn.microsoft.com/en-us/library/ms191192.aspx Your key is to setup SQL Server to use certificates. You can setup the port that it listens to, by default it is 1433. I'm not sure if the driver that OpenBD uses would handle the certificates, but my guess would be yes.
Just my 2 cents, it might be easier to setup some sort of webservice to handle the data transfer instead. OpenBD Local would just talk to the webservice on 443 and the return would be the data requested. On Mon, Dec 19, 2011 at 10:26 AM, 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? > > > > On Mon, Dec 19, 2011 at 11:21 AM, Mats Stromberg > <[email protected]>wrote: > >> Sure MS SQL won't be a problem... Problem is how to define Remote... >> Really remote might mean problem with firewalls and ports but besides that, >> what ever you can do on. A regular OpenBD you can do on the OpenBD.Local >> >> >> /Mats/ >> >> On Monday, December 19, 2011, Jason King <[email protected]> wrote: >> > Anything for MS-SQL ? I haven't ever had to deal with writing an app >> that remotes into SQL Server so I'm clueless about it. >> > >> > On Mon, Dec 19, 2011 at 11:16 AM, Mats Stromberg < >> [email protected]> wrote: >> > >> > OpenBD-OTR.Local is available now on the project page. It communicazes >> with 87 Oracle DB's so remote work just fine. >> > It's a standard OpenBD that is used so anything is possible. >> > I agree with Nitai that the H2 is most likely the best choich for an >> embeded solution. >> > >> > /Mats/ >> > >> > On Monday, December 19, 2011, Jason King <[email protected]> >> wrote: >> >> How does it work with remote databases? >> >> >> >> This might be a great way to offload server load for a public website, >> but it would still need to be able to connect to a remote database. >> >> Thoughts? >> >> -Jason >> >> On Mon, Dec 19, 2011 at 11:01 AM, Nitai @ Razuna <[email protected]> >> wrote: >> >> >> >> Alan, >> >> >> >> We have bundled the H2 database for some time now with OpenBD. You can >> >> run it as a embedded database and also as a server. It is very >> >> reliable and work perfectly. More information about it can be found >> >> here at http://www.h2database.com >> >> >> >> Kind Regards, >> >> Nitai >> >> >> >> On Mon, Dec 19, 2011 at 5:47 PM, Alan Holden <[email protected]> wrote: >> >>> This is very intriguing! >> >>> How would you recommend incorporating a (pseudo?) database into an >> OpenBD >> >>> Local package? >> >>> Al >> >>> >> >>> On 12/19/2011 2:01 AM, Alan Williamson (aw2.0 cloud experts) wrote: >> >>>> >> >>>> Good morning, >> >>>> >> >>>> We're excited to make available an exciting new way to package up >> your >> >>>> OpenBD apps. We are calling it >> >>>> >> >>>> OpenBD Local >> >>>> >> >>>> You can read more about it here and download it: >> >>>> >> >>>> http://openbd.org/local/ >> >>>> >> >>>> This is a new way for you to package up your OpenBD Web App and have >> it >> >>>> run locally on a users desktop, complete with a system-tray icon for >> >>>> launching it. It ships with everything your users need, including >> an >> >>>> embedded JRE and Jetty. You just supply your OpenBD web app. >> >>>> >> >>>> Our dear friend Mats has been testing for us and gone much further >> and >> >>>> developed a complete installation script for Windows using the >> Nullsoft >> >>>> Scriptable package. You can read more about how to do this at the >> OpenBD >> >>>> Manual prepared by Mats >> >>>> >> >>>> http://openbd.org/manual/?/local_nsis >> >>>> >> >>>> So what does this mean? >> >>>> >> >>>> In a nutshell, it allows you to package up webapps that maybe are >> filling >> >>>> a specific niche or requirement. Because you can restrict you >> webapp to >> >>>> just the local desktop machine you can do things for the user that >> wouldn't >> >>>> normally be possible from a remote server. For example, imagine >> building a >> >>>> system to index all specific files on a users desktop and offer up a >> rich >> >>>> webapp to manage this (MP3 player comes to mind). Another use >> is >> >>>> specific utilities that you may want to give certain users to run. >> >>>> >> >>>> Or even better, a very quick way for people to try our yourself >> beautiful >> >>>> software without all the hassle of installing Java, Jetty and >> OpenBD. Just >> >>>> download and run. >> >>>> >> >>>> We believe in getting OpenBD into the hands of as many people as >> possible >> >>>> and negating all the headaches normally associated with such a >> deployment. >> >>>> >> >>>> Let us know what you think, >> >>>> >> >>>> alan >> >>>> >> >>> >> >>> -- >> >>> online documentation: http://openbd.org/manual/ >> >>> google+ hints/tips: https://plus.google.com/115990347459711259462 >> >>> http://groups.google.com/group/openbd?hl=en >> >> -- >> online documentation: http://openbd.org/manual/ >> google+ hints/tips: https://plus.google.com/115990347459711259462 >> http://groups.google.com/group/openbd?hl=en >> > > -- > online documentation: http://openbd.org/manual/ > google+ hints/tips: https://plus.google.com/115990347459711259462 > http://groups.google.com/group/openbd?hl=en > -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
