Problem of MSDE 2000 Release A Installation

Hi,
I'm new user for MSDE 2000 Release A.
Recently i have downloading MSDE2000A.exe and extract the MSDE 2000 Release
A installation files under folder name MSDERelA.
I have read thrg the document but still failed to install a new instance of
Desktop Engine for win XP .
Command Prompt:
C:\MSDERelA\Setup>SAPWD="xxxxx"
'SAPWD' is not recognized as an internal or external command,
operable program or batch file.
I think i'm missed interpreting the installation way.
Can anybody explain wht's the meaning of the below statement? Where can i
find
Windows Authentication Mode?
......To install a default instance configured to use Windows Authentication
Mode, execute: ..........
Appreciating any command suggestion for the above.
Thanks.
Regards
Chris
Try:
setup /sapwd xxxx
or put
[Options]
sapwd=xxxx
in setup.ini
SQL Server has multiple layers of security. The first one determines who can
talk to SQL Server (regardless of any attached databases). Windows
Authentication, the new default, lets anyone with a Windows login talk to
SQL Server. The old method, called SQL Server Authentication, requires a
user name and password instead. There exists Mixed Mode Authentication,
which will allow both, for instance in case you want to allow some user over
the network to access some parts of a database, you first have to allow him
to talk to SQL Server. Windows Authentication is the recommended mode,
unless you have a reason to allow login by name and password.
I'm rather new to all this, so some things I've told you might be wrong.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:93E4793E-ACAA-4AE1-B0DE-B0C341B76111@.microsoft.com...
> Hi,
> I'm new user for MSDE 2000 Release A.
> Recently i have downloading MSDE2000A.exe and extract the MSDE 2000
> Release
> A installation files under folder name MSDERelA.
> I have read thrg the document but still failed to install a new instance
> of
> Desktop Engine for win XP .
> Command Prompt:
> C:\MSDERelA\Setup>SAPWD="xxxxx"
> 'SAPWD' is not recognized as an internal or external command,
> operable program or batch file.
> I think i'm missed interpreting the installation way.
> Can anybody explain wht's the meaning of the below statement? Where can i
> find
> Windows Authentication Mode?
> .....To install a default instance configured to use Windows
> Authentication
> Mode, execute: ..........
> Appreciating any command suggestion for the above.
> Thanks.
> Regards
> Chris
>
>
>
>
>
|||Thanks for the explaination. I have tried again with the command-
C:\MSDERelA\Setup>Setup/ SAPWD xxxxx
C:\MSDERelA\Setup>
System Prompt msg "pls go to control panel to install &configure your sys
component". Any idea what does it mean?
Below are the files in folder MSDERelA:
-- folder Msi, folder Setup (sql window installer pcks/patches),
autorun.txt, license.txt, ReadmeMSDE2000A.htm, setup.exe, setup.rll &
sqlresld.dll
Did i wrote a command to a wrong file?
Anybody can help to suggest a new command?
Thanks
Chris
"Paul Pedersen" wrote:

> Try:
> setup /sapwd xxxx
> or put
> [Options]
> sapwd=xxxx
> in setup.ini
>
> SQL Server has multiple layers of security. The first one determines who can
> talk to SQL Server (regardless of any attached databases). Windows
> Authentication, the new default, lets anyone with a Windows login talk to
> SQL Server. The old method, called SQL Server Authentication, requires a
> user name and password instead. There exists Mixed Mode Authentication,
> which will allow both, for instance in case you want to allow some user over
> the network to access some parts of a database, you first have to allow him
> to talk to SQL Server. Windows Authentication is the recommended mode,
> unless you have a reason to allow login by name and password.
> I'm rather new to all this, so some things I've told you might be wrong.
>
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:93E4793E-ACAA-4AE1-B0DE-B0C341B76111@.microsoft.com...
>
>
|||hi,
Paul Pedersen wrote:
> Try:
> setup /sapwd xxxx
>
just a typo...
SAPWD=xxxx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I got that message too. I was running setup from a network drive. When I ran
it from a local drive, it worked.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:4DE8D5D0-9AC8-4837-8AA6-88DF10BBB921@.microsoft.com...[vbcol=seagreen]
> Thanks for the explaination. I have tried again with the command-
> C:\MSDERelA\Setup>Setup/ SAPWD xxxxx
> C:\MSDERelA\Setup>
> System Prompt msg "pls go to control panel to install &configure your sys
> component". Any idea what does it mean?
> Below are the files in folder MSDERelA:
> -- folder Msi, folder Setup (sql window installer pcks/patches),
> autorun.txt, license.txt, ReadmeMSDE2000A.htm, setup.exe, setup.rll &
> sqlresld.dll
> Did i wrote a command to a wrong file?
> Anybody can help to suggest a new command?
> Thanks
> Chris
> "Paul Pedersen" wrote:
|||Hi,
I ran it from a local drive. Unfortunately, the same msg still being
encounter.
C:\MSDERelA\Setup>Setup SAPWD=" xxxxx"[vbcol=seagreen]
Any hint will be sincerly appreciated..
Regards
Chris
"Paul Pedersen" wrote:

