Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-19 : 08:56:02
|
| Geoff writes "I have a VB 6 \ SQL Server 2000 application running fine over a LAN. I wish to extend the application to remote users (users at home \ users at client sites), via the internet.I have found several references to doing this, but can't find a step by step guide that I can actually follow. Any suggestions?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2001-12-19 : 10:12:37
|
| Have you looked at ASP sites? Here's a few good ones:www.4guysfromrolla.comwww.asp101.comwww.learnasp.comwww.aspalliance.comMuch of the coding is VBScript, and you can easily modify it for your app. The techniques used are tailored for internet connections, and are tweaked to minimize network traffic. This also applies to ADO settings and tweaks to improve performance.I don't know if they have a step-by-step guide from start to finish exactly. Since you've got a finished app, all you really need to do is allow for internet connections to the database. You'd need to use TCP/IP for your network protocol, if you aren't already. The only problem you might run into is database access, if you open connections and leave them open for the duration. This may cause performance issues and should be avoided if possible. The ASP sites detail this a lot and have many examples on how to work around it.HTH |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2001-12-19 : 10:15:22
|
| Well, without a little info it's hard to give you a solid reccomendation, but I'll give you a few places to start thinking about. First, I seriously doubt you're going to find a nice step by step guide for your situation. These kinds of books rarely exist that just fit perfectly into your problem. Having said that and basing this advice on some assumptions, you'd probably want to structure this as an n tier application. A vb front end to sql will not do anything to help you get users into the program over the lan. Your best bet, IMHO, would be a vb front end/a web front end/a middle tier with business logic(COM + MTS, or COM+) and keep your data layer as is, with SQL2K. This puts most of the "meat" of your application into objects which can then be used by either front end and will put you in a position to make your app more extensible and scalable should you need it to be.@#$#$ damn Volk! Mike "A program is a device used to convert data into error messages."Edited by - mfemenel on 12/19/2001 10:16:34 |
|
|
|
|
|
|
|
|
Using a VB Application to access SQL Server over the internet