I need a huge favour! please guys

[dhtmlgod]

Ive got a client who currently has a db online which uses ASP to search it, all written by me. Currently, the db has 300,000 records, and the ASP is running fine.

Now, i jus finished have an arguement with M$ tech support that access only supports 60,000 records, and anything more would cos a HUGE slw down, which, for me, it didnt

You see, the problem is that the client wants to expand to 1.8 million records (wahyhay, blah blah) so what did M$ suggest.

I gotta get MS SQL

now, my work cant afford that for 1 client, the favour is this:

If i give all the specs for a databse, could someone please make it. it only has 4 tables, and you couldnt have to put any information in it, jus create the db.

please please please please please

thanks

d

[Omair Haroon]

Do you mean you only need the tables and the fields, right ?

Post the table names and fields here and I would do it for you..

[dhtmlgod]

yeah, thats all i need, jsu the tables and columsn, ill insert all the info

tha tables are...

tblsCart
cID - int, Identity Column
customerID - varchar - 50
reportNumber - varchar - 20

tblsCompanies
ID - int, Identity Column
companyName - varchar - 100
reportNumber - 20

tblsCustomer
ID - int, Identity Column
customerID - varchar - 50
surName - varchar - 50
foreName - varchar - 50
companyName - varchar - 100
email - varchar - 100
addy1 - varchar - 100
addy2 - varchar - 100
city - varchar - 100
code - varchar - 50
specReg - text
dateT = datetime

tblsReport
ID - int, Identity Column
reportTitle - varchar - 100
reportWords - text
reportNumber - varchar

thanks omair, you a life saver!! ill make it up some time

[DaveMaxwell]

D, you do realize that MS SQL is not independent like Access, right? You can't create a standalone SQL Server database like you can in access.

If you need a cheap host with MS SQL, try www.korksoft.com. for $100(US) a year, you get 150mb diskspace and 150mb of SQL Server. There are higher packages if you need it.

[dhtmlgod]

dave does that mean i would have to get my host people to make the db?

[goober]

Many hosts have a control panel set up which enables you to do it. You can also youse Enterprise Manager (I think that's the right one...?) to do it from your client PC.

Dave, thanks for the link. I'm definitely going to check that out as I need a SQL Host soon. So much easier.

[hendo]

dhtmlgod, mate...

Have you considered using MySQL? It's a great 1/2 step between Access and SQL server and best of all, it's free!

I use it all the time with ASP and have no problems at all. If you are going to grow to 1.8 million records, then Access was never meant to do that. It's really not even meant to be multi user as in accessible by a web server but because of ADO, OLEDB and ODBC it just worked out that way accidentally.

It is easy to install and there's a great GUI front end for it out there. Did I mention that it was free?

If you do intend to go down the SQL Server road, that's cool too. You'll find that whatever way you go, you'll need to change your SQL statements for things like date formats etc. Check out http://www.aspfaqs.com for more details.

Good luck and I hope you find a host that'll meet your needs!

hendo

[dhtmlgod]

i understand about access, and using mySQL has crossed my mind, but its up to the server, yeah?

and the concurrent users isnt a problem. only one section is using the db, and thats only to search and retrieve the results.

[big_al]

D,

If you want to create the database you can get a 120 day trial version of SQL 2000 for free.

If you want though i can create the database for you in SQL2000 or 7.

But it's not going to do you much good without a SQL Server on your server.

I can also suggest some hosts if you need one.

[dhtmlgod]

my host does have SQL Server, i wouldnt be asking if it didnt have it, would i

al, if u could make that in sql server2000, that would be great, thanks

[DaveMaxwell]

If your host has SQL Server, they will need to create a database on the server for you. Like I said, it's not a standalone file like an access database. Once the database is defined, you can either create the table through enterprise manager, or you can just create an ASP page containing all the SQL Create table statements.

[dhtmlgod]

thanks dave, thats cleared up alot of stuff for me

cheers

*goes to fone his host people*

[big_al]

D, I tried to email you but got it back?

Whats your email?

Dave, You can also attach any database to a SQL server, so they do not need to create the entire database for you, just attach one you give them

[dhtmlgod]

al dhtmlgod@hotmail.com

thanks

[Jeremy W.]

Ah, so I'm not doing this then? *L*

Thanx for letting me know

[dhtmlgod]

sorry sunny, you ran off b4 i got a chanceto say

[Jeremy W.]

s'aright, no worries mate *L*

So long as you get it done, I'm a happy webpunk

[dhtmlgod]

np sunny

the color of sitepoint are different on a mac look better. damn mac people.

if ur wondering why im on a mac, i got asked to look at some1s site

[Jeremy W.]

fun fun, damn macs

[davedibiase]

Dont be dissing macs!!!! They are good for design and graphics BUT THATS IT....boo OSx for there server capabilities...they will SUCK ****!

I do like them for there cool midi softwares and stuff...*school just bought one of Canada's most advanced mac labs...about 2 million in renevation * Gotta love catholic private schools

We are doing a contest for Hockey Night in Canada...for there 50 season anniversary we gotta do a cool video and music remix ...we are gonna win!

[goober]

I know this is kind of off-topic, but for your video / music remix, download SonicFoundry's Acid 3.0. Can be found at http://www.SonicFoundry.com or http://www.AcidPlanet.com . I use it all the time, it's crazy. If you want some loop sounds, I can send them to you. Just check it out and read a little about it. It's awesome.

[davedibiase]

Why would I do that when I have the software already ...we also have a 700.00 software called Reason by PropelorHead...ITS AWSOME! Generates these beats that are soooooooo cool...makes euro, trance and everything you can think of...!!!!!

[goober]

Because Acid's better?

[platinum]

yeah, acid is cool, hey, goober....
my friend goes crazy with it, keeps sending me songs he made. He made a sub tester song (cool) and a remix of who let the dogs out and all these really wierd ones.

[goober]

Excellent. It's a cool thing to be into, a good release for anyone (even if you're not quite the best at it). I've made a few mixes and such, but have yet to finish / upload them.

I think that's what I'll do for today.