Newbie question - do I need to SQL Server client?

This is very much a newbie question as I have not worked with MSSQL Server
before. I may be hosting a MS SQL Server database for a web site soon and
will require to generate reports from the data.

I assume I can just use SQL queries within my ASP web pages?

Will I need to buy the MS SQL Server client tool to be able to work with the
database? I can run queries on the database without having the client can't
I?

Thanks,
StephenHi,

i think you can use ADO and then there is no need for
client tools or something else. If you do a google with
"ADO in ASP" you will find a lot of information about
books, hints, troubles and other stuff.

bye,
Helmut

"Stevio" <redeagle@.freeuk.com> schrieb im Newsbeitrag
news:bg8Ya.201$XE3.177018@.newsfep1-win.server.ntli.net...
> This is very much a newbie question as I have not worked with MSSQL Server
> before. I may be hosting a MS SQL Server database for a web site soon and
> will require to generate reports from the data.
> I assume I can just use SQL queries within my ASP web pages?
> Will I need to buy the MS SQL Server client tool to be able to work with
the
> database? I can run queries on the database without having the client
can't
> I?
> Thanks,
> Stephen

Newbie question - Best practices for local/remote development?

Excuse me, I'm a relative newbie.

My question: What's the best practice for developing locally and then uploading to a production web site?"

Here's my plan:

I will use ASP.NET 2.0. I want to use Visual Web Developer 2005 Express Edition to develop locally using SQL Server 2005 Express Edition (.mdf file).

Then I want to upload my changes to a web site that uses the full version of SQL Server 2005 (not the Express Edition.)

I know how to upload my .aspx files to the remote site using Visual Web Developer.

But how should I handle my data? I imagine I can keep a little test data in my local .mdf database, and then just make sure the tables on the remote SQL Server always exactly mirror what I've got locally.

Then I just upload any changed .aspx files, which should work both locally and remotely.

Is this the best way? Or will I have to every time first change something in my .aspx files, to handle the data connection difference between my local db to the remote db?

Much ThanksThe convention is to store your database ConnectionString in the Web.Config file. Then you will only have one place to change it. See http://www.dotnetjohn.com/articles.aspx?articleid=3

Newbie question

Hi All,
My company has a legacy web application (VBScript/ASP) that includes a
series of forms used to create various reports on SQL Server (or Oracle)
data. Creation of these reports is extremely tedious due to fairly
complicated calculations etc. My question for the group is: Is MS
Reporting Services a valid alternative to the way i'm doing things now? I
need to be able to create new interactive custom reports fairly easily and
link to them via the old web application.
Thanks In Advance,
TeddRS integrates pretty easily with custom web apps particularly for intranet
apps. You can use either URL integration or web services integration. URL
integration is the easiest and fullest featured (you have roll you own a lot
more when using web services). SQL Server reporting is very easy. The main
thing with Oracle is getting all the client apps installed and properly
configured (but that is not too untypical of anything concerning Oracle). I
go against Sybase and SQL Server. Others once up and running have been
successfull with Oracle. With RS 2005 (released in November) my expectation
is Oracle will be easier to go against. It also has a good many improvements
(my two favorites are dynamic sorting and multi-select parameters). I would
suggest getting the 90 day trial and give it a try.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tedd Simms" <tedd.simms.SPAMTRAP@.cognostech.com> wrote in message
news:yf-dnbYtb-kzmF7fRVn-gQ@.novus-tele.net...
> Hi All,
> My company has a legacy web application (VBScript/ASP) that includes a
> series of forms used to create various reports on SQL Server (or Oracle)
> data. Creation of these reports is extremely tedious due to fairly
> complicated calculations etc. My question for the group is: Is MS
> Reporting Services a valid alternative to the way i'm doing things now? I
> need to be able to create new interactive custom reports fairly easily and
> link to them via the old web application.
> Thanks In Advance,
> Tedd
>|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:etoRWSPfFHA.1948@.TK2MSFTNGP12.phx.gbl...
> RS integrates pretty easily with custom web apps particularly for intranet
> apps. You can use either URL integration or web services integration. URL
> integration is the easiest and fullest featured (you have roll you own a
> lot more when using web services). SQL Server reporting is very easy. The
> main thing with Oracle is getting all the client apps installed and
> properly configured (but that is not too untypical of anything concerning
> Oracle). I go against Sybase and SQL Server. Others once up and running
> have been successfull with Oracle. With RS 2005 (released in November) my
> expectation is Oracle will be easier to go against. It also has a good
> many improvements (my two favorites are dynamic sorting and multi-select
> parameters). I would suggest getting the 90 day trial and give it a try.
Thanks for the response Bruce.
Actually, i'm not too worried about using it with Oracle. I'm trying to
convince my boss to discontinue development and support for it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Tedd Simms" <tedd.simms.SPAMTRAP@.cognostech.com> wrote in message
> news:yf-dnbYtb-kzmF7fRVn-gQ@.novus-tele.net...
>> Hi All,
>> My company has a legacy web application (VBScript/ASP) that includes a
>> series of forms used to create various reports on SQL Server (or Oracle)
>> data. Creation of these reports is extremely tedious due to fairly
>> complicated calculations etc. My question for the group is: Is MS
>> Reporting Services a valid alternative to the way i'm doing things now?
>> I need to be able to create new interactive custom reports fairly easily
>> and link to them via the old web application.
>> Thanks In Advance,
>> Tedd
>

