New project in ASP ; some general questions

[xDRAN0x]

Hello

After surfing this forum for a while, I finally deceided to join.

My project is pretty basic, but ASP is unknown to me (but don't be ashamed, I've got a lot of tutorials, documentation, etc). I have to make a little web page that will display my compagny's Access Database, with a user login.

#1 :My question is, do I really need them to buy me an ASP compiler? Or do you suggest that I keep "EasyASP" editor and try to make my way through this?+
If you know a free compiler, wich one do you recommend? Because I think that for such a little project, paying 1500$ can for .net suite is pretty big.

#2 :Also, what is the real difference between a connection with/without DSN?

#3 : The web site isn't hosted on the same server where the database is stocked (provider(site) - compagny(db)). Anyone has some tips on this?

I've got experience in C, Java, Ada95 (heheh), SQL, Assembly.

Thanks for those who will take time to read, and maybe anwser

xDRAN0x
(sorry for English mistakes, it's not my first language)

 

[xDRAN0x]

at least point me to some URL or books, I really need clues on this, especially the #3.

 

[ReAn]

ASP isn't compiled, it's interpreted. This means that the file you make in notepad is what will run. IIS comes with all the neccesary tools to make asp run and is automatically configured to do so. As far as different servers goes, if the webserver can access the db over a shared drive, then perhaps... but it will be slow.

Your best bet is to get mySQL (Free) http://www.mysql.org/
Install that and port your db over to a server-based setup. Then use a system dsn on the webserver to access it, asp's ADODB can then talk to ODBC and access the SQL server via DSN

 

[xDRAN0x]

ASP isn't compiled, it's interpreted. This means that the file you make in notepad is what will run. IIS comes with all the neccesary tools to make asp run and is automatically configured to do so. As far as different servers goes, if the webserver can access the db over a shared drive, then perhaps... but it will be slow.

Your best bet is to get mySQL (Free) http://www.mysql.org/
Install that and port your db over to a server-based setup. Then use a system dsn on the webserver to access it, asp's ADODB can then talk to ODBC and access the SQL server via DSN

Thanks for specifying. Without saying no to mySQL solution, I've been given two others and I'de like to hear from you guys about :

1st : to use HTTPS to connect to the remote server and then "talks" to the Access DB (I know I'm missing details).

2st : to make a batch file for FTP scheduling, ex : at midnight, each day, it will upload the BD to the web server.

Remember that the Access DB and the web site are hosted on different servers.

Thanks