How To on connecting to a hosted SQL Server Express database


Author
Message
Jeff Pagley
Jeff Pagley
Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)
Group: StrataFrame Users
Posts: 223, Visits: 893
Hi SF Team,

As I have mention in the past, I am just a part-time VB.NET programmer.  I am not on here very often, but when I need advice or REAL answers you guys are the ones I come to. That is why I love SF and renew my license every year to have access to this forum. 

My scenario is this.  I have written Win App obviously using SF.  Each database only has to hold up to 500,000 records maximum so that is why I am using SQL Server Express databases.    Currently, I have setup an VPN connection to enable 2 users to connect remotely to the databases within my client's network for running the win app.   In addition, I have serveral small databases running on a single XP box using a single SQL Server Express instance.  Depending on the client records they can connect to any one of the databases they choose.  At the moment, everything is working great.  However, he wants to setup up to 10 remote users.  Therefore, it poses several questions in my mind that I am looking for some suggestions, advice or even How Tos.   I think hosting this stuff on the internet would make my life easier in terms of supporting the remote users and updating changes to the databases, but being a part-timer I have NEVER done any of this before.

1. What is the simplest way to deploy updates to the remote users?  Over internet?

2. If over the internet, would I host the updates on a ftp site that the remote users would download or have some way that the app automatically downloads the update?

3. Should I use a hosting site for the SQL Server Express databases so that I don't have to support 10 VPN connections?

4. If hosting the SQL Server Express databases on the internet is the way to go, do you have any suggestion on who I should use?

5. Also, if am going to host the databases on the internet, how do I make the connection using SF?

Sorry about all of the NEWBIE questions!  But I want to do this the right way and I know you guys will give me the best advice.

Thank you and thanks again for this helpful forum and your great products.

Jeff

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Jeff Pagley - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Jeff Pagley - 16 Years Ago
Keith Chisarik - 16 Years Ago
Jeff Pagley - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Jeff Pagley - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Keith Chisarik - 16 Years Ago
Jeff Pagley - 16 Years Ago
Jeff Pagley - 16 Years Ago
Charles R Hankey - 16 Years Ago
Jeff Pagley - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Jeff Pagley - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Jeff Pagley - 16 Years Ago
Jeff Pagley - 16 Years Ago
Trent L. Taylor - 16 Years Ago
                         Hi Trent, Thanks for the info. Right now I do have the logic to check...
Jeff Pagley - 16 Years Ago
                             [quote]Does this seem to be a reasonable thing to do?[/quote]
...
Trent L. Taylor - 16 Years Ago
                                 Trent, Now I understand the licensing for ES. Purchasing smaller host...
Jeff Pagley - 16 Years Ago
                                     Jeff,

If you will contact Jay Taylor we have a model that...
Trent L. Taylor - 16 Years Ago
                                         Sorry....you can call the sales line or email him at...
Trent L. Taylor - 16 Years Ago
                                         Trent, That's great news. I do have a question that I would like...
Jeff Pagley - 16 Years Ago
                                             Jeff,

I'm not sure if you are asking about the databases...
Greg McGuffey - 16 Years Ago
                                                 Hi Greg, Thanks for the opinion on separate databases. I also felt it...
Jeff Pagley - 16 Years Ago
                                                     Jeff,

ES can definitely connect to any number of databases,...
Greg McGuffey - 16 Years Ago
                                                         Hi Greg, Thank you. Your explanationtruly helped. I have looked at...
Jeff Pagley - 16 Years Ago
                                                             [quote]I believe for my scenario, everytime I add a new database to my...
Greg McGuffey - 16 Years Ago
                                                                 Hi Greg, Thanks for all of the great info. I am going to setup a test...
Jeff Pagley - 16 Years Ago
Jeff Pagley - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Jeff Pagley - 16 Years Ago
Jeff Pagley - 16 Years Ago
Jeff Pagley - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Jeff Pagley - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Jeff Pagley - 16 Years Ago
Keith Chisarik - 16 Years Ago
Jeff Pagley - 16 Years Ago
Greg McGuffey - 16 Years Ago
Jeff Pagley - 16 Years Ago
                         It's pretty easy. I don't have the help docs available at the moment...
Greg McGuffey - 16 Years Ago
                             [quote]Greg that is a great suggestion. However, how do I encrypt the...
Trent L. Taylor - 16 Years Ago
Keith Chisarik - 16 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search