Wednesday, May 9, 2007

Day 1 - Spikes - Hello World!

10am ish....To continue with coding tradition....

We are using Openhost.co.nz for our live webserver.

1 - Hello World in plain text
We put up a default.aspx page on mateer.dnserver.co.nz. I am using VS2005. Created an ftp website, with no local files at all. Just working straight off live. Using the inbuilt ftp explorer in VS... website, copy website.

2- Hello World from a database
We created a database on openhost. Then created a user. Created a new ftp project called dave1. Then used a SqlDataSource control to connect to the live database, using the wizard and the SQL database login we'd just created. Then bound a GridView, DataList, and DetailsView.
http://mateer.dnserver.net.nz/dave1/Default.aspx

3 - Connected to live database through SQL Server Management Studio
Had to open up a port on Openhost's firewall. Then could connect.
http://mateer.dnserver.net.nz:85/sql.php

Watch out above, especially if you're behind a firewall, as more than likely they will block this outgoing port.

No comments: