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
