Go Back   Computer Forums > Web Design | Website Development > Web Programming
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 10-11-2004, 06:56 PM   #1
Beta Member
 
Join Date: Oct 2004
Posts: 1
Default ASP/Database

I have an issue, that I cannot figure out what to do with.. Here's the deal.. we are trying to launch a community portal with business listings and such... http://www.pro-fyle.com/project/sl/ is the link.

What we want to do is I think simple, but hard to create... We want to be able to make a database in Access, and pull certain categories according to the link set up... ie.

..../project/sl/index.asp?category=business&listingID=001

this would open the index.asp page, but only this time with the content directly pulled onto the page from the database in question...

If someone can help me create this, it would be greatly appreciated since none of use here have strong knowledge of asp, or any programming language for that matter and we want to learn..

Thank You much in advanced

Nick
__________________

oddfoo is offline   Reply With Quote
Old 10-12-2004, 12:35 PM   #2
Site Team
 
David Lindon's Avatar
 
Join Date: Dec 2002
Posts: 15,233
Default Re: ASP/Database

I would strongly not recommend using access for your database. Try www.mysql.com and pull the values from that.
__________________

__________________
[url=http://www.LNXPS.NET]LNXPS.NET - The XPS Library]
David Lindon is offline   Reply With Quote
Old 10-12-2004, 12:49 PM   #3
Guru
 
Lord Kalthorn's Avatar
 
Join Date: Dec 2003
Location: Britain
Posts: 13,293
Send a message via MSN to Lord Kalthorn
Default

MySQL is cool; but if you'll probably get much better connectivity from an MSSQL Database. Access is not really up to what you're asking of it in that situation.
__________________
A Knight is sworn to Honour. His heart knows only Virtue. His blade defends the helpless. His might upholds the Weak. His word speaks only truth. His wrath undoes the Wicked.
Lord Kalthorn is offline   Reply With Quote
Old 10-15-2004, 11:37 PM   #4
entity512
Guest
 
Posts: n/a
Default Re: ASP/Database

Mysql kick ass to a mssql, and its free
  Reply With Quote
Old 10-16-2004, 04:32 AM   #5
Site Team
 
David Lindon's Avatar
 
Join Date: Dec 2002
Posts: 15,233
Default Re: ASP/Database

I'm sure MSSQL is cool but it has a $20,000 license tag attached to it!!
__________________
[url=http://www.LNXPS.NET]LNXPS.NET - The XPS Library]
David Lindon is offline   Reply With Quote
Old 10-16-2004, 07:51 PM   #6
Guru
 
Lord Kalthorn's Avatar
 
Join Date: Dec 2003
Location: Britain
Posts: 13,293
Send a message via MSN to Lord Kalthorn
Default

Lol; nah. I will be using MSSQL a lot in the next few months (as you will notice I won't be using your MySQL Databases, which you'll probably like, but...) :P

Then I will truely know if the price tag is worth it. Which I'm sure it is - they use MSSQL on Terabyte Databases; 2005 even has general support for Terabyte Databases. I imagine they'll be using it for MSN Search when they finish it off

So it has its uses. And is brilliantly intergrated into the best web design language available - ASPX! So how can you go wrong using MSSQL?
__________________
A Knight is sworn to Honour. His heart knows only Virtue. His blade defends the helpless. His might upholds the Weak. His word speaks only truth. His wrath undoes the Wicked.
Lord Kalthorn is offline   Reply With Quote
Old 10-16-2004, 09:55 PM   #7
entity512
Guest
 
Posts: n/a
Default Re: ASP/Database

Just.....mysql very good......not much point in mssql. Anyway, i bet you ms are running linux boxes with modmono, mysql and apache
  Reply With Quote
Old 10-17-2004, 12:11 PM   #8
Guru
 
Lord Kalthorn's Avatar
 
Join Date: Dec 2003
Location: Britain
Posts: 13,293
Send a message via MSN to Lord Kalthorn
Default

I'd bet they're running some boxes with that - cause they need so much server power they can't own it all - and they can't control their suppliers if they want to use it, can they

But I can assure you - they are not using MySQL; all their databases would be in their Web-Centre on their Windows Servers with MSSQL. They probably don't use ModMono either - because thats for ASPX and Microsoft sites are now mostly on MSPX, so they have probably got their own Linux to MSPX Program on them.
__________________
A Knight is sworn to Honour. His heart knows only Virtue. His blade defends the helpless. His might upholds the Weak. His word speaks only truth. His wrath undoes the Wicked.
Lord Kalthorn is offline   Reply With Quote
Old 10-20-2004, 06:19 PM   #9
Site Team
 
root's Avatar
 
Join Date: Mar 2004
Posts: 7,999
Default

MySQL is free, so long as any improvements you make are also released from free.
there is a commecrical license available from MySQL incase you don't feel like sharing.

On the whole MS-SQL is a better database than MySQL (from a technical perspective as a DBA and from a technical specs aspect).
MS-SQL is easier to configure and runs faster, it's more scalable,
However there are known bugs including massive memory leaks that can cause time out errors in ODBC drivers if not properly addressed.
MS-SQL has extensive (and secure) suport for stored procedures, (which greatly reduce the bandwidth used in each connection.)MySQL is only just developing that suport now in version 5 (available in unstable release).

MS-SQL has better suport for connection pooling, and the management tools are much easier to use. -I'm yet to try the new SQL2005 (codename YUKON), but I feel good things are coming in the way of the XML configured services in the same style as IIS6. Alowing much easier managed services accross server farms. (if they appear)...

So MS-SQL, better support, better scalability, easier usability.
MySQL, free, portable...

It's fair to say that if you wanted a truly good, easy to configure, fast (Hugely scalable), extensive support portable to all platforms.
You'd use Oracle. -It really is that simple
I don't have any speed comparissons but oracle 10g running on redhat enterprise linux runs better than MS-SQL 2000 on windows 2000. and better than MySQL on any platform.
root is offline   Reply With Quote
Old 10-21-2004, 05:17 PM   #10
Guru
 
Lord Kalthorn's Avatar
 
Join Date: Dec 2003
Location: Britain
Posts: 13,293
Send a message via MSN to Lord Kalthorn
Default

Can't admit to hearing about Oracle? But it sounds good. Obviously though - I hate it because its against the Microsoft one

MSSQL 2005 is damn good, very good. I can't test the scability of course - I just don't have the time to invent masses of random data but I have been testing it and fiddling about for my Bulletin Board Project - so that will be fun
__________________

__________________
A Knight is sworn to Honour. His heart knows only Virtue. His blade defends the helpless. His might upholds the Weak. His word speaks only truth. His wrath undoes the Wicked.
Lord Kalthorn is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 05:06 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0