just questions
January 6th, 2009
Personal:
Just some questions, we are looking for a webhosting site, for the Albany Attack Lacrosse team Fan club. It s new this year so starting small. Right now I have a small site on a freebie host. God never saw so much trouble!
Any way...any host recommendations?
Second:
Work:
I would like to find out how to run a web site with a db...
I would like to find out how to connect an MSDE .adp to and SQL Server 2000 db that manages our website at work.
I want to find out how...what is the code if you have data on a website, that comes from a db, and you would like to group it, and suppress duplicates. I can easliy do this in Access...but am told it would take years of programming to make a webpage behave the same way.
On Click, order by.... yea I know there is more! LOL
Any info will as always be humbly accepted and appreciated...oh by the way...I AM DEPRESSED, My Cards got shut out and are not in the world series :(
but the games are good anyway.
Here is the online demo (http://www.ritsema.com/nl_images/view_access.aspx)
Here is a snapshot of how the table is setup:
http://www.ritsema.com/nl_images/access.jpg
See the code here (make sure you click the Read It Link to view the datails):
View the Access Code (http://www.ritsema.com/nl_images/code2.aspx)
Thanx so much, Buk that is the greatest answer I have ever gotten! :)
I will try to answer your questions. Dream as you know, I think this again stemmed from a fair amount of frustration!
WEbhosting: Personal, my husband and I are part of the Albany Attack Lacrosse team fan club. I set them up a little free website, just to get them up and running, so people would know about it, meeting notices etc. Well, let me tell you, that free site is a pita! The tech support for the html editor is in England! And it seems every time I edit something the darn thing goes down. Soooo... we began checking for webhosting... this is the first year for the fanclub, so of course looking to keep cost down. Have had several recommendations from my web tech buddies. Thanks all. Thought I would jump on the chance to set up a db, and learn to run the website from it. (Dream you know I am a learn-a-holic)! LOL, or a masacist maybe! And frankly, I can't find an html editor I am fond of, sort of just like notepad.
Web/Database/SqlServer/
.adp is an Access Data Project, it's what you have when you upgrade your Access Database, using Jet... to the MSDE, using a client side version of SQL Server 7... I did this, so I could learn about SQL Server....
Where I work, we have a company building us a website, based on SQL server tables...
and when we ask that information be displayed, grouped or sorted, the same way I do, in my Access db, they act like I have just ask them to swing across the Grand Canyon on dental floss.
I don't know everything...so when they tell me..."oh, the programming involved"... I am sometimes not sure of the amount of work, yet at the same time, I HATE being snowed! Ya know?
Anyway, now Victoria will get down off of her soap box.
Buk, thanks again, those examples are fabulous, thanks for taking the time to do that for me.
Buk: That's way cool!!!
Vic:
Cheapest I can get you is about $65/year, but it won't host a DB. 5 email addresses, 25MB (all you'd need unless you want a DB). Next step up is $150 at 50MB and PHP/SQL DB capability.
Cheapest domain name registration: www.gkg.net for $10/year
What's the DB for, girlfriend?
I know nothing about MDSE or SQL.
However, this forum, which costs about $85/year to *lease* has an underlying SQL DB and is coded with PHP--just like TSG's.
Here is a online demo (http://www.ritsema.com/nl_images/view_excel.aspx)
Here are the steps to duplicate it. First of all set up your datasource, in my example I am using Excel and this is how my spreadsheet looks.
http://www.ritsema.com/nl_images/excel.jpg
Once you have that built you can save it to your web directory. In my case I am going to put the file in the same directory the page is going to be and I am going to use the default name Book1.xls.
Here is the code: (for some reason my code would not show correctly.) So if you are interested in the code I posted the code here: Code to view data source (http://www.ritsema.com/nl_images/code1.aspx)
A1: What price range are you looking for?
Q2: I would like to find out how to run a web site with a db...
A2: If you are familiar with VBA (Access) and have a basic understanding of HTML you should have no problem getting started. If you are starting from 0 I would suggest that you skip classic asp and go straight to ASP.Net.
Q3: I would like to find out how to connect an MSDE .adp to and SQL Server 2000 db that manages our website at work.
A3: I am not sure what a .adp is but hooking anything to SQL is usually just a matter of setting the connection up either though ODBC or through a DNS connection.
Q4: I want to find out how...what is the code if you have data on a website, that comes from a db, and you would like to group it, and suppress duplicates. I can easliy do this in Access...but am told it would take years of programming to make a webpage behave the same way.
A4: Not necessarily true. I am going to post a quick demo for you that fits most of your criteria. This is for displaying the data only but with a little programming you can accomplish "most" of what you can do in a Access form/report.
The following two examples are ASP.Net samples.
Thanks again, for all your help. Dreamboat has always been great support and has become a "girlfriend" as a result! LOL
The free site has been up about 2 weeks and we have had 450+ visitors so far.
I will check out the stuff you suggested when I get home tonite.
:)
Oh yea you mentioned something about editors. Here is a great one that is free and is wired directly for the MSDE. It is the best learning tool I have ever used in my short history as a hack developer.
Believe it or not the program is free, small (1.2MB), comes with its own web server and is available from Microsoft's .Net Site (http://www.asp.net/webmatrix/default.aspx?tabindex=4&tabid=46) along with free support. Check out the forum for the free support.
You must have the .Net distributable installed on your computer to use it but that is a small thing compared to what you get. If you find a host that supports ASP.Net you can email me and I will help you get started by putting some basic database code in your template.
#If you have any other info about this subject , Please add it free.# |
