Database

Windows PowerShell Failed error while installing SQL Server 2008 Express Advanced !

10-Jan-09 2:44

You're welcome Smile | :)

The need to optimize rises from a bad design.My articles[^]

Mohammad Dayyan10-Jan-09 1:49

Mohammad Dayyan

10-Jan-09 1:49

I am attempting to install "SQL Server 2008 Express with Advanced Services".
I downloaded this file "SQLEXPRADV_x86_ENU.exe" and consistently get an error in the "System Support Rules" window that indicates that the Windows PowerShell Failed.

It doesn't say how it failed or why it failed - it just failed.

How do I get past this problem?

Thank you

Re: Windows PowerShell Failed error while installing SQL Server 2008 Express Advanced !

Wendelius10-Jan-09 2:12

Re: Windows PowerShell Failed error while installing SQL Server 2008 Express Advanced !

10-Jan-09 2:12

You must install PowerShell first. This is described in the download page:

InstructionsNote: You must have administrative rights on the computer to install SQL Server Express.
We recommended that you read the Release Notes and Readme before installing SQL Server Express with Advance Services.
Step 1: Download and install Microsoft .Net Framework 3.5 SP1. 
Step 2: Download and install Windows Installer 4.5.
Step 3: Download and install Windows PowerShell 1.0. ...

Refer to http://www.microsoft.com/downloads/details.aspx?FamilyId=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en[^]

The need to optimize rises from a bad design.My articles[^]

Mohammad Dayyan10-Jan-09 2:18

Mohammad Dayyan

10-Jan-09 2:18

Step 1 : I've done it.
Step 2 : I've done it.
Step 3 : I must do it Blush | :O

Re: Windows PowerShell Failed error while installing SQL Server 2008 Express Advanced !

Wendelius10-Jan-09 2:20

Re: Windows PowerShell Failed error while installing SQL Server 2008 Express Advanced !

10-Jan-09 2:20

It'll help Smile | :)

The need to optimize rises from a bad design.My articles[^]

Mohammad Dayyan10-Jan-09 2:30

Mohammad Dayyan

10-Jan-09 2:30