newbie q: "contacting server to create web project" runs forever

hi, I'm using vstudio 2002, trying to create an C# asp web project, when I select these for a new project it says contacting server to create web project and never quits even after 1.5 hours. I saw in a similar post elsewhere they said the solution is to disable the firewalls - and I did that - and I have norton only, so that is not the issue. IIS is installed as well as SQL server, I can see it running. I have tested successfully a sql connection not long ago using access. Any thoughts? Thanks.
Dell 9300 1.6 GHZ
XP pro 2004 w/service pack2

Hi,

It seems the problem is that the VS does not find your local server.
(Reason my be, you have changed your machin IP somtime after Installing the VS)

Check the server name on new project dialog box and if needed change
it to localhost or the IP address of your system.

|||Did you ever get an answer to this? I have what looks like the identical problem.

newbie q: "contacting server to create web project" runs forever

hi, I'm using vstudio 2002, trying to create an C# asp web project, when I select these for a new project it says contacting server to create web project and never quits even after 1.5 hours. I saw in a similar post elsewhere they said the solution is to disable the firewalls - and I did that - and I have norton only, so that is not the issue. IIS is installed as well as SQL server, I can see it running. I have tested successfully a sql connection not long ago using access. Any thoughts? Thanks.
Dell 9300 1.6 GHZ
XP pro 2004 w/service pack2

Hi,

It seems the problem is that the VS does not find your local server.
(Reason my be, you have changed your machin IP somtime after Installing the VS)

Check the server name on new project dialog box and if needed change
it to localhost or the IP address of your system.

|||Did you ever get an answer to this? I have what looks like the identical problem.

Newbie needs to be told where to go! (Cross-Post)

Greetings:
I've been developing web applications with asp/sql and access for some
time now on existing servers. I am now in a situation that requires me to
install SQL Server (SBS 2K sp3) as the backend for an intranet served from
IIS. I've installed the SQL services and have created the database and I
have some of the web based application written, no problem, but I've yet to
be able to access the database that I created on the newly installed SQL
server from the web based applications. Even after setting up the virtual
directory with the IIS SQL snap-in, I only get a DNS Server not found error
when I try to browse the site. If I remove the IIS/SQL virtual directory, I
can browse pages that don't error out due to data references.
Where can I find a walk through for setting up SQL Server and IIS to
function together in this very basic manner?
Thanks in advance.
--
Jerry M. Gartner
www.gartnerwebdev.comHi,
Have a look at these...
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;176378
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;176380
http://support.microsoft.com/default.aspx?scid=kb;zh-
cn;chs264921
http://support.microsoft.com/default.aspx?scid=kb;PL;264921
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;245243
>--Original Message--
>Greetings:
> I've been developing web applications with asp/sql
and access for some
>time now on existing servers. I am now in a situation
that requires me to
>install SQL Server (SBS 2K sp3) as the backend for an
intranet served from
>IIS. I've installed the SQL services and have created
the database and I
>have some of the web based application written, no
problem, but I've yet to
>be able to access the database that I created on the
newly installed SQL
>server from the web based applications. Even after
setting up the virtual
>directory with the IIS SQL snap-in, I only get a DNS
Server not found error
>when I try to browse the site. If I remove the IIS/SQL
virtual directory, I
>can browse pages that don't error out due to data
references.
> Where can I find a walk through for setting up SQL
Server and IIS to
>function together in this very basic manner?
>Thanks in advance.
>
>--
>Jerry M. Gartner
>www.gartnerwebdev.com
>
>.
>|||Peter:
Preliminarily, this appears to be what I'm looking for. I didn't think
to use ODBC and a DSN. What are the major differences between ODBC and
"direct" connection? There will be under 30 clients using the DB - this is
an on demand intranet application and will be hit lightly and sporadically
throughout the day. The SQL server is also the PDC and fileserver/DFS root
and gateway. (2K SP4)
--
Jerry M. Gartner
www.gartnerwebdev.com
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:03de01c3a83a$14ef9140$a001280a@.phx.gbl...
> Hi,
> Have a look at these...
> http://support.microsoft.com/default.aspx?scid=kb;EN-
> US;176378
> http://support.microsoft.com/default.aspx?scid=kb;EN-
> US;176380
> http://support.microsoft.com/default.aspx?scid=kb;zh-
> cn;chs264921
> http://support.microsoft.com/default.aspx?scid=kb;PL;264921
> http://support.microsoft.com/default.aspx?scid=kb;EN-
> US;245243

