Monday, March 19, 2012
Error in sample PrinterDeliveryProvider.cs?
and never sets the Notification.Retry flag. Both seem to contradict the
documentation. Please confirm that the sample is wrong and the
documentation is right.
Thanks,
- SteveThat is true. The documentation is correct. The printer delivery extension
sample should be changed to reflect the documentation.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Stephen Walch" <swalch@.proposion.com> wrote in message
news:OpQ$ZirXEHA.3512@.TK2MSFTNGP12.phx.gbl...
> The Deliver method in the sample returns false if the delivery is
successful
> and never sets the Notification.Retry flag. Both seem to contradict the
> documentation. Please confirm that the sample is wrong and the
> documentation is right.
> Thanks,
> - Steve
>|||One more thing. To make the sample more accurate, I would recommend changing
the retry flag to a success flag, like:
public bool Deliver(Notification notification)
{
bool success = false;
// Set the status of the notification to pending
notification.Status = "Processing...";
try
{
// Build user data
Setting[] userSettings = notification.UserData;
SubscriptionData subscriptionData = new SubscriptionData();
subscriptionData.FromSettings(userSettings);
// Print the report
PrintReport(notification, subscriptionData);
// If delivery is successful return false
success = true;
}
catch (Exception e)
{
// Set the status of the notification if an error occurs
// and attempt retry
notification.Status = "Error: " + e.Message;
success = false;
}
finally
{
// Finally, save the notification information
notification.Save();
}
return success;
}
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Stephen Walch" <swalch@.proposion.com> wrote in message
news:OpQ$ZirXEHA.3512@.TK2MSFTNGP12.phx.gbl...
> The Deliver method in the sample returns false if the delivery is
successful
> and never sets the Notification.Retry flag. Both seem to contradict the
> documentation. Please confirm that the sample is wrong and the
> documentation is right.
> Thanks,
> - Steve
>|||Don't you also want to set the Retry flag?
catch (Exception e)
{
// Set the status of the notification if an error occurs
// and attempt retry
notification.Status = "Error: " + e.Message;
notification.Retry = true;
success = false;
}|||Hi,
During to build "Sample Printer Delivery Extension", the document write:
2.Issue the following command to create the sample delivery extension
Microsoft.Samples.ReportingServices.PrinterDeliverySample.dll.
csc /t:library /out:Microsoft.Samples.ReportingServices.PrinterDelivery.dll
*.cs /r:Microsoft.ReportingServices.Interfaces.dll
During to build "Sample Printer Delivery Extension", the
How should I Implement this command? Please give me advice, thanks for your
time!
Angi|||CSC is the C# compiler which ships with the .Net Framework. It should be
installed on your computer if you installed the .Net Framework v. 1.1.4322.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"angi" <angi@.microsoft.com> wrote in message
news:uCWemPUbEHA.3752@.TK2MSFTNGP12.phx.gbl...
> Hi,
> During to build "Sample Printer Delivery Extension", the document write:
> 2.Issue the following command to create the sample delivery extension
> Microsoft.Samples.ReportingServices.PrinterDeliverySample.dll.
> csc /t:library
/out:Microsoft.Samples.ReportingServices.PrinterDelivery.dll
> *.cs /r:Microsoft.ReportingServices.Interfaces.dll
> During to build "Sample Printer Delivery Extension", the
> How should I Implement this command? Please give me advice, thanks for
your
> time!
> Angi
>|||You can also build it by opening the .SLN file in Visual Stidio.NET 2003.
-Steve
"angi" <angi@.microsoft.com> wrote in message
news:uCWemPUbEHA.3752@.TK2MSFTNGP12.phx.gbl...
> Hi,
> During to build "Sample Printer Delivery Extension", the document write:
> 2.Issue the following command to create the sample delivery extension
> Microsoft.Samples.ReportingServices.PrinterDeliverySample.dll.
> csc /t:library
/out:Microsoft.Samples.ReportingServices.PrinterDelivery.dll
> *.cs /r:Microsoft.ReportingServices.Interfaces.dll
> During to build "Sample Printer Delivery Extension", the
> How should I Implement this command? Please give me advice, thanks for
your
> time!
> Angi
>
Error in sample Northwind?
contain any spaces for if they did I had to write my "SQL" statements a =
little differently.
I was following an exmple and had a SQL statment:
sSQL1 =3D "UPDATE OrderDetails SET Quantity=3D5 WHERE OrderID=3D3 AND =
ProductID=3D2" This is in ASP with =
Server.CreateObject("ADODB.Connection")
Anyway if you look at this statement the table is called OrderDetails. =
But if you go to the tables in the Northwind database in SQL 2000 it is =
shown as Order Details. Note the space.
This is the only table in the Northwind database that conatins a space. =
So what I am wondering is when tables in SQL 2000 contain spaces like =
the above Order Deatails, is the SQL statement as I have written it =
irrelevant? Shouldn't it be:
sSQL1 =3D "UPDATE 'Order Details' SET Quantity=3D5 WHERE OrderID=3D3 AND =
ProductID=3D2"
?
Thanks.
--=20
George Hester
__________________________________
Hi,
Use SQARE brackets [] incase if you have space inbetwen the object names.
sSQL1 = "UPDATE [Order Details] SET Quantity=5 WHERE OrderID=3 AND
ProductID=2"
Thanks
Hari
MCDBA
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:e#lSISoPEHA.2128@.TK2MSFTNGP11.phx.gbl...
When I was doing DAO in Access I made sure that my table names did not
contain any spaces for if they did I had to write my "SQL" statements a
little differently.
I was following an exmple and had a SQL statment:
sSQL1 = "UPDATE OrderDetails SET Quantity=5 WHERE OrderID=3 AND ProductID=2"
This is in ASP with Server.CreateObject("ADODB.Connection")
Anyway if you look at this statement the table is called OrderDetails. But
if you go to the tables in the Northwind database in SQL 2000 it is shown as
Order Details. Note the space.
This is the only table in the Northwind database that conatins a space. So
what I am wondering is when tables in SQL 2000 contain spaces like the above
Order Deatails, is the SQL statement as I have written it irrelevant?
Shouldn't it be:
sSQL1 = "UPDATE 'Order Details' SET Quantity=5 WHERE OrderID=3 AND
ProductID=2"
?
Thanks.
George Hester
__________________________________
|||The ANSI SQL compliant way is to enclose the name inside double-quotes. SQL Server also support square
brackets. I prefer the ANSI SQL Compliant way.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"George Hester" <hesterloli@.hotmail.com> wrote in message news:e%23lSISoPEHA.2128@.TK2MSFTNGP11.phx.gbl...
When I was doing DAO in Access I made sure that my table names did not contain any spaces for if they did I
had to write my "SQL" statements a little differently.
I was following an exmple and had a SQL statment:
sSQL1 = "UPDATE OrderDetails SET Quantity=5 WHERE OrderID=3 AND ProductID=2" This is in ASP with
Server.CreateObject("ADODB.Connection")
Anyway if you look at this statement the table is called OrderDetails. But if you go to the tables in the
Northwind database in SQL 2000 it is shown as Order Details. Note the space.
This is the only table in the Northwind database that conatins a space. So what I am wondering is when tables
in SQL 2000 contain spaces like the above Order Deatails, is the SQL statement as I have written it
irrelevant? Shouldn't it be:
sSQL1 = "UPDATE 'Order Details' SET Quantity=5 WHERE OrderID=3 AND ProductID=2"
?
Thanks.
George Hester
__________________________________
|||OK then it would be:
sSQL1 =3D "UPDATE ""Order Details"" SET Quantity=3D5 WHERE OrderID=3D3 =
AND ProductID=3D2"
for VBScript?
--=20
George Hester
__________________________________
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote =
in message news:e519lOxPEHA.1644@.TK2MSFTNGP09.phx.gbl...
> The ANSI SQL compliant way is to enclose the name inside =
double-quotes. SQL Server also support square
> brackets. I prefer the ANSI SQL Compliant way.
>=20
> --=20
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>=20
>=20
> "George Hester" <hesterloli@.hotmail.com> wrote in message =
news:e%23lSISoPEHA.2128@.TK2MSFTNGP11.phx.gbl...
> When I was doing DAO in Access I made sure that my table names did not =
contain any spaces for if they did I
> had to write my "SQL" statements a little differently.
>=20
> I was following an exmple and had a SQL statment:
>=20
> sSQL1 =3D "UPDATE OrderDetails SET Quantity=3D5 WHERE OrderID=3D3 AND =
ProductID=3D2" This is in ASP with
> Server.CreateObject("ADODB.Connection")
>=20
> Anyway if you look at this statement the table is called OrderDetails. =
But if you go to the tables in the
> Northwind database in SQL 2000 it is shown as Order Details. Note the =
space.
>=20
> This is the only table in the Northwind database that conatins a =
space. So what I am wondering is when tables
> in SQL 2000 contain spaces like the above Order Deatails, is the SQL =
statement as I have written it
> irrelevant? Shouldn't it be:
>=20
> sSQL1 =3D "UPDATE 'Order Details' SET Quantity=3D5 WHERE OrderID=3D3 =
AND ProductID=3D2"
> ?
> Thanks.
>=20
> --=20
> George Hester
> __________________________________
>=20
>
|||Yep. Better yet, always quality the object name with the owner. :-)
UPDATE dbo."Order Details" SET...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"George Hester" <hesterloli@.hotmail.com> wrote in message news:ujt2XRFQEHA.3220@.TK2MSFTNGP09.phx.gbl...
OK then it would be:
sSQL1 = "UPDATE ""Order Details"" SET Quantity=5 WHERE OrderID=3 AND ProductID=2"
for VBScript?
George Hester
__________________________________
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
news:e519lOxPEHA.1644@.TK2MSFTNGP09.phx.gbl...
> The ANSI SQL compliant way is to enclose the name inside double-quotes. SQL Server also support square
> brackets. I prefer the ANSI SQL Compliant way.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "George Hester" <hesterloli@.hotmail.com> wrote in message news:e%23lSISoPEHA.2128@.TK2MSFTNGP11.phx.gbl...
> When I was doing DAO in Access I made sure that my table names did not contain any spaces for if they did I
> had to write my "SQL" statements a little differently.
> I was following an exmple and had a SQL statment:
> sSQL1 = "UPDATE OrderDetails SET Quantity=5 WHERE OrderID=3 AND ProductID=2" This is in ASP with
> Server.CreateObject("ADODB.Connection")
> Anyway if you look at this statement the table is called OrderDetails. But if you go to the tables in the
> Northwind database in SQL 2000 it is shown as Order Details. Note the space.
> This is the only table in the Northwind database that conatins a space. So what I am wondering is when
tables
> in SQL 2000 contain spaces like the above Order Deatails, is the SQL statement as I have written it
> irrelevant? Shouldn't it be:
> sSQL1 = "UPDATE 'Order Details' SET Quantity=5 WHERE OrderID=3 AND ProductID=2"
> ?
> Thanks.
> --
> George Hester
> __________________________________
>
Error in sample Northwind?
I was following an exmple and had a SQL statment:
sSQL1 =3D "UPDATE OrderDetails SET Quantity=3D5 WHERE OrderID=3D3 AND = ProductID=3D2" This is in ASP with = Server.CreateObject("ADODB.Connection")
Anyway if you look at this statement the table is called OrderDetails. = But if you go to the tables in the Northwind database in SQL 2000 it is = shown as Order Details. Note the space.
This is the only table in the Northwind database that conatins a space. = So what I am wondering is when tables in SQL 2000 contain spaces like = the above Order Deatails, is the SQL statement as I have written it = irrelevant? Shouldn't it be:
sSQL1 =3D "UPDATE 'Order Details' SET Quantity=3D5 WHERE OrderID=3D3 AND = ProductID=3D2"
?
Thanks.
-- George Hester
__________________________________Hi,
Use SQARE brackets [] incase if you have space inbetwen the object names.
sSQL1 = "UPDATE [Order Details] SET Quantity=5 WHERE OrderID=3 AND
ProductID=2"
Thanks
Hari
MCDBA
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:e#lSISoPEHA.2128@.TK2MSFTNGP11.phx.gbl...
When I was doing DAO in Access I made sure that my table names did not
contain any spaces for if they did I had to write my "SQL" statements a
little differently.
I was following an exmple and had a SQL statment:
sSQL1 = "UPDATE OrderDetails SET Quantity=5 WHERE OrderID=3 AND ProductID=2"
This is in ASP with Server.CreateObject("ADODB.Connection")
Anyway if you look at this statement the table is called OrderDetails. But
if you go to the tables in the Northwind database in SQL 2000 it is shown as
Order Details. Note the space.
This is the only table in the Northwind database that conatins a space. So
what I am wondering is when tables in SQL 2000 contain spaces like the above
Order Deatails, is the SQL statement as I have written it irrelevant?
Shouldn't it be:
sSQL1 = "UPDATE 'Order Details' SET Quantity=5 WHERE OrderID=3 AND
ProductID=2"
?
Thanks.
--
George Hester
__________________________________|||The ANSI SQL compliant way is to enclose the name inside double-quotes. SQL Server also support square
brackets. I prefer the ANSI SQL Compliant way.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"George Hester" <hesterloli@.hotmail.com> wrote in message news:e%23lSISoPEHA.2128@.TK2MSFTNGP11.phx.gbl...
When I was doing DAO in Access I made sure that my table names did not contain any spaces for if they did I
had to write my "SQL" statements a little differently.
I was following an exmple and had a SQL statment:
sSQL1 = "UPDATE OrderDetails SET Quantity=5 WHERE OrderID=3 AND ProductID=2" This is in ASP with
Server.CreateObject("ADODB.Connection")
Anyway if you look at this statement the table is called OrderDetails. But if you go to the tables in the
Northwind database in SQL 2000 it is shown as Order Details. Note the space.
This is the only table in the Northwind database that conatins a space. So what I am wondering is when tables
in SQL 2000 contain spaces like the above Order Deatails, is the SQL statement as I have written it
irrelevant? Shouldn't it be:
sSQL1 = "UPDATE 'Order Details' SET Quantity=5 WHERE OrderID=3 AND ProductID=2"
?
Thanks.
--
George Hester
__________________________________|||OK then it would be:
sSQL1 =3D "UPDATE ""Order Details"" SET Quantity=3D5 WHERE OrderID=3D3 =AND ProductID=3D2"
for VBScript?
-- George Hester
__________________________________
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote =in message news:e519lOxPEHA.1644@.TK2MSFTNGP09.phx.gbl...
> The ANSI SQL compliant way is to enclose the name inside =double-quotes. SQL Server also support square
> brackets. I prefer the ANSI SQL Compliant way.
> > -- > Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> > > "George Hester" <hesterloli@.hotmail.com> wrote in message =news:e%23lSISoPEHA.2128@.TK2MSFTNGP11.phx.gbl...
> When I was doing DAO in Access I made sure that my table names did not =contain any spaces for if they did I
> had to write my "SQL" statements a little differently.
> > I was following an exmple and had a SQL statment:
> > sSQL1 =3D "UPDATE OrderDetails SET Quantity=3D5 WHERE OrderID=3D3 AND =ProductID=3D2" This is in ASP with
> Server.CreateObject("ADODB.Connection")
> > Anyway if you look at this statement the table is called OrderDetails. = But if you go to the tables in the
> Northwind database in SQL 2000 it is shown as Order Details. Note the =space.
> > This is the only table in the Northwind database that conatins a =space. So what I am wondering is when tables
> in SQL 2000 contain spaces like the above Order Deatails, is the SQL =statement as I have written it
> irrelevant? Shouldn't it be:
> > sSQL1 =3D "UPDATE 'Order Details' SET Quantity=3D5 WHERE OrderID=3D3 =AND ProductID=3D2"
> ?
> Thanks.
> > -- > George Hester
> __________________________________
> >|||Yep. Better yet, always quality the object name with the owner. :-)
UPDATE dbo."Order Details" SET...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"George Hester" <hesterloli@.hotmail.com> wrote in message news:ujt2XRFQEHA.3220@.TK2MSFTNGP09.phx.gbl...
OK then it would be:
sSQL1 = "UPDATE ""Order Details"" SET Quantity=5 WHERE OrderID=3 AND ProductID=2"
for VBScript?
--
George Hester
__________________________________
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
news:e519lOxPEHA.1644@.TK2MSFTNGP09.phx.gbl...
> The ANSI SQL compliant way is to enclose the name inside double-quotes. SQL Server also support square
> brackets. I prefer the ANSI SQL Compliant way.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "George Hester" <hesterloli@.hotmail.com> wrote in message news:e%23lSISoPEHA.2128@.TK2MSFTNGP11.phx.gbl...
> When I was doing DAO in Access I made sure that my table names did not contain any spaces for if they did I
> had to write my "SQL" statements a little differently.
> I was following an exmple and had a SQL statment:
> sSQL1 = "UPDATE OrderDetails SET Quantity=5 WHERE OrderID=3 AND ProductID=2" This is in ASP with
> Server.CreateObject("ADODB.Connection")
> Anyway if you look at this statement the table is called OrderDetails. But if you go to the tables in the
> Northwind database in SQL 2000 it is shown as Order Details. Note the space.
> This is the only table in the Northwind database that conatins a space. So what I am wondering is when
tables
> in SQL 2000 contain spaces like the above Order Deatails, is the SQL statement as I have written it
> irrelevant? Shouldn't it be:
> sSQL1 = "UPDATE 'Order Details' SET Quantity=5 WHERE OrderID=3 AND ProductID=2"
> ?
> Thanks.
> --
> George Hester
> __________________________________
>
Error in sample Northwind?
contain any spaces for if they did I had to write my "SQL" statements a =
little differently.
I was following an exmple and had a SQL statment:
sSQL1 =3D "UPDATE OrderDetails SET Quantity=3D5 WHERE OrderID=3D3 AND =
ProductID=3D2" This is in ASP with =
Server.CreateObject("ADODB.Connection")
Anyway if you look at this statement the table is called OrderDetails. =
But if you go to the tables in the Northwind database in SQL 2000 it is =
shown as Order Details. Note the space.
This is the only table in the Northwind database that conatins a space. =
So what I am wondering is when tables in SQL 2000 contain spaces like =
the above Order Deatails, is the SQL statement as I have written it =
irrelevant? Shouldn't it be:
sSQL1 =3D "UPDATE 'Order Details' SET Quantity=3D5 WHERE OrderID=3D3 AND =
ProductID=3D2"
?
Thanks.
--=20
George Hester
__________________________________Hi,
Use SQARE brackets [] incase if you have space inbetwen the object names
.
sSQL1 = "UPDATE [Order Details] SET Quantity=5 WHERE OrderID=3 AND
ProductID=2"
Thanks
Hari
MCDBA
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:e#lSISoPEHA.2128@.TK2MSFTNGP11.phx.gbl...
When I was doing DAO in Access I made sure that my table names did not
contain any spaces for if they did I had to write my "SQL" statements a
little differently.
I was following an exmple and had a SQL statment:
sSQL1 = "UPDATE OrderDetails SET Quantity=5 WHERE OrderID=3 AND ProductID=2"
This is in ASP with Server.CreateObject("ADODB.Connection")
Anyway if you look at this statement the table is called OrderDetails. But
if you go to the tables in the Northwind database in SQL 2000 it is shown as
Order Details. Note the space.
This is the only table in the Northwind database that conatins a space. So
what I am wondering is when tables in SQL 2000 contain spaces like the above
Order Deatails, is the SQL statement as I have written it irrelevant?
Shouldn't it be:
sSQL1 = "UPDATE 'Order Details' SET Quantity=5 WHERE OrderID=3 AND
ProductID=2"
?
Thanks.
George Hester
__________________________________|||The ANSI SQL compliant way is to enclose the name inside double-quotes. SQL
Server also support square
brackets. I prefer the ANSI SQL Compliant way.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"George Hester" <hesterloli@.hotmail.com> wrote in message news:e%23lSISoPEHA
.2128@.TK2MSFTNGP11.phx.gbl...
When I was doing DAO in Access I made sure that my table names did not conta
in any spaces for if they did I
had to write my "SQL" statements a little differently.
I was following an exmple and had a SQL statment:
sSQL1 = "UPDATE OrderDetails SET Quantity=5 WHERE OrderID=3 AND ProductID=2"
This is in ASP with
Server.CreateObject("ADODB.Connection")
Anyway if you look at this statement the table is called OrderDetails. But
if you go to the tables in the
Northwind database in SQL 2000 it is shown as Order Details. Note the space
.
This is the only table in the Northwind database that conatins a space. So
what I am wondering is when tables
in SQL 2000 contain spaces like the above Order Deatails, is the SQL stateme
nt as I have written it
irrelevant? Shouldn't it be:
sSQL1 = "UPDATE 'Order Details' SET Quantity=5 WHERE OrderID=3 AND ProductID
=2"
?
Thanks.
George Hester
__________________________________|||OK then it would be:
sSQL1 =3D "UPDATE ""Order Details"" SET Quantity=3D5 WHERE OrderID=3D3 =
AND ProductID=3D2"
for VBScript?
--=20
George Hester
__________________________________
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote =
in message news:e519lOxPEHA.1644@.TK2MSFTNGP09.phx.gbl...
> The ANSI SQL compliant way is to enclose the name inside =
double-quotes. SQL Server also support square
> brackets. I prefer the ANSI SQL Compliant way.
>=20
> --=20
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>=20
>=20
> "George Hester" <hesterloli@.hotmail.com> wrote in message =
news:e%23lSISoPEHA.2128@.TK2MSFTNGP11.phx.gbl...
> When I was doing DAO in Access I made sure that my table names did not =
contain any spaces for if they did I
> had to write my "SQL" statements a little differently.
>=20
> I was following an exmple and had a SQL statment:
>=20
> sSQL1 =3D "UPDATE OrderDetails SET Quantity=3D5 WHERE OrderID=3D3 AND =
ProductID=3D2" This is in ASP with
> Server.CreateObject("ADODB.Connection")
>=20
> Anyway if you look at this statement the table is called OrderDetails. =
But if you go to the tables in the
> Northwind database in SQL 2000 it is shown as Order Details. Note the =
space.
>=20
> This is the only table in the Northwind database that conatins a =
space. So what I am wondering is when tables
> in SQL 2000 contain spaces like the above Order Deatails, is the SQL =
statement as I have written it
> irrelevant? Shouldn't it be:
>=20
> sSQL1 =3D "UPDATE 'Order Details' SET Quantity=3D5 WHERE OrderID=3D3 =
AND ProductID=3D2"
> ?
> Thanks.
>=20
> --=20
> George Hester
> __________________________________
>=20
>|||Yep. Better yet, always quality the object name with the owner. :-)
UPDATE dbo."Order Details" SET...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"George Hester" <hesterloli@.hotmail.com> wrote in message news:ujt2XRFQEHA.3
220@.TK2MSFTNGP09.phx.gbl...
OK then it would be:
sSQL1 = "UPDATE ""Order Details"" SET Quantity=5 WHERE OrderID=3 AND Product
ID=2"
for VBScript?
George Hester
__________________________________
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message
news:e519lOxPEHA.1644@.TK2MSFTNGP09.phx.gbl...
> The ANSI SQL compliant way is to enclose the name inside double-quotes. SQ
L Server also support square
> brackets. I prefer the ANSI SQL Compliant way.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "George Hester" <hesterloli@.hotmail.com> wrote in message news:e%23lSISoPE
HA.2128@.TK2MSFTNGP11.phx.gbl...
> When I was doing DAO in Access I made sure that my table names did not con
tain any spaces for if they did I
> had to write my "SQL" statements a little differently.
> I was following an exmple and had a SQL statment:
> sSQL1 = "UPDATE OrderDetails SET Quantity=5 WHERE OrderID=3 AND ProductID=
2" This is in ASP with
> Server.CreateObject("ADODB.Connection")
> Anyway if you look at this statement the table is called OrderDetails. Bu
t if you go to the tables in the
> Northwind database in SQL 2000 it is shown as Order Details. Note the spa
ce.
> This is the only table in the Northwind database that conatins a space. So what I
am wondering is when
tables
> in SQL 2000 contain spaces like the above Order Deatails, is the SQL state
ment as I have written it
> irrelevant? Shouldn't it be:
> sSQL1 = "UPDATE 'Order Details' SET Quantity=5 WHERE OrderID=3 AND Product
ID=2"
> ?
> Thanks.
> --
> George Hester
> __________________________________
>
Sunday, March 11, 2012
Error in metadata manager processing sample database/cubes
I've just installed SQL Server 2005 with Analysis Services and the sample AdventureWorks databases. When I try to process the database via SQL Server Management Studio, I get the following error - see below. I did check the xml file referenced by the name of the error and I do see the dimension listed Order Date key but not any attribute called Name of Date. Is there any workaround to enable processing of the database and cubes?
I did bump up to Sp1 and this did not fix my problem. I also tried installing the samples from the downloads section of microsoft.com. Alas, no success.
Any help appreciated,
Mairead
Errors in the metadata manager. The dimension with ID of 'Order Date Key - Dim Time', Name of 'Date' referenced by the 'Adventure Works' cube, does not exist.
Errors in the metadata manager. An error occurred when loading the Adventure Works cube, from the file, '\\?\D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Adventure Works DW.2.cub.xml'.
(Microsoft.AnalysisServices)
Program Location:
at Microsoft.AnalysisServices.XmlaClient.CheckForException(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Discover(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.Server.Refresh(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.Server.SendRefresh(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.MajorObject.Refresh()
at Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId)
at Microsoft.AnalysisServices.Server.Connect(String connectionString)
at Microsoft.SqlServer.Management.SqlMgmt.CDataContainer.Init(XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.CDataContainer.Init(XmlDocument doc, IServiceProvider site)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDataContainer(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()
Here is simple way out of your situation
1. Stop Analysis Service.
2. Delete everything in your D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db folder.
3. Start the service
4. Re-deploy your sample project.
Hope that helps
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Edward, I finally did get everything working again by completely uninstalling/reinstalling and redeploying the samples again. I did try your workaround but still could not get the samples processed successfully.
Mairead
Friday, March 9, 2012
Error in Merging partitions in AS 2005 Sample (Adventure Works DW)
When I want to merge two partitions in "Sales Orders" MeasureGroup in Adventure Works DW in Microsoft SQL Server Management Studio, an error happened like this:
Errors in the OLAP storage engine: The attribute key cannot be found: Table: FactSalesSummary, Column: SalesOrderNumber, Value: SO43659.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)
Who can tell me how to resolve it?
Any response is appreciated.
Thanks^_^
Winnie
You should change Error configuration to what you had during original processing of partitions.
Looks like you had error configuration settings to ignore some of the errors.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Thank you! Edward
I have changed the Error configuration to ignore KeyNotFound error. But the second error:
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)
still exist.
I have tried to change all the availible items in the Error configuration, but the error can not disappear.
What shoud I modify?
Thanks^_^
Winnie
|||There is a bug in the product. It pertains to ROLAP dimensions and the merge partition operation. From the error message about the missing attribute key it sounds very much like you're hitting that problem. If this scenario is important to you - please request a QFE through our CSS folks and we'll take it from there...Error in Merging partitions in AS 2005 Sample (Adventure Works DW)
When I want to merge two partitions in "Sales Orders" MeasureGroup in Adventure Works DW in Microsoft SQL Server Management Studio, an error happened like this:
Errors in the OLAP storage engine: The attribute key cannot be found: Table: FactSalesSummary, Column: SalesOrderNumber, Value: SO43659.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)
Who can tell me how to resolve it?
Any response is appreciated.
Thanks^_^
Winnie
You should change Error configuration to what you had during original processing of partitions.
Looks like you had error configuration settings to ignore some of the errors.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Thank you! Edward
I have changed the Error configuration to ignore KeyNotFound error. But the second error:
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)
still exist.
I have tried to change all the availible items in the Error configuration, but the error can not disappear.
What shoud I modify?
Thanks^_^
Winnie
|||There is a bug in the product. It pertains to ROLAP dimensions and the merge partition operation. From the error message about the missing attribute key it sounds very much like you're hitting that problem. If this scenario is important to you - please request a QFE through our CSS folks and we'll take it from there...Error in Merging partitions in AS 2005 Sample (Adventure Works DW)
When I want to merge two partitions in "Sales Orders" MeasureGroup in Adventure Works DW in Microsoft SQL Server Management Studio, an error happened like this:
Errors in the OLAP storage engine: The attribute key cannot be found: Table: FactSalesSummary, Column: SalesOrderNumber, Value: SO43659.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)
Who can tell me how to resolve it?
Any response is appreciated.
Thanks^_^
Winnie
You should change Error configuration to what you had during original processing of partitions.
Looks like you had error configuration settings to ignore some of the errors.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Thank you! Edward
I have changed the Error configuration to ignore KeyNotFound error. But the second error:
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
(Microsoft.AnalysisServices)
still exist.
I have tried to change all the availible items in the Error configuration, but the error can not disappear.
What shoud I modify?
Thanks^_^
Winnie
|||There is a bug in the product. It pertains to ROLAP dimensions and the merge partition operation. From the error message about the missing attribute key it sounds very much like you're hitting that problem. If this scenario is important to you - please request a QFE through our CSS folks and we'll take it from there...Wednesday, March 7, 2012
Error in FormAuthentication
extension. Everything works fine except the following:
(1) After i registerd the user ,i cannot log into the Report Manager.It is
saying like
"The request failed with HTTP status 401: Access Denied."
(2) But with the same username and password i am entering into the
Reportserver
I set the credentials in Reference.cs as
public ReportingService()
{
this.Credentials = new
System.Net.NetworkCredential("username","password","Domain");
this.Url = "http://localhost/reportserver/reportservice.asmx";
}
And the logfile saying like
CantCommunicateWithReportServerException: Unable to communicate with report
server. Please verify that the report server is operational.
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()
aspnet_wp!ui!134!2/22/2005-11:18:01:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
could anybody tell me in which file possibly wrong?
Thanks,
simmiIf you are using Forms Authentication you have to log on using LogOnUser
(see my post to your other post).
--
Adrian M.
MCP
"simmi" <simmi@.discussions.microsoft.com> wrote in message
news:8DEC1F92-5E7B-445B-B07C-79A20F0A02BD@.microsoft.com...
> I'm using Microsoft Forms Authentication sample to implement custom
> security
> extension. Everything works fine except the following:
> (1) After i registerd the user ,i cannot log into the Report Manager.It is
> saying like
> "The request failed with HTTP status 401: Access Denied."
> (2) But with the same username and password i am entering into the
> Reportserver
> I set the credentials in Reference.cs as
> public ReportingService()
> {
> this.Credentials = new
> System.Net.NetworkCredential("username","password","Domain");
> this.Url = "http://localhost/reportserver/reportservice.asmx";
> }
>
> And the logfile saying like
> CantCommunicateWithReportServerException: Unable to communicate with
> report
> server. Please verify that the report server is operational.
> at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> methodname)
> at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level)
> at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain()
> aspnet_wp!ui!134!2/22/2005-11:18:01:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)
> at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)
>
> could anybody tell me in which file possibly wrong?
> Thanks,
> simmi
>
Sunday, February 19, 2012
error in as with rs samples
I'm using the sample RS code for my cube. I just copied
from the sample code and replaced the cube name with my
cube name ...its working fine with the code given by them
and for microsoft's reports. but when i run my reports its
giving an error msg like ... The expression for the
query 'Selection' contains an error: [BC30648] String
constants must end with a double quote.
here selection is my dataset name... i'm running this thru
report designer in vs.net... could any one tell me wht's
my wrong ...
=IIF(Parameters!pParamIn.Value="", "WITH MEMBER
MEASURES.DIMNAME AS 'NULL' MEMBER MEASURES.UNAME AS 'NULL'
MEMBER MEASURES.PUNAME AS 'NULL' MEMBER MEASURES.LABEL
AS 'NULL' MEMBER MEASURES.SYMBOL AS 'NULL' SELECT
{MEASURES.DIMNAME, MEASURES.UNAME, MEASURES.LABEL,
MEASURES.SYMBOL, MEASURES.PUNAME} ON 0 FROM [Purchase
Order]", "WITH MEMBER MEASURES.DIMNAME AS '" & Parameters!
pMember.Value & ".DIMENSION.NAME' MEMBER MEASURES.UNAME
AS '" & Parameters!pMember.Value
& ".DIMENSION.CURRENTMEMBER.UNIQUENAME' MEMBER
MEASURES.PUNAME AS '" & Parameters!pMember.Value
& ".DIMENSION.CURRENTMEMBER.PARENT.UNIQUENAME' MEMBER
MEASURES.SYMBOL AS 'IIF(" & Parameters!pMember.Value
& ".DIMENSION.CURRENTMEMBER IS " & Parameters!
pMember.Value & ", 1, IIF(COUNT(INTERSECT({" & Parameters!
pMember.Value & ".DIMENSION.CURRENTMEMBER}, {" &
Parameters!pMember.Value & ".SIBLINGS}))=1, 2, 3))' MEMBER
MEASURES.LABEL AS '" & Parameters!pMember.Value
& ".DIMENSION.CURRENTMEMBER.NAME' SELECT
{MEASURES.DIMNAME, MEASURES.UNAME, MEASURES.LABEL,
MEASURES.SYMBOL, MEASURES.PUNAME} ON 0, DRILLDOWNMEMBER({"
& Parameters!pMember.Value & ".SIBLINGS}, {" & Parameters!
pMember.Value & "}) ON 1 FROM [Purchase Order]")
Thanks in advance..You have a typo in the query around one of the IIFs: MEASURES.SYMBOL AS
'IIF(" & Parameters!pMember.Value
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"alex" <anonymous@.discussions.microsoft.com> wrote in message
news:520501c48089$bbaa46b0$a401280a@.phx.gbl...
> hi,
> I'm using the sample RS code for my cube. I just copied
> from the sample code and replaced the cube name with my
> cube name ...its working fine with the code given by them
> and for microsoft's reports. but when i run my reports its
> giving an error msg like ... The expression for the
> query 'Selection' contains an error: [BC30648] String
> constants must end with a double quote.
> here selection is my dataset name... i'm running this thru
> report designer in vs.net... could any one tell me wht's
> my wrong ...
>
>
> =IIF(Parameters!pParamIn.Value="", "WITH MEMBER
> MEASURES.DIMNAME AS 'NULL' MEMBER MEASURES.UNAME AS 'NULL'
> MEMBER MEASURES.PUNAME AS 'NULL' MEMBER MEASURES.LABEL
> AS 'NULL' MEMBER MEASURES.SYMBOL AS 'NULL' SELECT
> {MEASURES.DIMNAME, MEASURES.UNAME, MEASURES.LABEL,
> MEASURES.SYMBOL, MEASURES.PUNAME} ON 0 FROM [Purchase
> Order]", "WITH MEMBER MEASURES.DIMNAME AS '" & Parameters!
> pMember.Value & ".DIMENSION.NAME' MEMBER MEASURES.UNAME
> AS '" & Parameters!pMember.Value
> & ".DIMENSION.CURRENTMEMBER.UNIQUENAME' MEMBER
> MEASURES.PUNAME AS '" & Parameters!pMember.Value
> & ".DIMENSION.CURRENTMEMBER.PARENT.UNIQUENAME' MEMBER
> MEASURES.SYMBOL AS 'IIF(" & Parameters!pMember.Value
> & ".DIMENSION.CURRENTMEMBER IS " & Parameters!
> pMember.Value & ", 1, IIF(COUNT(INTERSECT({" & Parameters!
> pMember.Value & ".DIMENSION.CURRENTMEMBER}, {" &
> Parameters!pMember.Value & ".SIBLINGS}))=1, 2, 3))' MEMBER
> MEASURES.LABEL AS '" & Parameters!pMember.Value
> & ".DIMENSION.CURRENTMEMBER.NAME' SELECT
> {MEASURES.DIMNAME, MEASURES.UNAME, MEASURES.LABEL,
> MEASURES.SYMBOL, MEASURES.PUNAME} ON 0, DRILLDOWNMEMBER({"
> & Parameters!pMember.Value & ".SIBLINGS}, {" & Parameters!
> pMember.Value & "}) ON 1 FROM [Purchase Order]")
>
> Thanks in advance..
>