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