> I got that message too. I was running setup from a network drive. When I ran
> it from a local drive, it worked.
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:4DE8D5D0-9AC8-4837-8AA6-88DF10BBB921@.microsoft.com...
>
>
|||I have no other experience with that error message, but I when I ran an
internet search on the error message phrase, I got several hits. None of
them helped my situation, but maybe they will help yours.
In my case, I think it was something about Setup not finding network drives
or something like that. Does it work if you run setup with no parameters?
When I tried it, I used only
setup.exe /settings settings.ini
and kept all the switches in the ini file.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:DED2A104-30C5-4461-9EB6-9FD44B4DDC5B@.microsoft.com...[vbcol=seagreen]
> Hi,
> I ran it from a local drive. Unfortunately, the same msg still being
> encounter.
> C:\MSDERelA\Setup>Setup SAPWD=" xxxxx"
> Any hint will be sincerly appreciated..
> Regards
> Chris
>
>
> "Paul Pedersen" wrote:
|||hi,
Paul Pedersen wrote:
> In my case, I think it was something about Setup not finding network
> drives or something like that. Does it work if you run setup with no
> parameters? When I tried it, I used only
>
are File and Printer sharing set in your network configuration?
is the Server service running in your control panel->admin tools->services ?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Mine is working OK now, thank you. It's Chris who is still having a problem.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3hoakvFi25ieU1@.individual.net...
> hi,
> Paul Pedersen wrote:
> are File and Printer sharing set in your network configuration?
> is the Server service running in your control panel->admin tools->services
> ?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Hi,
Appreciating your guys help on my case. I tried, althg still failed to
install it. For the case, I’ll thinking to purchase a pc of Visual.net.
have a nice day's.
Regards
Chris
=======
Regards
Chris
"Paul Pedersen" wrote:

> Mine is working OK now, thank you. It's Chris who is still having a problem.
>
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:3hoakvFi25ieU1@.individual.net...
>
>

Problem inserting data into SQL Server 2005 DB from WebForm controls

Hello all,

I am having problems running a stored proc from an aspx.cs file. Basically I want to extract data from webForm controls and create a new record in a DB table. I have watched the "Getting Started" videos on thi site, and the only difference between my code and the code of the demonstrator is the connection string.

My conn string:-dataSrc.ConnectionString =ConfigurationManager.ConnectionStrings["ProjectTblConnString"].ConnectionString;

Demonstrator conn string:-dataSrc.ConnectionString =ConfigurationManager.ConnectionStrings("ProjectTblConnString");

When I debug with the string as shown by the demonstrator the error list reports that ConnectionStrings is a property and I am trying to use it as a mothod,
 which is fair enough, but I am just confused as how it worked for the demonstrator and not myself. When I debug with the code I used above I get no error, but nothing is inserted in the DB.

Also, it looks as if the only class in my aspx.cs file that is actually being executed is PageLoad() - the remainder of the code seems to be ignored. Below is the entired aspx.cs file:-

 
1using System;2using System.Data;3using System.Configuration;4using System.Collections;5using System.Web;6using System.Web.Security;7using System.Web.UI;8using System.Web.UI.WebControls;9using System.Web.UI.WebControls.WebParts;10using System.Web.UI.HtmlControls;1112public partialclass CreateProject : System.Web.UI.Page13{14protected void Page_Load(object sender, EventArgs e)15 {1617if (User.Identity.IsAuthenticated ==false)18 {19 Server.Transfer("Default.aspx");20 }2122if (chkbox_startDate.Checked ==true)23 {24 txtbox_startDate.ReadOnly =true;25 txtbox_startDate.Text = (System.DateTime.Now.ToString());26 }2728 }2930protected void btn_create_Click(object sender, EventArgs e)31 {32//connection string for connecting to SQL Server DB33 SqlDataSource dataSrc =new SqlDataSource();34 dataSrc.ConnectionString = ConfigurationManager.ConnectionStrings["ProjectTblConnString"].ConnectionString;353637//insert data in table using the CreateNewProject stored proc in the DB38 dataSrc.InsertCommandType = SqlDataSourceCommandType.StoredProcedure;39 dataSrc.InsertCommand ="CreateNewProject";40 dataSrc.InsertParameters.Add("Project_Title", txtbox_title.ToString() );41 dataSrc.InsertParameters.Add("Description", txtbox_desc.ToString() );42 dataSrc.InsertParameters.Add("Start_Date", txtbox_startDate.ToString() );43 dataSrc.InsertParameters.Add("Primary_Dev_Lang", list_devLang.ToString() );44 dataSrc.InsertParameters.Add("Dev_Environment", list_devEnv.ToString() );45 dataSrc.InsertParameters.Add("No_Junior_Devs", txtbox_juniorDevs.ToString() );46 dataSrc.InsertParameters.Add("No_Senior_Devs", txtbox_seniorDevs.ToString() );4748int rowsAffected = 0;49try50 {51 rowsAffected = dataSrc.Insert();52 }53catch (Exception ex)54 {55 Server.Transfer(Error.aspx);56 }57finally58 {59 dataSrc =null;60 }6162if (rowsAffected != 1)63 {64 label_confirm.Text ="Error, Contact system admin";65 }66else67 {68 label_confirm.Text ="Success";69 }7071 }//end btn_create7273 //if cancel is clicked set all values back to default74protected void btn_cancel_Click(object sender, EventArgs e)75 {76 txtbox_title.Text ="";77 txtbox_desc.Text ="";78 txtbox_startDate.Text ="";79 txtbox_seniorDevs.Text ="";80 txtbox_juniorDevs.Text ="";81 list_devEnv.SelectedIndex = 0;82 list_devLang.SelectedIndex = 0;83 chkbox_startDate.Checked =true;84 label_confirm.Text ="";85 }8687//if checked the current dateTime is inserted into txtbox88protected void chkbox_startDate_CheckedChanged(object sender, EventArgs e)89 {90if (chkbox_startDate.Checked ==true)91 {92 txtbox_startDate.ReadOnly =true;93 txtbox_startDate.Text = (System.DateTime.Now.ToString());94 }95else96 {97 txtbox_startDate.ReadOnly =false;98 txtbox_startDate.Text ="";99 }100 }//end chkox101102103}//end class
 

Any help anyome can give is greatly appreciated. This is part of my Final Year College Dissertation which is due in 3wks !!!!

Sláinte á chaire,

Seán

Hi,

ConnectionStrings is a property name that returns a collection of connection strings. to get the items in the collection, you will need to use [] instead of () in C#. In VB, () is OK. The is the syntax.

Please check the EnableViewState property for each of the textboxes on your page, to see if they have been set to True. If false, the data in it will get lost when postback.

Also, since you're using a SqlDataSource, if CreateNewProject is a stored procedure, the parameter names should contain a @. prefix. Please check in your database to see if the CreateNewProject stored procedure has been created properly. Also use, such as @.Project_Title as parameter name.

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!

|||

Thanks for the reply Kevin.

As you can probably tell I am a newbie.

I have corrected all the problems you have mentioned, but it looks as if my "Submit" button is not executing any of the code at runtime. Any ideas on this?