Peter J. Boettcher — Sat, 22 Apr 2000 13:44:00 +0000

Voltec,

If you're currently connecting to Access via a DSN then the upgrade is very simple. All you would need to do is import your Access database into SQL 7 (easily done through a wizard), and make sure your DSN points to SQL and all your pages should work no different then before (just faster!).

If you were connecting to Access physically (the .mdb file is sitting on your web site) then you will have to change your connection coding to use a DSN connection.

Regards,
Peter J. Boettcher

Voltec — Fri, 21 Apr 2000 21:14:00 +0000

Peter,

How difficult would it be for me to go from Access to SQL 7 if I begin with Access 2000? I have the site setup now with Access 2000 but can upgrade later to include SQL.

Matt

------------------
1-On-1 Free Basketball Game - Wanna Play?
Click here to Play!

Peter J. Boettcher — Wed, 12 Apr 2000 13:13:00 +0000

Voltec,

If you're running on a Windows NT server then the best way to go is ASP for sure, but I would try to go with a dedicated DB solution like SQL 7. When your using ASP, it's really easy to integrate SQL 7 queries into your page.

Make your connection (ADO,RDO, etc), execute your query, and do whatever you want with the results. Really simple.

Plus when you use an ADO recordset it's easy to move anywhere in the recordset using recordset.movelast, recordset.movefirst, etc.

Have fun at sea!

Regards,
Peter J. Boettcher

[This message has been edited by Peter J. Boettcher (edited 12 April 2000).]

Gil — Tue, 11 Apr 2000 23:15:00 +0000

There are completely functional versions of PHP for windows. Check on PHP.net. A while back, I was presented with the same problem, Voltec. I went with choice #1 (Access and ASP) simply because I had some new ASP software I wanted to try out (Mardomedia Drumbeat). Not to say that Drumbeat is horribly bad, but I think that I made a mistake. Since I already know PHP, it would've been faster for me to code it in PHP instead of the 'ASP WYSIWYG'. If the project wasn't almost over, I would redo it in PHP. If you're admining the web server, you'll have to compile PHP and maybe MySQL to install it on your machine. Just a few considerations.

------------------
Gil Hildebrand, Jr.
Senior Web Developer, 4atcost.com

RC — Tue, 11 Apr 2000 20:46:00 +0000

Voltec

I am not 100% sure, but I thought PHP was UNIX only. Of course, someone may have created PHP software for NT, or I could be totally wrong.