NewBie Here: Need Help Please (SQLCommand)

Hi Guyz, im currently studying asp.net, i need a code that retrive data from SQL database and post it using Label (web from), i dont know how to do it, need help... Thanks in advance !!!!

Hi There,

First of all import sqlclient namespace

using System.Data.SqlClient;

Read data from sql database and set value to Label1 and Label2

protectedvoid Page_Load(object sender,EventArgs e)

{

// Create database connection

SqlConnection connection =newSqlConnection("YourConnectionString");

// Create instance of command

SqlCommand command =newSqlCommand("Select Field1, Fields2 From TableName", connection);

// Open database connection

command.Connection.Open();

// Execute command and get datareader

System.Data.SqlClient.SqlDataReader datareader = command.ExecuteReader();

// Check whether or not datareader has soemthing

if (datareader.Read())

{

Label1.Text = datareader.GetString(0);// get Field1

Label2.Text = datareader.GetString(1);// get Field2

}

// Close database connection

command.Connection.Close();

}

Newbie - What do I need

Hi All
At work we use SQL server to host all our databases. I develop web applications but don't do the SQL maintenance but do build db (my dba checks everything and sets all the permissions, etc). Anyway, a nonprofit has asked me to build them a web applicati
on to collect and display information nothing too fancy but lots of data and lot of users.
What are my options? Do I have to buy the server version if I just want to build a database but it is going to be collecting and serving the information from our web host (they've agreed to the extra cost for a web host providing SQL), we aren't keeping
a local version of the records. So I just need SQL to build the db and upload it to our web host. My dba said try access but it only allows 5 concurrent connections. I've heard of MySql or something but since I am somewhat familiar with the basics of
SQL was hoping there was some option for me. They don't need to do analysis or use the info other than to display it on web pages. They estimate they have 5,000 - 10,000 users who will enter 10 to 20 records each including photos.
I appreciate any recommendations or advice you could provide.
Thanks!!
"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!
MSDE is free and is SQLServer. It comes free with many products including
the free ASP.NET web matrix.
http://www.asp.net/
You can buy a $50 copy of SQL Server developer edition.
http://www.microsoft.com/sql/howtobuy/development.asp
To get a copy of SQL Enterprise Manager and the rest of the tools.
David
|||Hi David
So if I bought the developer edition I would be legal to build the database and upload it to our web hosting server?
I purchased visual studio.net so I don't have matrix. Would you recommend I go that way using MSDN or the developer edition?
Thanks for the FAST feedback!!
Tracie
"David Browne" wrote:

> "Tracie" <Tracie@.discussions.microsoft.com> wrote in message
> news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> applications but don't do the SQL maintenance but do build db (my dba checks
> everything and sets all the permissions, etc). Anyway, a nonprofit has
> asked me to build them a web application to collect and display information
> nothing too fancy but lots of data and lot of users.
> to build a database but it is going to be collecting and serving the
> information from our web host (they've agreed to the extra cost for a web
> host providing SQL), we aren't keeping a local version of the records. So I
> just need SQL to build the db and upload it to our web host. My dba said
> try access but it only allows 5 concurrent connections. I've heard of MySql
> or something but since I am somewhat familiar with the basics of SQL was
> hoping there was some option for me. They don't need to do analysis or use
> the info other than to display it on web pages. They estimate they have
> 5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> MSDE is free and is SQLServer. It comes free with many products including
> the free ASP.NET web matrix.
> http://www.asp.net/
> You can buy a $50 copy of SQL Server developer edition.
> http://www.microsoft.com/sql/howtobuy/development.asp
> To get a copy of SQL Enterprise Manager and the rest of the tools.
> David
>
>
|||If your company has SQL, and you have a client license, then you can load
the personal edition (from the company CD) to your desktop dev
environment...
(If it were me, I'd get the non-profit to purchase you the Development
Edition, that you keep, for the $50)... It is a great great price, (just
reduced from $500)..
Have fun!...This may the start of a great new thing for you!
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!
|||"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:5EE69FF4-4DFF-4DB0-982B-EF3C5BA28896@.microsoft.com...
> Hi David
> So if I bought the developer edition I would be legal to build the
database and upload it to our web hosting server?
The hosting server must have Sql server or MSDE on it.

