December 11, 2002 at 4:45 pm
I have a quick question although the answer might not be as quick...I hope it is.
I've been programming since '79 and the last 10 years I've been working in the Access, VB and in the last few years SQL Server. None of my clients have apps that would function well as a web based app. With that said, I would like to build some smaller web based app and am unsure of the technologies. I worked with Visual Interdev a while back, but found it to be very cumbersome.
Here is the question. What technologies do I use to create a web based app that would function very similar to an access or vb front end?
I plan on using SS2K and have worked quite extensively with ADO via VBA in access to execute SQL and run stored procs. If someone can recommend a book that would be great (please no book that uses c, only VB). I don't know c and can handle only so much of a learning curve.
I've been reading up on ADO.NET and other technologies, but I'm missing a key piece of info. Do I use ADO.NET, ASP.NET, XML, what app do I use to create my web appk, what about the reports (crystal reports - is there such an animal to create web reports)?
If this is something that needs to be better discussed over the phone give me a number and I'll give you a call at my expense. I would really like to understand this better.
Thanks,
Mike
December 11, 2002 at 5:27 pm
There is so much to offer there. You can use pretty much any technology with a web server. First decide what server you going to use (IIS, Apache, etc). Then look at the languages and technologies implemented on it (ASP, JSP, Perl, PHP, ISAPI, Cold Fusion, etc). Then as for editors there are a lot of those. I personally use VisualInterdev for the color coding but could just as easily code an ASP in notepad. For you background in VB and ACCESS I would look heavily at IIS using ASP or ASP.net, there are lots of helpfull site but try these.
http://www.planet-source-code.com
There are a lot of tools out but VisualInterdev and FrontPage are probably more in your league right of as opposed to Cold Fusion or Dreamweaver. Preferred method is to use ADO to make SQL connections, you might also extend funtionality of you code by making COM Components (ActiveX DLL) using VB.
And yes you can use Crystal Reports with ASP. But it is quite a pain in the backend.
Beyond all that read up on VBScript and ASP and try to get you hands on enough example code for what you want to try to do.
One thing of note with .NET framework items such as ASP.Net and VB.Net. MS has moved both to the realm of using C++ stlye classes to increase interoperability an total overall ability within those technologies. I would suggest learn a bi about C++ classes and objects if you plan to use .NET.
Edited by - antares686 on 12/11/2002 5:29:15 PM
December 11, 2002 at 5:39 pm
Thanks for the heads up. I think I'll take a small portion (the functionality can standalone) of an app and see if I can create a web based app.
Thanks again.
Mike
December 11, 2002 at 8:40 pm
You would be surprised at all the functionality that can be shoe-horned into the IE browser. We've done what I used to think were miracles as web-based apps. So don't sell yourself short as to what can be accomplished.
That said, your background would suit you to run ASP/SQLServer/NT pretty well. Your VBA will translate well to ASP.
Check out some online tutorials at Http://www.gotdotnet.com/ for free. You'll need at least the free .NET RUNTIME and sdk. Best if you can get Visual Studio.NET to code in. This is a microsoft site, don't let the URL fool you.
December 11, 2002 at 9:34 pm
Thanks for the advice. I have a sub to MSDN and will load Visual Studio and play with it.
The website you mentioned...does it have tutorials?
Thanks again,
Mike
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply