MeratusHost.com

What do I need to learn to have a database update automatically from my site into a database program.?

I am ok with HTML and CSS. I have Microsoft Professional (w/ Access and Excel). Are either of these possible to integrate with a website. What do I need (software-wise) and need to learn to be able to build a database and have it update automatically when a person signs up on my website. Also, I would like the database to update info on my site and have a member login available. I also need to know how to host my own site (does SQL server allow me to host my own website). Thanks for the help!

Public Comments

1. you can learn asp .net technology for sql db or php with mysql. Sql servers are only for databases, but if you have a server with sql, just need to read the help to know how to upload files(html or ftp), directory where the pages goes, and configure the sql username and password, etc...
2. most decent web hosting have mssql databases on them. You basically just need a script to take your form imput and write it to the database. There are plenty of free php scripts on the web which you can modify to do this. You can probably also find one that you can actual use to create your database itself.
3. Yes to Access and you need a good working knowledge of ASP PHP and Java Script. You will also need your hosting company to make sure you have ASP support or PHP so you can use server side objects. To host your own website you'll need a web server such as Apache or MS IIS. IIS comes with XP-Pro and can be used as is. SQL has nothing to do with the web server but it too can be used as a database back end for your application. You will also need to check with your ISP in regards to port blocking of Port 80 requests. The code used to connect the database is: Set connectionToDatabase=Server.CreateObject("ADODB.Connection") connectionToDatabase.ConnectionTimeout=60 connectionToDatabase.Open "DSN=your data base name" You must also have the host provider set up DSN or use an alternative method to connect.