> I purchased visual studio.net so I don't have matrix. Would you recommend
I go that way using MSDN or the >developer edition?
MSDE comes with visual studio so you have it. In fact you can just download
it now.
http://www.microsoft.com/sql/msde/do...s/download.asp
David

Newbie - What do I need

Hi All
At work we use SQL server to host all our databases. I develop web applications but don't do the SQL maintenance but do build db (my dba checks everything and sets all the permissions, etc). Anyway, a nonprofit has asked me to build them a web application to collect and display information nothing too fancy but lots of data and lot of users.
What are my options? Do I have to buy the server version if I just want to build a database but it is going to be collecting and serving the information from our web host (they've agreed to the extra cost for a web host providing SQL), we aren't keeping a local version of the records. So I just need SQL to build the db and upload it to our web host. My dba said try access but it only allows 5 concurrent connections. I've heard of MySql or something but since I am somewhat familiar with the basics of SQL was hoping there was some option for me. They don't need to do analysis or use the info other than to display it on web pages. They estimate they have 5,000 - 10,000 users who will enter 10 to 20 records each including photos.
I appreciate any recommendations or advice you could provide.
Thanks!!"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!
MSDE is free and is SQLServer. It comes free with many products including
the free ASP.NET web matrix.
http://www.asp.net/
You can buy a $50 copy of SQL Server developer edition.
http://www.microsoft.com/sql/howtobuy/development.asp
To get a copy of SQL Enterprise Manager and the rest of the tools.
David|||Hi David
So if I bought the developer edition I would be legal to build the database and upload it to our web hosting server?
I purchased visual studio.net so I don't have matrix. Would you recommend I go that way using MSDN or the developer edition?
Thanks for the FAST feedback!!
Tracie
"David Browne" wrote:
> "Tracie" <Tracie@.discussions.microsoft.com> wrote in message
> news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> > Hi All
> > At work we use SQL server to host all our databases. I develop web
> applications but don't do the SQL maintenance but do build db (my dba checks
> everything and sets all the permissions, etc). Anyway, a nonprofit has
> asked me to build them a web application to collect and display information
> nothing too fancy but lots of data and lot of users.
> > What are my options? Do I have to buy the server version if I just want
> to build a database but it is going to be collecting and serving the
> information from our web host (they've agreed to the extra cost for a web
> host providing SQL), we aren't keeping a local version of the records. So I
> just need SQL to build the db and upload it to our web host. My dba said
> try access but it only allows 5 concurrent connections. I've heard of MySql
> or something but since I am somewhat familiar with the basics of SQL was
> hoping there was some option for me. They don't need to do analysis or use
> the info other than to display it on web pages. They estimate they have
> 5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> > I appreciate any recommendations or advice you could provide.
> > Thanks!!
> MSDE is free and is SQLServer. It comes free with many products including
> the free ASP.NET web matrix.
> http://www.asp.net/
> You can buy a $50 copy of SQL Server developer edition.
> http://www.microsoft.com/sql/howtobuy/development.asp
> To get a copy of SQL Enterprise Manager and the rest of the tools.
> David
>
>|||If your company has SQL, and you have a client license, then you can load
the personal edition (from the company CD) to your desktop dev
environment...
(If it were me, I'd get the non-profit to purchase you the Development
Edition, that you keep, for the $50)... It is a great great price, (just
reduced from $500)..
Have fun!...This may the start of a great new thing for you!
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!|||"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:5EE69FF4-4DFF-4DB0-982B-EF3C5BA28896@.microsoft.com...
> Hi David
> So if I bought the developer edition I would be legal to build the
database and upload it to our web hosting server?
The hosting server must have Sql server or MSDE on it.
> I purchased visual studio.net so I don't have matrix. Would you recommend
I go that way using MSDN or the >developer edition?
MSDE comes with visual studio so you have it. In fact you can just download
it now.
http://www.microsoft.com/sql/msde/downloads/download.asp
David

