Just because you can connect to MSSQL of the internet doesn't mean you should, this is what restful web services are for, it creates a facade layer in front of your database and means you maintain control of only sending the data across the wire you actually need, you can also build in elements of pagination on the data set etc.
A On 19 December 2011 17:39, Mats Stromberg <[email protected]> wrote: > As an Oracle Guy trying to be funny.... MS SQL isn't that the only True > Open DB? wide open for the whole world... I mean... Microsoft and Security > doesn't go together :) > > On Mon, Dec 19, 2011 at 6:31 PM, Jason King <[email protected]>wrote: > >> Yea, I was wondering if it would be better to try and talk via XML, but >> I'm not schooled in this area of database connectivity. >> >> >> On Mon, Dec 19, 2011 at 11:28 AM, Benjamin Davis < >> [email protected]> wrote: >> >>> 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 >>> >> >> -- >> 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 > -- Alex Skinner Managing Director Pixl8 Interactive Tel: +448452600726 Email: [email protected] Web: pixl8.co.uk -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
