Browser as Front-End

Hi!

I'm trying to build an app. for my parents' office. They have a small
office (5 PCs), and they currently work with a very old program that's
based on DOS. The program doesn't work well under XP, so they still use
Win 98. They had their network upgraded about a year ago. They had
Microsoft SBS 2000 installed, it includes SQL Server. I've written a
few DB's in Access before, and now I'm just learning how to use SQL.
Before I start work on their app., I have a question:

I know it's possible to create an interface that can be put on their
network and accessed via a browser. How is this done exactly?

It would be very beneficial for me, because it would mean that the new
app. would be platform independent, so that they can upgrade to XP
easily. It would also save us the cost of licensing front-end software
(e.g. Access) for each machine.

Any comments would be appreciated.

Noam Nelke, Israel.When you meant place the SQL Server on a network, you meant placing it
on a central server?

If that is the case, you can have one dedicated server for the SQL
Server and an application server where you can develop your web
application to create an Interface for this DB.
How to create the Interface?
- You can have a Web Server installed on the application server (IIS or
java based web servers) and then write your web code in any of the tons
of languages.

Hope that helps.|||Noam Nelke (NoamNelke@.gmail.com) writes:
> I'm trying to build an app. for my parents' office. They have a small
> office (5 PCs), and they currently work with a very old program that's
> based on DOS. The program doesn't work well under XP, so they still use
> Win 98. They had their network upgraded about a year ago. They had
> Microsoft SBS 2000 installed, it includes SQL Server. I've written a
> few DB's in Access before, and now I'm just learning how to use SQL.
> Before I start work on their app., I have a question:
> I know it's possible to create an interface that can be put on their
> network and accessed via a browser. How is this done exactly?

That's a question that does not have much to do with SQL Server. Most
people seem to use ASP or ASP .Net. There is also Cold Fusion out there,
and probably a few more possibilities.

> It would be very beneficial for me, because it would mean that the new
> app. would be platform independent, so that they can upgrade to XP
> easily. It would also save us the cost of licensing front-end software
> (e.g. Access) for each machine.

On the other hand, browser-based interfaces are often painful to use.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

BPA issues

BPA (SQL Best practices analyzer) issues
First off, great idea!
-Dead Logons should scavange better. The app locked up on a long operations and when I logged back in it told me I was already logged in. I went into the repository via EM and axed the row out of active_conns and everything was good again. Point being,
the average user might not know to do this and the app won't do anything if you can't logon.
-I get the following 2 lines in the Cursor usage detail when using FAST_FORWARD for my cursor in a sproc. According to BOL FAST_FORWARD = FORWARD_ONLY + READ_ONLY (which is NOT updatable)
-This cursor is declared as updatable, however it doesn't seem to be updated.
-This cursor does not specify explicit updatability information (FOR UPDATE clause or READ_ONLY clause).
-6 exceptions for resutls when running all the rules
Hi Sean
Thanks for your feedback. Some comments inlined.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sean B" <anonymous@.discussions.microsoft.com> wrote in message
news:C250B186-9486-4BA6-877F-F7C928CCC6DC@.microsoft.com...
> BPA (SQL Best practices analyzer) issues
> First off, great idea!
> -Dead Logons should scavange better. The app locked up on a long
operations and when I logged back in it told me I was already logged in. I
went into the repository via EM and axed the row out of active_conns and
everything was good again. Point being, the average user might not know to
do this and the app won't do anything if you can't logon.
Yes, this was annoying. It has been fixed in later builds.

> -I get the following 2 lines in the Cursor usage detail when using
FAST_FORWARD for my cursor in a sproc. According to BOL FAST_FORWARD =
FORWARD_ONLY + READ_ONLY (which is NOT updatable)
> -This cursor is declared as updatable, however it doesn't seem to be
updated.
> -This cursor does not specify explicit updatability information (FOR
UPDATE clause or READ_ONLY clause).
Fixed this one too, making both, fast_forward and static be treated as read
only cursors.

> -6 exceptions for resutls when running all the rules
>
Do you have more information here?
Thanks for your feedback.
- Christian

BPA Install Problem

I'm installing the latest version of BPA and seem to have run into an issue.
I've uninstalled the app and deleted the old BPA database, and while
reinstalling, I'm seeing an error message come up. "One or more rules could
not be installed. There is an error in XML document (55, 15). Invalid SQL
Server edition."
I'm running everything locally, and running SQL 2k, SP3 on WinXP SP1
Where can I start to look to debug this problem?
Steve
Please uninstall and reinstall, but before reinstalling make sure that the
destination folder is empty. At the very least you should make sure that
bpadmin.exe.config file doesn not exist, and that no files or folders are
left under repository folder.
Let me know if that doesn't work.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Steve Carroll" <steve_carroll72@.h_o_t_m_a_i_l.com> wrote in message
news:uELb%23aYTEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I'm installing the latest version of BPA and seem to have run into an
issue.
> I've uninstalled the app and deleted the old BPA database, and while
> reinstalling, I'm seeing an error message come up. "One or more rules
could
> not be installed. There is an error in XML document (55, 15). Invalid
SQL
> Server edition."
> I'm running everything locally, and running SQL 2k, SP3 on WinXP SP1
> Where can I start to look to debug this problem?
>
|||Well,
Its apparent that I'm a database guy and not an application guy!
That worked like a charm. Thanks!
BTW... great app!
-Steve
"Christian Kleinerman [MS]" <ckleiner@.online.microsoft.com> wrote in message
news:e870CqYTEHA.2324@.TK2MSFTNGP10.phx.gbl...
> Steve
> Please uninstall and reinstall, but before reinstalling make sure that the
> destination folder is empty. At the very least you should make sure that
> bpadmin.exe.config file doesn not exist, and that no files or folders are
> left under repository folder.
> Let me know if that doesn't work.
> - Christian
> --
> ___________________________
> Christian Kleinerman
> Program Manager, SQL Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Steve Carroll" <steve_carroll72@.h_o_t_m_a_i_l.com> wrote in message
> news:uELb%23aYTEHA.2908@.TK2MSFTNGP10.phx.gbl...
> issue.
> could
> SQL
>