More info on SQL Server 2005 Express problem install

When I run the setup there is a System Configuration Check page. I get 13
successes and 2 warnings. The 2 warnings are:
Minimum hardware requirement - there is about 37GB free space, 512MB memory,
an Intel Pentium 4 2.4GHz CPU.
IIS Feature requirement - says not installed. Is IIS REQUIRED? Help says
some features may be disabled - that's all.
Then after going through wizard it complained that the SQL Server native
client wasn't available - so ~I will try to download and install that
separately.
Then I get error SQL Server database Services - setup failed. Refer to
setup log - where is that?
There are lots of log files in c:\Program Files\Microsoft SQL Server
subdirectories.
Help please. This is proving a lot harder than I imagined.
AngusI was installing SQL Server 2005 Express Advanced and gave up on that and
installed just standard SQL Server 2005 Express - that worked without a
hitch.
"Angus" <nospam@.gmail.com> wrote in message
news:#mrYry7kHHA.680@.TK2MSFTNGP06.phx.gbl...
> When I run the setup there is a System Configuration Check page. I get 13
> successes and 2 warnings. The 2 warnings are:
> Minimum hardware requirement - there is about 37GB free space, 512MB
memory,
> an Intel Pentium 4 2.4GHz CPU.
> IIS Feature requirement - says not installed. Is IIS REQUIRED? Help says
> some features may be disabled - that's all.
> Then after going through wizard it complained that the SQL Server native
> client wasn't available - so ~I will try to download and install that
> separately.
> Then I get error SQL Server database Services - setup failed. Refer to
> setup log - where is that?
> There are lots of log files in c:\Program Files\Microsoft SQL Server
> subdirectories.
> Help please. This is proving a lot harder than I imagined.
> Angus
>
>|||Hi Angus
"Angus" wrote:
> I was installing SQL Server 2005 Express Advanced and gave up on that and
> installed just standard SQL Server 2005 Express - that worked without a
> hitch.
>
The differences are shown at
http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx if you
wanted reporting services then you would need advanced edition and IIS, but
it should not stop the install of the other components. I am wondering if you
installed the toolkit by mistake?
John

More info on SQL Server 2005 Express problem install

When I run the setup there is a System Configuration Check page. I get 13
successes and 2 warnings. The 2 warnings are:
Minimum hardware requirement - there is about 37GB free space, 512MB memory,
an Intel Pentium 4 2.4GHz CPU.
IIS Feature requirement - says not installed. Is IIS REQUIRED? Help says
some features may be disabled - that's all.
Then after going through wizard it complained that the SQL Server native
client wasn't available - so ~I will try to download and install that
separately.
Then I get error SQL Server database Services - setup failed. Refer to
setup log - where is that?
There are lots of log files in c:\Program Files\Microsoft SQL Server
subdirectories.
Help please. This is proving a lot harder than I imagined.
AngusI was installing SQL Server 2005 Express Advanced and gave up on that and
installed just standard SQL Server 2005 Express - that worked without a
hitch.
"Angus" <nospam@.gmail.com> wrote in message
news:#mrYry7kHHA.680@.TK2MSFTNGP06.phx.gbl...
> When I run the setup there is a System Configuration Check page. I get 13
> successes and 2 warnings. The 2 warnings are:
> Minimum hardware requirement - there is about 37GB free space, 512MB
memory,
> an Intel Pentium 4 2.4GHz CPU.
> IIS Feature requirement - says not installed. Is IIS REQUIRED? Help says
> some features may be disabled - that's all.
> Then after going through wizard it complained that the SQL Server native
> client wasn't available - so ~I will try to download and install that
> separately.
> Then I get error SQL Server database Services - setup failed. Refer to
> setup log - where is that?
> There are lots of log files in c:\Program Files\Microsoft SQL Server
> subdirectories.
> Help please. This is proving a lot harder than I imagined.
> Angus
>
>|||Hi Angus
"Angus" wrote:

> I was installing SQL Server 2005 Express Advanced and gave up on that and
> installed just standard SQL Server 2005 Express - that worked without a
> hitch.
>
The differences are shown at
http://msdn.microsoft.com/vstudio/e...re/default.aspx if you
wanted reporting services then you would need advanced edition and IIS, but
it should not stop the install of the other components. I am wondering if yo
u
installed the toolkit by mistake?
John

More Charts.......

