Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access a data base from the web site?

    (If there is a better forum for this query and its potential discussion, please advise)



    I believe I am using the DAO3.51 library. I have simple cover functions (below) in Word97SR2/VBA which successfully access my Access97 databases. I can write Word97/VBA which obtains data from local Access97 databases and thereby populate a document. I have written simple Centura/SQL code.


    I *have* to start moving towards writing code that accesses a data base from the web site.

    At this point I don't know what the database will be (but I keep hearing the words "SQL") and I don't know where the server would be.

    I figure that I can do some preparation by taking my existing code and cloning/modifying it towards a better standard. An example of such a step might be to create a private web page that can access my local Access97 database when I am dialled in to the ISP.

    How big a step is this? Am I going to have to learn another (web) language? Although it might seem pointless to have a page on the Web that works ONLY when I have 56K-dialled in, it is at least a step away from isolation.


    <pre>(snip)
    Dim wrk As Workspace
    Set wrk = wrkCreateWorkspace("", "admin", "")
    Dim dbs As Database
    Set dbs = dbsOpenDatabase(wrk, strPath, strFile) ' given path and file
    Dim rst As Recordset
    Set rst = rstOpenRecordset(dbs, "SELECT * from " & strTable) ' given table
    (snip)
    </pre>


  2. #2
    Star Lounger
    Join Date
    Dec 2000
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access a data base from the web site?

    The answer for you is Visual InterDev, ASP and ADO.

    Basically, I was in a similiar position about 2 years ago. I was strictly a VBA guy, but I needed to create database-driven web apps, which I had absolutely zero experience doing. I taught myself the basics of Visual InterDev and ASP within one week. (I already knew ADO.) Coming from VBA, this wasn't too difficult because the main server side ASP language is VBScript, just another flavor of VB!

    Anyway, a better forum for this type of question may be the "HTML/JavaScript/VBScript/etc...". Also, you might want to check out a Visual InterDev forum I also belong to: http://VI6Talk.listbot.com

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access a data base from the web site?

    Stephan, thanks. If nothing else I should start towards ADO. I'll also hunt down Visual Interdev. Is that a third-party package? Are there alternatives to it (but you found it to be the best) or was Interdev forced on you by a corporate decision?

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access a data base from the web site?

    Visual InterDev comes with MS Visual Studio up through version 6 (it's supposed to be incorporated into VB in the next version) or is available directly from Microsoft for the cost of shipping. InterDev is free (there's your corporate decision for you) and already compatible with the rest of the MS suite, so it's a natural choice. You could look into products like Cold Fusion, but they require you to learn their scripting language.
    Charlotte

  5. #5
    Star Lounger
    Join Date
    Dec 2000
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access a data base from the web site?

    Chris,

    ADO by itself is not going to do it for you. You're still going to have to learn ASP. Visual InterDev, which comes with the Visual Studio package (as Charlotte mentioned in her post), is simply a development tool for creating and deploying ASP. I, and not my former boss, was the one who made the decision to use it instead of competing technologies like Cold Fusion. And, like I said in my earlier post, coming from a VBA/VB background, I found Visual InterDev/ASP *really* easy to learn because the main server side language is VBScript. Now, as you get into web programming more, you're also going to have to learn some JavaScript for client side stuff, and there's no way around that. But the meat of the programming is server side.

    The way I taught myself Visual InterDev was with essential 2 books. I started out with the easiest book on the market, believe it or not, "Visual InterDev 6 For Dummies", which I zipped through within a week. With that, I already had enough knowledge to develop basic database-driven web apps. Then, I immediately graduated to one of the hardest books on the market, "Visual InterDev6 Unleashed" from SAMS, from which I got more intricate knowledge.

    Anyway, with your experience in VBA/VB, I'm sure you too will pick up the web programming very fast.

    Stephan

  6. #6
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access a data base from the web site?

    Stephan,

    Appreciate your posts here. This is very helpful for me too.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  7. #7
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Access a data base from the web site?

    Where is the free version? Professional is $279 for FrontPage users...

    <A target="_blank" HREF=http://shop.microsoft.com/Products/Products_Feed/Online/VisualInterDev6.0ProfessionalEdition[663]/ProductPricingDetails.asp>http://shop.microsoft.com/Products/Product...essionalEdition[663]/ProductPricingDetails.asp</A>

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access a data base from the web site?

    You may have to own one of the Visual Studio products to get the offer. I own VB 6.0 Professional, so I may have been confused by all the stuff they offered with it.
    Charlotte

  9. #9
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access a data base from the web site?

    Stephan, Charlotte, thanks for your replies. It's going to be a small invsetment in cash and a small investment in literature and an investment in time - perhaps one week total if I can maintain my 3am-11pm schedule a while longer.

  10. #10
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access a data base from the web site?

    Some months later- how did Visual Interdev suit you? I'm just starting to look at it now as one alternative.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  11. #11
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access a data base from the web site?

    Look fast, Geoff. I understand it's built into the Visual Studio applications in XP rather than being a separate application. I guess I'll find out for sure when I attend an XP launch in a couple of weeks. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  12. #12
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access a data base from the web site?

    Geoff, I'm sorry; I didn't follow up on the leads. I got involved with something else. I'm still trundling along with DAO3.51, when i need it.

    I suspect that for now I'm happy enough saying "Ive used the DAO and the Centura/SQL techniques, and if/when a client asks me to use something else, I'll master the differences".

    The talk of spending money to learn something also put me off a bit .....

  13. #13
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access a data base from the web site?

    Could you recommend a good book for Visual Interdev?
    Thanks!

  14. #14
    Star Lounger
    Join Date
    Dec 2000
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access a data base from the web site?

    Like I said in my earlier post, Visual InterDev 6 For Dummies (when you're just starting out) and then Visual InterDev 6 Unleashed (once you get beyond the basics).

    However, note this: Visual InterDev as a development tool is gone in Visual Studio.NET. However, what you learn Visual InterDev, you can still apply all you know to ASP.NET. OTOH, you may just decide to skip learning Visual InterDev entirely and jump straight into ASP.NET -- there are pros and cons to doing either, but it's your decision.

  15. #15
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access a data base from the web site?

    Thanks!

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •