Hi Everyone,
In C# file:
bool abc; (it is working)
But in sql file: (bool is not working. What datatype should use for bool in the sql file?)
CREATE TABLEsb_payment_history (
sb_dispensing bool NULL <================ not working because bool is not known.
)
GO
Thanks,
May
You should use the bit datatype in your SQL table.
I am working with RS 2005 and have run into a problem with passing a server and database name as parameters into a server report.
Here's what the connection string looks like in these reports:
="Data Source = " & Parameters!ServerName.Value & ";Initial Catalog=" & Parameters!DBName.Value
I have default values set for both parameters, so testing usually works fine also. If I run a report with "normal" parameters or no parameters, the report runs fine with the supplied connection string.
The problem occurs when I try to add a parameter to the report that uses a dataset to populate a list of choices. I get the following error when trying to run a report in this situation:
"Error during processing of the ConnectString expression of datasource 'dbConnection'"
I don't get any build errors, just the message above in the report canvas.
Any direction/assistance anyone can provide would be greatly appreciated.. thanks in advance.
Very simple solution, it turns out... just make sure the ServerName and DBName parameters appear above all other parameters in the report definition.
I am trying to filter data at the dataset level after it is returned.
However, the filters tab on in the Dataset window does not appear to work correctly.
I have tried the following expressions:
Expression Operator Value
=(Fields!IdLog.Value = Parameters!Id_Log.Value) = =True
=Fields!IdLog.Value = =Parameters!Id_Log.Value
When I rerun my dataset query, the entire dataset is returned, instead of the filtered dataset. This same behavior occurs if I try to run the report itself.
I do not understand why the filtering does not occur.
Any help would be greatly appreciated.
To get maximum performance with filtering its the best to build the parameter into the SQL-Query:
="select your_colums from your_table where ID='" & Parameters!Id_Log.Value & "'"
I never tried something different, because its waste of resources to retrieve 1000records from a database and filter out 999 of them..
|||
BenniG,
Thank you for your comment. However, I am try to filter the results that are returned from a Web Service, and therefore, I cannot specify the SQL Statement used to query the database.
|||I tried the filter-tab:
=Fields!ID.Value = =Parameters!ID.Value
works if both fields have the same datatype, if one is a string and one an integer I get an error.. Maybe you have to change the datatype for the Parameter?
I think the filter has no effect on the !-Icon in datasets, but in my case it worked in preview mode..
This is what I have so far...What I want to do is assign the dataset to a variable and to see if it is NULL or Not. I don't how? Any help would be awesome.
Sub Button1_Click(sender As Object, e As EventArgs)
?? = MyQueryMethod(txtPhone.Text)
Thanks,
Matt
|||Simply amazing! It's so easy once someone tells you how it is. Worked like a charm...Now I'm all jacked up!!!
Dim oDataSet as System.Data.DataSet = MyQueryMethod(txtPhone.Text)If oDataSet = Nothing Then
' your dataset is jacked up
Else
' You got a dataset to work with
End If' Release memory allocations to the variable.
oDataSet.Dispose()
Much Respect!!!!
Thanks,
Matt|||Well actually, it didn't quite do as I expected but I'm close. When I execute this code, I am expecting the dataset to have no records or one record, but either way the DataSet is never nothing (at least from my testing).
Maybe I'm just going about my problem the wrong way. I am trying to validate phone number so that I don't have someone enter a duplicate key in my database. So I run an SQL select statement that returns a dataset. The dataset should have one phone number or no phone number and this is how I'm trying to ward off any duplicate keys.
Is there an easier way to prevent a duplicate key entry? Sorry, I'm new at this stuff!!|||You can code as
If oDataSet.Tables(0).Rows.Count = 0 Then
' your have no records
Else
'Response.Write(oDataSet.Tables(0).Rows(0)(0).ToString())
End If
Hi,
I cant seem to get this working right...I have a datareader which i loop through...i want to test each value to see if its null but i cant get the syntax right.
I know i use dr.item("columnname") or dr(0) to pick a certain column but i dont know the column names and want to check them all anyway. What is the syntax to do this.
Thanks for any help...this is prob very simple but just cant see it.
--------------
While dr.ReadIf dr(0)Is System.DBNull.ValueThen
Return"test"
EndIfEndWhile
I useually would add the following to identify the columns by:
msgbox(dr(0))
msgbox(dr(2)) and so on.
or use response.write(dr(0))
|||
Hi
Ireland,
Ireland:
...i want to test each value to see if its null but i cant get the syntax right.
if i remember right, no VS in front of me, its similar to
while(reader.Read()){// not sure if fields the correct property namefor(int i=0; i < reader.fields.count; i++) {// iterate throu all fields in the rowif(reader[i] ==typeof(string)) {string str = reader[i]; } }}the correct property you see in the reader intellisence. But i think it was fields
|||
you can try dr.FieldCount. That will give you the number of columns in the datareader.
The code will be something like this (sorry my VB.NET is no good)
While dr.Read
for iCtr=0 to dr.FieldCount
if dr(iCtr) Is System.DBNull.Value Then
Return "test"
End If
Next
End While
quote:
> I'm working with a production database connecting remotely. All the
quote:
> If my expectation is correct then can I change the place of the index and
quote:
>
> Please evaluate my query and do give a proper suggestion.
>
> Thanks in advance
> Sunil
>
I created a data-driven subscription for my report with "Null Delivery Provider" set in report manager. I set the processing to "On a schedule created for this subscription" and scheduled the report to "run once" in the next 1 minute so I could test it. The subscription added successfully, but I don't see the "last run information" even after 5 minutes. Am I missing something?
Thanks in advance!!!
Check SQL Server for any failures reported in the log.
I am upgradinding to sql 2005 and the Data-Driven subscription is not working. the data-Driven option It is now showing in report manager and in code I get the error " rsOperationisNotSupported".... I have the same security permitions I had before in sql 2000. Does anyone knows if there is another difference that would prevent the subscription from working ?
thank you
drey
What sku of SQL 2005 are you using? Data driven subscriptions are only supported on developer and enterprise editions.|||thank you,
I am using Standard edition, my company does not have enterprise. I guess that is a deal breaker for upgrading...
|||Data driven subscriptions was also an Enterprise / Developer Edition in RS 2000. It was not available for the Standard Edition.
-- Robert
The "DataDir" property for an AS 2005 instance seems to only allow for one path to be specified. I am working with a very large data set that is being updated frequently and I would like to be able to reference more than on LUN on my disk array.
Yes, you can.
Take a look at the StorageLocation property of your partition.
Edward Melomed (MSFT)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
One database(which will be on a mobile ambulance server) should
constantly check for connection with a main database which is on
another server in someother place and should constantly update as well
as pull information from that. In other words both should be in
syncronisation.
2)First of all I do not know what is a desktop apllication and how
does it differ from other applications.
3)Is there any tutorials which would teach me how to do this, how to
write a desktop application for this? I know there are some tools
which will do this for us, but we want an application to be built by
us, so that we can modify it acording to our requirement.I am jus a
begginer in databses, so I dont know about databases to this extent,
so I need your help.
Thank you, It would be of great help if you could even tell me how go
about this.
Soumyamsowmya@.uab.edu (Sowmya Mulukutla) wrote in message news:<91fbf545.0406111019.43d98df8@.posting.google.com>...
> Hello Sir/Madam,
> I need some help from you.I am working as an RA in a real-time
> project,on itegration of Emergency medical services with wireless
> technolgies, which involves work on databases.
> 1)I have a problem now, where I need to write a desktop application
> which will syncronise 2 databases.
> One database(which will be on a mobile ambulance server) should
> constantly check for connection with a main database which is on
> another server in someother place and should constantly update as well
> as pull information from that. In other words both should be in
> syncronisation.
> 2)First of all I do not know what is a desktop apllication and how
> does it differ from other applications.
> 3)Is there any tutorials which would teach me how to do this, how to
> write a desktop application for this? I know there are some tools
> which will do this for us, but we want an application to be built by
> us, so that we can modify it acording to our requirement.I am jus a
> begginer in databses, so I dont know about databases to this extent,
> so I need your help.
> Thank you, It would be of great help if you could even tell me how go
> about this.
> Soumya
Assuming that this is an academic exercise (I notice you're posting
from a .edu address), then I would suggest asking your teachers for
guidance, if they didn't already give you some sources to consult. I
guess that they want you to investigate the issues related to merging
data when update conflicts can arise - in MSSQL2000, merge replication
is one example of this process. You might want to read up on that in
Books Online to see some of the issues to be considered.
Simon
I created the following policy. It's a basic policy for enforcing database settings. I then created a database in violation of the policy and didn't generate an error. I also altered the database to violate the policy and still didn't get any policy errors.
alter database test2
set auto_close on
<?xml version="1.0" encoding="utf-8" ?>
- <SfcSerializerFragment SfcDomain="Dmf" SfcType="Microsoft.SqlServer.Management.Dmf.PolicyStore">
- <SfcInstance SfcDomain="Dmf" SfcType="Microsoft.SqlServer.Management.Dmf.Policy">
<SfcProperty Name="Name">Enterprise_DatabaseCreate</SfcProperty>
<SfcProperty Name="Description" />
<SfcProperty Name="Condition">DatabaseDefaults</SfcProperty>
<SfcProperty Name="PolicyGroup">Enterprise</SfcProperty>
<SfcProperty Name="Enabled">True</SfcProperty>
<SfcProperty Name="AutomatedPolicyExecutionMode">CheckOnChanges</SfcProperty>
- <SfcInstance SfcDomain="Dmf" SfcType="Microsoft.SqlServer.Management.Dmf.TargetFilter">
<SfcProperty Name="TargetType">DATABASE</SfcProperty>
<SfcProperty Name="Filter">Server/Database</SfcProperty>
<SfcProperty Name="TargetTypeSkeleton">Server/Database</SfcProperty>
</SfcInstance>
</SfcInstance>
- <SfcInstance SfcDomain="Dmf" SfcType="Microsoft.SqlServer.Management.Dmf.Condition">
<SfcProperty Name="Name">DatabaseDefaults</SfcProperty>
<SfcProperty Name="Description" />
<SfcProperty Name="Expression"><Operator> <OpType>AND</OpType> <Count>2</Count> <Operator> <OpType>AND</OpType> <Count>2</Count> <Operator> <OpType>AND</OpType> <Count>2</Count> <Operator> <OpType>AND</OpType> <Count>2</Count> <Operator> <OpType>EQ</OpType> <Count>2</Count> <Attribute> <Name>AutoClose</Name> </Attribute> <Constant> <ObjType>System.Boolean</ObjType> <Value>False</Value> </Constant> </Operator> <Operator> <OpType>EQ</OpType> <Count>2</Count> <Attribute> <Name>AutoCreateStatistics</Name> </Attribute> <Constant> <ObjType>System.Boolean</ObjType> <Value>True</Value> </Constant> </Operator> </Operator> <Operator> <OpType>EQ</OpType> <Count>2</Count> <Attribute> <Name>AutoCreateStatisticsEnabled</Name> </Attribute> <Constant> <ObjType>System.Boolean</ObjType> <Value>True</Value> </Constant> </Operator> </Operator> <Operator> <OpType>EQ</OpType> <Count>2</Count> <Attribute> <Name>AutoShrink</Name> </Attribute> <Constant> <ObjType>System.Boolean</ObjType> <Value>False</Value> </Constant> </Operator> </Operator> <Operator> <OpType>EQ</OpType> <Count>2</Count> <Attribute> <Name>AutoUpdateStatistics</Name> </Attribute> <Constant> <ObjType>System.Boolean</ObjType> <Value>True</Value> </Constant> </Operator> </Operator></SfcProperty>
<SfcProperty Name="Facet">IDatabaseFacet</SfcProperty>
</SfcInstance>
</SfcSerializerFragment>
I then created a subsequent policy (policy 2) with just the "AUTO CLOSE = FALSE" and this will ONLY throw an error when I "TEST" the policy. It doesn't throw the error when I run the ALTER DATABASE TSQL.
I created a 3rd database in violation of POLICY2 and was successfuly able to create the db without generating an error.
Is policy manager working properly? Shouldn't it work on CREATE DATABASE? Shouldn't it work without selecting "TEST" on policy?
Thanks
Steve
(SteveBouffard@.discussions.microsoft.com) writes: > I created the following policy. It's a basic policy for enforcing > database settings. I then created a database in violation of the policy > and didn't generate an error. I also altered the database to violate > the policy and still didn't get any policy errors. But if you look in Mgmt Studio, doesn't the database have some warning sign attached to it? I was not able to import your XML document, but you have CheckOnChanges. To get an error when you violated a policy you need Enforce. But when I tried to set up a policy to prohibit databases with auto-close, Enforce was greyed out. I guess this is because CREATE and ALTER DATABASES are commands that cannot be rolled back, so it is not possible to enforce them. -- Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx|||
The execution modes for a policy are determined by the facet. The facet defines the events to listen to for Enforce and Check on Change (CoC). In order for the facet to define events for Enforce, the target type (e.g. database, table, view, etc) must be completely transactional. In the case of Database, create database is not completely transactional and therefore enforce is not support on conditions built-on database facets. Yes, the create database transaction can be canceled, but the system is not returned to the previous state. Therefore, DMF doesn't support enforce.
Cheers,
Dan
|||ok, thanks
I created the following policy. It's a basic policy for enforcing database settings. I then created a database in violation of the policy and didn't generate an error. I also altered the database to violate the policy and still didn't get any policy errors.
alter database test2
set auto_close on
<?xml version="1.0" encoding="utf-8" ?>
- <SfcSerializerFragment SfcDomain="Dmf" SfcType="Microsoft.SqlServer.Management.Dmf.PolicyStore">
- <SfcInstance SfcDomain="Dmf" SfcType="Microsoft.SqlServer.Management.Dmf.Policy">
<SfcProperty Name="Name">Enterprise_DatabaseCreate</SfcProperty>
<SfcProperty Name="Description" />
<SfcProperty Name="Condition">DatabaseDefaults</SfcProperty>
<SfcProperty Name="PolicyGroup">Enterprise</SfcProperty>
<SfcProperty Name="Enabled">True</SfcProperty>
<SfcProperty Name="AutomatedPolicyExecutionMode">CheckOnChanges</SfcProperty>
- <SfcInstance SfcDomain="Dmf" SfcType="Microsoft.SqlServer.Management.Dmf.TargetFilter">
<SfcProperty Name="TargetType">DATABASE</SfcProperty>
<SfcProperty Name="Filter">Server/Database</SfcProperty>
<SfcProperty Name="TargetTypeSkeleton">Server/Database</SfcProperty>
</SfcInstance>
</SfcInstance>
- <SfcInstance SfcDomain="Dmf" SfcType="Microsoft.SqlServer.Management.Dmf.Condition">
<SfcProperty Name="Name">DatabaseDefaults</SfcProperty>
<SfcProperty Name="Description" />
<SfcProperty Name="Expression"><Operator> <OpType>AND</OpType> <Count>2</Count> <Operator> <OpType>AND</OpType> <Count>2</Count> <Operator> <OpType>AND</OpType> <Count>2</Count> <Operator> <OpType>AND</OpType> <Count>2</Count> <Operator> <OpType>EQ</OpType> <Count>2</Count> <Attribute> <Name>AutoClose</Name> </Attribute> <Constant> <ObjType>System.Boolean</ObjType> <Value>False</Value> </Constant> </Operator> <Operator> <OpType>EQ</OpType> <Count>2</Count> <Attribute> <Name>AutoCreateStatistics</Name> </Attribute> <Constant> <ObjType>System.Boolean</ObjType> <Value>True</Value> </Constant> </Operator> </Operator> <Operator> <OpType>EQ</OpType> <Count>2</Count> <Attribute> <Name>AutoCreateStatisticsEnabled</Name> </Attribute> <Constant> <ObjType>System.Boolean</ObjType> <Value>True</Value> </Constant> </Operator> </Operator> <Operator> <OpType>EQ</OpType> <Count>2</Count> <Attribute> <Name>AutoShrink</Name> </Attribute> <Constant> <ObjType>System.Boolean</ObjType> <Value>False</Value> </Constant> </Operator> </Operator> <Operator> <OpType>EQ</OpType> <Count>2</Count> <Attribute> <Name>AutoUpdateStatistics</Name> </Attribute> <Constant> <ObjType>System.Boolean</ObjType> <Value>True</Value> </Constant> </Operator> </Operator></SfcProperty>
<SfcProperty Name="Facet">IDatabaseFacet</SfcProperty>
</SfcInstance>
</SfcSerializerFragment>
I then created a subsequent policy (policy 2) with just the "AUTO CLOSE = FALSE" and this will ONLY throw an error when I "TEST" the policy. It doesn't throw the error when I run the ALTER DATABASE TSQL.
I created a 3rd database in violation of POLICY2 and was successfuly able to create the db without generating an error.
Is policy manager working properly? Shouldn't it work on CREATE DATABASE? Shouldn't it work without selecting "TEST" on policy?
Thanks
Steve
(SteveBouffard@.discussions.microsoft.com) writes: > I created the following policy. It's a basic policy for enforcing > database settings. I then created a database in violation of the policy > and didn't generate an error. I also altered the database to violate > the policy and still didn't get any policy errors. But if you look in Mgmt Studio, doesn't the database have some warning sign attached to it? I was not able to import your XML document, but you have CheckOnChanges. To get an error when you violated a policy you need Enforce. But when I tried to set up a policy to prohibit databases with auto-close, Enforce was greyed out. I guess this is because CREATE and ALTER DATABASES are commands that cannot be rolled back, so it is not possible to enforce them. -- Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx|||The execution modes for a policy are determined by the facet. The facet defines the events to listen to for Enforce and Check on Change (CoC). In order for the facet to define events for Enforce, the target type (e.g. database, table, view, etc) must be completely transactional. In the case of Database, create database is not completely transactional and therefore enforce is not support on conditions built-on database facets. Yes, the create database transaction can be canceled, but the system is not returned to the previous state. Therefore, DMF doesn't support enforce.
Cheers,
Dan
|||ok, thanks