I know, I know there are several problems with charts already out
there. I have read them all.... 4 times. I have a report that has a
page header made up of simple labels and the body of the report is made
up of a chart. I am performing the following.
result = rs.Render(reportPath, format, historyID, devinfo, parameters,
Nothing, showHide, Nothing, mimeType, Nothing, Nothing, streamIDs)
For Each streamID In streamIDs
result1 = rs.RenderStream(reportPath, format, _
streamID, Nothing, devinfo, parameters, Nothing, Nothing)
***This is written to the location of the report not neccessarily
***the application. I have tried writing to the application home
***also with no success
Dim stream As System.IO.FileStream = _
System.IO.File.OpenWrite
("C:\Inetpub\wwwroot\ReportsServices\eRisc\" & streamID)
stream.Write(result1, 0, CInt(result1.Length))
stream.Close()
Next
Response.Clear()
***Now how do I display this to the page? I have tried a couple
options.
***Option 1 - This displays the header and a bunch of binary ***output
to the bottom
Response.Write(New
System.Text.UTF8Encoding().GetString(result).Replace("{SessionId}",
rs.SessionHeaderValue.SessionId))
Response.ContentType = "image/JPEG"
Response.BinaryWrite(result1)
***Option 2 - This also displays the header and a bunch of binary
***output to the bottom
Response.ContentType = "image/JPEG"
Response.BinaryWrite(result)
Response.BinaryWrite(result1)
***Option 3 - This displays the header and just a red X for the image.
Response.BinaryWrite(result)I should have added option #4
***Option 4 - This also displays the chart only
Response.ContentType = "image/JPEG"
Response.BinaryWrite(result1)|||First of all, have you considered using URL access for your reports? That
would be the easiest solution.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"UW_Hoops" <kdschmidt@.charter.net> wrote in message
news:1103144483.726468.325490@.f14g2000cwb.googlegroups.com...
>I know, I know there are several problems with charts already out
> there. I have read them all.... 4 times. I have a report that has a
> page header made up of simple labels and the body of the report is made
> up of a chart. I am performing the following.
> result = rs.Render(reportPath, format, historyID, devinfo, parameters,
> Nothing, showHide, Nothing, mimeType, Nothing, Nothing, streamIDs)
> For Each streamID In streamIDs
> result1 = rs.RenderStream(reportPath, format, _
> streamID, Nothing, devinfo, parameters, Nothing, Nothing)
> ***This is written to the location of the report not neccessarily
> ***the application. I have tried writing to the application home
> ***also with no success
> Dim stream As System.IO.FileStream = _
> System.IO.File.OpenWrite
> ("C:\Inetpub\wwwroot\ReportsServices\eRisc\" & streamID)
> stream.Write(result1, 0, CInt(result1.Length))
> stream.Close()
> Next
>
> Response.Clear()
> ***Now how do I display this to the page? I have tried a couple
> options.
> ***Option 1 - This displays the header and a bunch of binary ***output
> to the bottom
> Response.Write(New
> System.Text.UTF8Encoding().GetString(result).Replace("{SessionId}",
> rs.SessionHeaderValue.SessionId))
> Response.ContentType = "image/JPEG"
> Response.BinaryWrite(result1)
> ***Option 2 - This also displays the header and a bunch of binary
> ***output to the bottom
> Response.ContentType = "image/JPEG"
> Response.BinaryWrite(result)
> Response.BinaryWrite(result1)
> ***Option 3 - This displays the header and just a red X for the image.
> Response.BinaryWrite(result)
>

More Blank Page Trouble

I've got a report that is printing a blank page between every page. I've
always set all my margins to zero so I don't experience this problem.
However, on this report, it is a landscape report (11 x 8.5 in), and the
report width is less than 9.5 inches. The margins are set to zero. For some
reason, I'm getting the blank page problem. I think this began to occur when
I added a group.
People have mentioned that I need to see what the printer's printing area
is. I have looked through all the printer properties and they only specify
page size (11 x 8.5). There is nothing specified about the size of the
printing area.
Any ideas?On May 25, 12:16 pm, Liz <L...@.discussions.microsoft.com> wrote:
> I've got a report that is printing a blank page between every page. I've
> always set all my margins to zero so I don't experience this problem.
> However, on this report, it is a landscape report (11 x 8.5 in), and the
> report width is less than 9.5 inches. The margins are set to zero. For some
> reason, I'm getting the blank page problem. I think this began to occur when
> I added a group.
> People have mentioned that I need to see what the printer's printing area
> is. I have looked through all the printer properties and they only specify
> page size (11 x 8.5). There is nothing specified about the size of the
> printing area.
> Any ideas?
If you are having this problem when exporting to Excel, make sure that
if you have multiple table/matrix controls on the report, they are all
the exact same width. If you are exporting to PDF, put two or more
table/matrix controls (that are vertically adjacent) inside rectangle
controls. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Monitoring Tools.

All, I seek your knowldege. I am looking for a monitoring tool that
has the abilility to page and email me should something go wrong with
SQL server. I know of two such tools: 1.) BMC Patrol, and 2.) Quest's
Foglight. I was hoping that some of you have had some experience with
other such tools. Let me know please.

LouisTSQL is also pretty good when
linked with xp_sendmail.