Newbie - What do I need

Hi All
At work we use SQL server to host all our databases. I develop web applicat
ions but don't do the SQL maintenance but do build db (my dba checks everyth
ing and sets all the permissions, etc). Anyway, a nonprofit has asked me to
build them a web applicati
on to collect and display information nothing too fancy but lots of data and
lot of users.
What are my options? Do I have to buy the server version if I just want to
build a database but it is going to be collecting and serving the informatio
n from our web host (they've agreed to the extra cost for a web host providi
ng SQL), we aren't keeping
a local version of the records. So I just need SQL to build the db and uplo
ad it to our web host. My dba said try access but it only allows 5 concurr
ent connections. I've heard of mysql or something but since I am somewhat f
amiliar with the basics of
SQL was hoping there was some option for me. They don't need to do analysis
or use the info other than to display it on web pages. They estimate they
have 5,000 - 10,000 users who will enter 10 to 20 records each including pho
tos.
I appreciate any recommendations or advice you could provide.
Thanks!!"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!
MSDE is free and is SQLServer. It comes free with many products including
the free ASP.NET web matrix.
http://www.asp.net/
You can buy a $50 copy of SQL Server developer edition.
http://www.microsoft.com/sql/howtobuy/development.asp
To get a copy of SQL Enterprise Manager and the rest of the tools.
David|||Hi David
So if I bought the developer edition I would be legal to build the database
and upload it to our web hosting server?
I purchased visual studio.net so I don't have matrix. Would you recommend I
go that way using MSDN or the developer edition?
Thanks for the FAST feedback!!
Tracie
"David Browne" wrote:

> "Tracie" <Tracie@.discussions.microsoft.com> wrote in message
> news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> applications but don't do the SQL maintenance but do build db (my dba chec
ks
> everything and sets all the permissions, etc). Anyway, a nonprofit has
> asked me to build them a web application to collect and display informatio
n
> nothing too fancy but lots of data and lot of users.
> to build a database but it is going to be collecting and serving the
> information from our web host (they've agreed to the extra cost for a web
> host providing SQL), we aren't keeping a local version of the records. So
I
> just need SQL to build the db and upload it to our web host. My dba said
> try access but it only allows 5 concurrent connections. I've heard of MyS
ql
> or something but since I am somewhat familiar with the basics of SQL was
> hoping there was some option for me. They don't need to do analysis or us
e
> the info other than to display it on web pages. They estimate they have
> 5,000 - 10,000 users who will enter 10 to 20 records each including photos
.
> MSDE is free and is SQLServer. It comes free with many products including
> the free ASP.NET web matrix.
> http://www.asp.net/
> You can buy a $50 copy of SQL Server developer edition.
> http://www.microsoft.com/sql/howtobuy/development.asp
> To get a copy of SQL Enterprise Manager and the rest of the tools.
> David
>
>|||If your company has SQL, and you have a client license, then you can load
the personal edition (from the company CD) to your desktop dev
environment...
(If it were me, I'd get the non-profit to purchase you the Development
Edition, that you keep, for the $50)... It is a great great price, (just
reduced from $500)..
Have fun!...This may the start of a great new thing for you!
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!|||"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:5EE69FF4-4DFF-4DB0-982B-EF3C5BA28896@.microsoft.com...
> Hi David
> So if I bought the developer edition I would be legal to build the
database and upload it to our web hosting server?
The hosting server must have Sql server or MSDE on it.

> I purchased visual studio.net so I don't have matrix. Would you recommend
I go that way using MSDN or the >developer edition?
MSDE comes with visual studio so you have it. In fact you can just download
it now.
http://www.microsoft.com/sql/msde/d...ds/download.asp
David

newbe to SQL2005 & MSDE