Oh no, Windows PowerShell 1.0 English-Language Installation Package for Windows XP (KB926139) needs Validation Frown | :(

Re: Windows PowerShell Failed error while installing SQL Server 2008 Express Advanced !

Wendelius10-Jan-09 2:47

10-Jan-09 2:47

Did the Sql Server installation give you that error? Also did you go through all the links provided in download details page:

Note: For help on installing Windows Powershell 1.0 see the following KB articles:
926139: English PowerShell 1.0 for Windows
926140: Localized PowerShell 1.0 for Windows XP and Windows 2003
926141: Multilanguage User Interface for PowerShell 1.0 for Windows XP and Windows 2003
928439: PowerShell 1.0 for Vista (includes all languages)

The need to optimize rises from a bad design.My articles[^]

database tutorials

staticv9-Jan-09 21:53

staticv

9-Jan-09 21:53

hey can somebody suggest me any good sites with databases tutorials. i don't know anything about them. I don't know how they work, and what are tables, primary keys, tuples etc.

so i want to know about how databases work before getting into any sort of ms sql, mysql, oracle etc...

if you can recommend any book i'll appreciate it. by the way i'll be using ms sql server 2005 express edition, if that helps suggesting

ty

Top Web Hosting Providers[^]

Do, or do not. There is no 'try'.

Wendelius9-Jan-09 22:04

9-Jan-09 22:04

Don't have any tutorial sites in mind, but concerning the books I would recommend these at least:
- Fundamentals of Database Systems, Elmasri/Navathe[^]
- Introduction to Database Systems, C.J. Date[^]

The need to optimize rises from a bad design.My articles[^]

User 171649210-Jan-09 0:46

User 1716492

10-Jan-09 0:46

SQL Course Here[^]
And Here[^]
And, just for your info, some free cheat sheets Here[^].

modified 1-Aug-19 21:02pm.

staticv10-Jan-09 2:48

staticv

10-Jan-09 2:48

didn't you read my post? i asked of databases tutorials not sql, although it doesn't matters if they are also teaching what are databases besides sql

Top Web Hosting Providers[^]

Do, or do not. There is no 'try'.

User 171649210-Jan-09 3:22

User 1716492

10-Jan-09 3:22

Instead of complaining about the sources I gave, why on earth didn't you just do a google search. It really isn't that hard unless nobody has taken the trouble to teach you how to "Google" Mad | :mad:

To save you the trouble of finding somebody to teach you how to Google, just click this link and Google will return a list of web sites for you to investigate. "Database Tutorials"[^]

Relational Database Theory was listed on the second reference I gave. Perhaps it is you who should learn to read Mad | :mad:

modified 1-Aug-19 21:02pm.

SQL Server 2005 & .MDF Files

staticv10-Jan-09 4:50

staticv

10-Jan-09 4:50

sorry didn't meant to be rude, and btw i searched for it on the google and whatever sources you gave aren't what i was looking for.

but thanks Frown | :(

Top Web Hosting Providers[^]

Do, or do not. There is no 'try'.

Unsy9-Jan-09 13:16

Unsy

9-Jan-09 13:16

Hi everybody.

I'm more of a c# kinda guy so not all that well up with the hard core sql stuff.

The problem I have is I have recently uninstalled all instances of SQL Server off my machine. Then I installed SQL Server 2005, and found that my web applications which relied on SQL express stopped working D'Oh! | :doh:

So I went to microsoft, and downloaded Express 2005 which did not do the trick. (it tells me it cant start up a user instance)
Anyhoo, this upset me somewhat, and as much as I play about with permissions and settings for express I just can't get it working. So, I think it would be better to ship all my .MDF files into real sql server which would be better anyway, but I cant find how to do this...

Please can somebody help???? Is it actually possible???

Thanks in advance. (sorry about the rambling story...)

Re: SQL Server 2005 & .MDF Files

Wendelius9-Jan-09 20:42

Re: SQL Server 2005 & .MDF Files

9-Jan-09 20:42

Hi,

Unsy wrote:
it tells me it cant start up a user instance

Have you had a look ath this: http://msdn.microsoft.com/en-us/library/ms143684(SQL.90).aspx[^]. If I remember correctly, user instanes aren't allowed by default, so you may need to use sp_configure to change the setting.

Unsy wrote:
, I think it would be better to ship all my .MDF files into real sql server which would be better anyway, but I cant find how to do this...

That's possible. Basically SQL Server Standard and Express Editions have the same codebase. Express has just some limitations.

I'm just wondering why you use user instances. User instance is run in the users account who makes the connection. You could also use normal instance and have the database running all the time and your web application could connect to that. It could make things simpler (administration, backups etc)

Mika

The need to optimize rises from a bad design.My articles[^]

Unsy10-Jan-09 13:49

Unsy

10-Jan-09 13:49

Hi Mika

Thank you for your help. I have fixed my problem by simply attaching the MDF files to SQL 2005 which gives me the usual SQL server control and its on constantly.

Thanks again... Big Grin | :-D

Re: SQL Server 2005 & .MDF Files

Wendelius10-Jan-09 20:48

How to populate a datagrid?

10-Jan-09 20:48

You're welcome Smile | :)

The need to optimize rises from a bad design.My articles[^]

enipla9-Jan-09 6:54

9-Jan-09 6:54

This should be simple, but I'm stuck.

I'm trying to use an SqlDataReader to populate a datagrid, but I get an error saying the reader does not produce a value.

But it does. I can wite the values to the console with this code

While reader.Read()
 Console.WriteLine(String.Format("{0}, {1}", _
 reader(0), reader(1)))
End While

The reader DOES produce values.

This code is where I ge the "reader does not produce a value"-

reader.Read()
DataGridView1.DataSource = PermitsPlusDataSet.ADR_BASE.Load(reader)

What do I need to do to get the DataGrid to recognize the values in the reader?

Thanks

Wendelius9-Jan-09 8:13

9-Jan-09 8:13

What happens if you take out the reader.Read() row. SqlDataReader is a forward only stream, so if you read the rows, the load method is unable to rewind to the start of the stream.

The need to optimize rises from a bad design.My articles[^]

enipla9-Jan-09 8:36

9-Jan-09 8:36

Thanks, but same error when I remove reader.read()

"Expersion does not produce a value"

Wendelius9-Jan-09 8:50

9-Jan-09 8:50

The problem is most likely in the reader or the datatable (ADR_BASE) which is filled using the reader. I suspect that this has nothing to do with the DataGridView. The problem is reported on that row because on the same code row you Load the datatable and also assign the datasource.

However, could you post the code before DataGridView1.DataSource = PermitsPlusDataSet.ADR_BASE.Load(reader). It may reveal the source of the problem.

The need to optimize rises from a bad design.My articles[^]

enipla9-Jan-09 8:57

9-Jan-09 8:57

You bet -

Dim queryString As String = "SELECT * FROM dbo.ADR_BASE;"

Using connection As New SqlConnection("Data Source=DEVBOX;Initial Catalog=PermitsPlus;Persist Security Info=True;User ID=*****;Password=*****")

    Dim command As New SqlCommand(queryString, connection)
    connection.Open()

    Dim reader As SqlDataReader = command.ExecuteReader()

    DataGridView1.DataSource = PermitsPlusDataSet.ADR_BASE.Load(reader)

I also checked to see if the reader has rows and it does.

Thanks, this is driving me nuts.

Wendelius9-Jan-09 9:13

9-Jan-09 9:13

Okay,

At a glance I don't see anything special, but since the datatable is already existsng, perhaps it's schema is incompatible. What if you try the following (there may be typos):

Dim queryString As String = "SELECT * FROM dbo.ADR_BASE;"
Using connection As New SqlConnection("Data Source=DEVBOX;Initial Catalog=PermitsPlus;Persist Security Info=True;User ID=*****;Password=*****")
   Dim command As New SqlCommand(queryString, connection)
   connection.Open()
   Dim reader As SqlDataReader = command.ExecuteReader()
   Dim tempTable As new System.Data.DataTable("ADR_BASE")
   tempTable.Load(reader)
   DataGridView1.DataSource = tempTable
   'PermitsPlusDataSet.ADR_BASE.Load(reader)
   'DataGridView1.DataSource = PermitsPlusDataSet.ADR_BASE.Load(reader)

do you still have error and if you do, does it occur on the Load row?

The need to optimize rises from a bad design.My articles[^]

enipla9-Jan-09 9:29