Re: SQL Server in SBS2000

From: Peter Riley (priley_at_taylorriley.co.uk)
Date: 06/06/04 

Date: Sun, 6 Jun 2004 09:37:57 +0100

In my experience, setting up SQL Server as the database backend is 'fairly'
straightforward - although it's limited in scope, I found SAMS Teach
Yourself SQL Server in 10 Minutes a good primer, and a small enough book to
keep in your pocket for a quick read every now and then. You'll need a more
comprehensive book in due course, but it covers the basics of setting up
SQL and was enough for my fairly simple db needs to start with.

As others have commented, the front end is the clever bit. ASP/VBScript
isn't that difficult and there are plenty of examples on websites, but for a
quick and dirty solution (no offence to the authors) I used Application Web
Builder at awdib.com. This provides a turnkey database based on your SQL or
Access db. There is a sister site called codecharge.com that offers a more
elegant solution, but these are very much generic databases and might still
require some tweaking to get your desired result. Worth a look, but you
might need to pay a coder to work up a solution if you don't fancy learning
ASP etc ...

Peter

"Torrey Lauer" <anonymous@discussions.microsoft.com> wrote in message
news:E2BE74CE-043E-4780-A6BE-F7BD32B46A12@microsoft.com...
>I would like to setup a database using SQL Server, but I don't even know
>where to start. My terminology may be off a little since I've never used
>SQL before.
>
> I would like to have several databases that also use forms. The first
> database I'd like to create would be used for our outside agents (agents
> that aren't in our main office). I'd like to have a place for our agents
> to go within our existing agent's only site in order to search for a
> vendor by name and/or click on a drop down bar to select the vendor. Once
> the vendor is chosen, it would display information that I would have
> already populated (ie: vendor's reservation number, vendor's website
> address, commission levels that we are at with that particular vendor, and
> any other notes that I would have listed for that vendor).
>
> Another database I'd like to have is one for call tracking. I don't know
> if this would work for this type of senario, but what I would use it for
> is for our agents to create a new "call tracking record" when they take a
> call. This would tell us how many calls the agent is taking (ie: if we
> are able to use reports to see how many call tracking records the agent
> created), who they talked to on that call, what transpired on the call
> (ie: client wanted a seven day cruise to the caribbean...wants to visit
> St. Thomas, St. Marteen, etc. Two person are going, wants junior suite
> with balcony...I quoted $1,500.00 including taxes, without airfare, per
> person...etc...). That way, if that agent isn't in the office when that
> client calls back to book the cruise or ask more question about the
> package the agent quoted, we can pull that record up and read what the
> agent has already told that client.
>
> So, I hope I got the idea across on what I'd like to do. Now, what I need
> to know is, will SQL work for these senarios? What program do I use to
> create the databases? Am I able to work right in SQL to set the databases
> up, create the fields, populate the fields, etc...?
>
> I was thinking of using Access to do the call tracking, but I was thinking
> that I'd like to have one place to have all this information.
>
> Can anyone provide me with some answers, some go to places to read about
> SQL and how to use it, any books that would help me out? I've tried
> looking at Microsoft's site about SQL and even did a google search for
> SQL, but before I buy any reference books, etc. I'd like to find out some
> do's, don't's, be carefuls, this works, that doesn't work, etc. from you
> guys.
>
> I appreciate any help any and/or direction any of you can provide me!
>
> Thanks!
>
> Torrey Lauer
> Modern Travel Services 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004

Relevant Pages

  • Re: Poly Couples
    ... If you want to claim that OO is the consolution prize for lame database ... there is a metamodel which describes the hierarchy. ... Metamodel is stored in SQL, however, the data is stored in non ... vendor, and the structure is different than the one you use originally. ...
    (comp.object)
  • Re: SQL Server in SBS2000
    ... Some require SQL backend. ... > I would like to setup a database using SQL Server, ... name and/or click on a drop down bar to select the vendor. ... This would tell us how many calls the agent is taking (ie: ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Poly Couples
    ... Essentially - different versions for different clients. ... insist that you use their existing database which is from a different ... vendor, and the structure is different than the one you use originally. ... characters would mark variable insertion place-holders in the SQL. ...
    (comp.object)
  • Re: SQL questions
    ... SQL Server can handle this from the database side. ... name and/or click on a drop down bar to select the vendor. ... This would tell us how many calls the agent is taking (ie: ...
    (microsoft.public.sqlserver.server)
  • Re: Poly Couples
    ... business software" example mentioned in this thread. ... But the communication mechanism with the database remains the same. ... That doesn't mean that other languages (such as sql, ... vendor, and the structure is different than the one you use originally. ...
    (comp.object)