HELP!!
having on trouble installing, just gettting everything connected.
(xp sp2)
First i loaded MSDE, then realized i needed the web admin tool to create the db...but can't get the web admin tool to connnect to anything..
so I took a stab at SQL 2005 Std ed beta....loaded fine, but then realized i need another admin tool to create db so I loaded the xpress manager...again, loads fine, but doesnt'connec to any DB..
why is this so difficult for me....SQL Svr v6 was so much easier with enterprise manager!!!
HELP!!
DonDon, what do you mean by "the web admin tool"? The utility that comes with Visual Studio .NET 2005?
Can you explain what you mean by "but doesn't connect to any DB."? Are you receiving any error messages?

NEWBE

I have web forms on my site that store data in an sql dbase.
I have a DATE column that i would like to store each date, that each request
was submitted. The only function that i found to automatically populate that
field was TIMESTAMP... any ideas on how i can autopopulate just the DATE
field?
thanks
sorry if im in the wrong room.
If you want the current date, time you can use GetDate() in
your SQL statement. Or you can use it as a default value.
Depends on what you mean by populate and if it's just for
the creation of a new record, etc.
-Sue
On Wed, 15 Mar 2006 09:17:29 -0800, tony
<tony@.discussions.microsoft.com> wrote:

>I have web forms on my site that store data in an sql dbase.
>I have a DATE column that i would like to store each date, that each request
>was submitted. The only function that i found to automatically populate that
>field was TIMESTAMP... any ideas on how i can autopopulate just the DATE
>field?
>thanks
>sorry if im in the wrong room.

NEWBE

I have web forms on my site that store data in an sql dbase.
I have a DATE column that i would like to store each date, that each request
was submitted. The only function that i found to automatically populate tha
t
field was TIMESTAMP... any ideas on how i can autopopulate just the DATE
field?
thanks
sorry if im in the wrong room.If you want the current date, time you can use GetDate() in
your SQL statement. Or you can use it as a default value.
Depends on what you mean by populate and if it's just for
the creation of a new record, etc.
-Sue
On Wed, 15 Mar 2006 09:17:29 -0800, tony
<tony@.discussions.microsoft.com> wrote:

>I have web forms on my site that store data in an sql dbase.
>I have a DATE column that i would like to store each date, that each reques
t
>was submitted. The only function that i found to automatically populate th
at
>field was TIMESTAMP... any ideas on how i can autopopulate just the DATE
>field?
>thanks
>sorry if im in the wrong room.

Newb question regarding cluster load balancing

Hello to all,
I am currently working on creating a Windows 2003 server cluster (3 nodes)
with the intent that it serve our web app which requires multiple SQL
databases. The question I have is this: How can I configure load balancing
for this? It seems that clustering services only allows 1 of the nodes to
access the DB at any given time (which is logical). If this is true, how
will I be able to leverage the processing power of the other two nodes if
they are idle while the node that is hosting the DB does all the work?
Any help would be appreciated.
Michael
You can install multiple instances of SQL Server on a failover cluster. You
cannot natively load-balance the workload between these multiple instances.
They act as independent SQL servers. SQL Clustering is a failover
technology and does not natively load balance.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Michael Weyant" <mweyant@.themarlincompany.com> wrote in message
news:OshvlPrGGHA.312@.TK2MSFTNGP09.phx.gbl...
> Hello to all,
> I am currently working on creating a Windows 2003 server cluster (3 nodes)
> with the intent that it serve our web app which requires multiple SQL
> databases. The question I have is this: How can I configure load balancing
> for this? It seems that clustering services only allows 1 of the nodes to
> access the DB at any given time (which is logical). If this is true, how
> will I be able to leverage the processing power of the other two nodes if
> they are idle while the node that is hosting the DB does all the work?
> Any help would be appreciated.
> Michael
>
|||Thanks Geoff for the information. I thought as much but hoped otherwise.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:e9dbmVrGGHA.3856@.TK2MSFTNGP12.phx.gbl...
> You can install multiple instances of SQL Server on a failover cluster.
> You cannot natively load-balance the workload between these multiple
> instances. They act as independent SQL servers. SQL Clustering is a
> failover technology and does not natively load balance.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Michael Weyant" <mweyant@.themarlincompany.com> wrote in message
> news:OshvlPrGGHA.312@.TK2MSFTNGP09.phx.gbl...
>