| Author |
 Topic Search  Topic Options
|
rogerew 
Newbie
Joined: 20 August 2005
Status: Offline
Points: 6
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: What do I need
Posted: 20 August 2005 at 3:22pm |
I am new to this and could do with some guideance:
I am running Win XP Pro and Offcie 2003 and Dreamweaver MX 2004. My host is Linux with MySQL and Access Database availability.
I have a small Access database of a trade directory and I want my website visitors to be able to enter the type of tradesman they are looking for, such as plumber and the result page to display a list of all plumbers in the database.
My questions:
1. If I use ASP for my website will it work with the above?
2. When I have setup my site locally and tested it OK, is it just a simple matter of uploading all the files to the server?
TIA.
|
 |
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 August 2005 at 3:28pm |
do you mean like trustedtradesmen.com 
you can create one with what you have their
you need ot install IIS on the XP PRO machine, andf MYSQL if wanting to use that.
you could use access
if your going to grow quite big i would go with MySQL or MSSQL
it could be quite a project for the first one though
|
|
rogerew
Newbie
Joined: 20 August 2005
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 August 2005 at 3:43pm |
trustedtradesmen.com is a lot grander that I have in mind. What I have got to do is for the local Chamber of Trade and they've only got about 150 members.
I don't really want to use anything I'm not familiar with, unless I have to, especially if it will cost money, because I am doing the site on a voluntary basis. Having said that, I've not done any ASP pages before, though I have run through a tutorial or two and things seem to work locally.
When I've got it all working OK locally, do I just upload the files from c:\Inetpub\wwwroot\sitename to the server?
Also, can you recommend any good tutorials for my challenge?
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 August 2005 at 4:13pm |
this iste has a good tutorial on a guestbook idea.
and yes to an extent you just uplaod to the server
yet again that depends on the database type if about 150 with not to many vistors then access would be ok.
http://www.webwiz.net/asp/tutorials/default.asp
i went into the deep end with my first offical application a full tv guide .. was quite adventurous for me at the time.
that link should help
|
|
rogerew
Newbie
Joined: 20 August 2005
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 August 2005 at 4:23pm |
Thanks, I'll do the tutorial and then I'm sure I'll be back with more dumb questions. 
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 August 2005 at 4:29pm |
|
no worries we are happy to help, im sure
we all have been there before
|
|
Bluefrog
Senior Member
Joined: 23 October 2002
Location: Korea, South
Status: Offline
Points: 1701
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 August 2005 at 5:11am |
|
I'd recommend that you use MySQL and not Access. It's just better. I
don't like the way it handles datetime types, but it is solid.
Actually, I hate the way it handles them.
You'd also be better of with PHP instead of ASP on a Linux machine.
If you change to a Windows machine, then ASP/ASP.NET and MS SQL Server
are ideal. You can get relatively cheap hosting at a number of places.
Changing the database from Access to MS SQL Server is almost trivial - use DTS in Enterprise manager - very easy.
If you use ASP.NET instead of ASP, you might need Visual Studio, but
you can do it without it. Also, there's even less coding with VS. There
are lots of tutorials available on ASP, PHP, and ASP.NET for data
access, so just do a search for it. You can get lots of code samples
for free.
I hope that kind of helps.
Cheers,
Ryan
|
|
|
|
rogerew
Newbie
Joined: 20 August 2005
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 August 2005 at 12:59pm |
Hi Ryan,
I have never used MySQL. Apologies for my lack of knowledge, but is it a database app. similar to Access that I have running on my machine or is run from my hosts server. Also, most importantly, is it easy to learn? Likewise, is php easy to learn?
Roger.
|
|