"Louis Frolio" <froliol@.yahoo.com> wrote in message
news:94c28610.0401132001.73fc6a4e@.posting.google.c om...
> All, I seek your knowldege. I am looking for a monitoring tool that
> has the abilility to page and email me should something go wrong with
> SQL server. I know of two such tools: 1.) BMC Patrol, and 2.) Quest's
> Foglight. I was hoping that some of you have had some experience with
> other such tools. Let me know please.
> Louis

Monitoring Database hits

In any asp.net application, whats the simplest way to monitor how many times a page hits the database (opens and closes a connection)?

JontyMC:

In any asp.net application, whats the simplest way to monitor how many times a page hits the database (opens and closes a connection)?

If you are using a data access layer, you can write some code to log when the data is connection/executed. You can log this to a text file, or a database, or any other external data source.

Monitor SQL Agent job in ASP.Net

Hi all,

I have a web page which calls a SQL Agent job to initiate an SSIS package. Is there any way i can monitor the job and detect once it has completed successfully? At present all i can seem to get is the return status of whether the job has started or not.

Any help would be most appreciated,

Many thanks in advance.

Grant

You could query the sysjobhistory table. When steps complete, rows get written to this table. You could probably access this via SMO as well, I haven't checked. There is an instance_id which will allow you to track your specific instance, assuming you get that as a token when starting. It may depend on how you are doing this, T-SQL or SMO, I haven't looked vbery far into this, but start with sysjobhistory.

Money in SQL and ASP.NET

Hi,
I'm having some trouble with my asp.net page and my sql database. What I'm trying to do is allow the user to upload an number to the database, the number is a money amount like 2.00 (￡2.00) or 20.00(￡20.00). I've tried using money and smallmoney datatypes but the numbers usually end up looking like this in the database...
I enter 2.00 and in the database it looks like 2.00000, and even if I enter the information directly into the database I get the same results. I'm not going to be using big numbers with lots of decimal places like this 1000,000,0000. Can anyone help me? All I want is to know what to set the value to on my aspx page and what setting to set the field to in my database, I'd just like two pound to appear as 2.00. any help would be great.

I'm using Microsoft Visual Web Developer 2005 Express Edition and Microsoft SQL Server 2005 if that helps.

Thanks.

Hi,

The money or smallmoney datatypes are the right ones to use in your case. By design, they have four decimal at the end and you can find relevent infromation related to these two from Books Online. As to your question, you use either of these types in your database to hold your data and when it is time to show your data on your asp.net page, you can format them into what you need. For example, {0,c2} will give you two decimals as you want. In GridView:

<asp:BoundField HeaderText="Price/Unit" DataField="UnitPrice" DataFormatString="{0:c2}"HtmlEncode="false"> </asp:BoundField>

Or

<asp:TemplateFieldHeaderText="UnitPrice"><ItemTemplate><asp:LabelID="Label2"runat="server"Text='<%# Eval("UnitPrice","{0:c2}") %>'></asp:Label></ItemTemplate></asp:TemplateField>|||

Hi,

You don't say what type of controls you're trying to display this in. However, one simple way (that I think you can apply to any text box or label control) is this:

TextBox1.Text = (512.23).ToString("c")

If you need to set the page to a different currency than your own, one way is to set the UICulture of the page directive:

<%@. Page Language="VB" AutoEventWireup="false" UICulture="en-GB" CodeFile="Default4.aspx.vb" Inherits="Default4" %>

You can also set this in the web.config file (under globalization)

How the numbers are stored in SQL aren't relevant to how they'll be displayed - as you've discovered!

Hope this helps.

Paul

money datatype

i have money a datatype in my table and it allows null
value. If i try to enter a null value from my asp page i
am getting error... what i need to do on my sql server
table so it does not error me out. i think, it has
something to do with precision and scale... but I don't
know what.
ERROR:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
Incorrect syntax near ','.
ThanksCould you display the string that you are constructing in your application?
Look at this string when the money column is null. I am sure you will know
what's causing the problem. It just looks like you are concatenating
something with NULL and the whole thing becomes NULL.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"eren" <oeren@.calcoastcu.org> wrote in message
news:004c01c37d37$d3bd55e0$a401280a@.phx.gbl...
i have money a datatype in my table and it allows null
value. If i try to enter a null value from my asp page i
am getting error... what i need to do on my sql server
table so it does not error me out. i think, it has
something to do with precision and scale... but I don't
know what.
ERROR:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
Incorrect syntax near ','.
Thanks|||This looks like a syntax error in the statement generated by the asp page.
Verify that the statement is correct and that nulls are handled correctly by
the asp code generating the statement.
Shaun
"eren" <oeren@.calcoastcu.org> wrote in message
news:004c01c37d37$d3bd55e0$a401280a@.phx.gbl...
> i have money a datatype in my table and it allows null
> value. If i try to enter a null value from my asp page i
> am getting error... what i need to do on my sql server
> table so it does not error me out. i think, it has
> something to do with precision and scale... but I don't
> know what.
> ERROR:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
> Incorrect syntax near ','.
> Thanks