GetReportParameters Ignores Language=en-gb?
May 1, 2007
Hello
I've integrated my reports into an app using the ReportViewer control, and I've created custom parameter selection controls. I want the user to be able to enter dates in dd/mm/yy format into a textbox. I've set the language of my reports to en-gb.
The SetParametes method of the ReportViewer control copes with this fine, but when I pass a date string in dd/mm/yy format into GetReportParameters, I get a 'parameter value not valid for its type' error. But it works for date strings in mm/dd/yy format, so it's as if GetReportParameters is ignoring my language setting.
Has anyone got any idea as to where I'm going wrong?
Thanks in advance
Dominic
View 1 Replies
ADVERTISEMENT
Aug 19, 2014
I have created a common table expression. The first query is meant to select a particular months worth of data. The second query is meant to select the following months data but only for the subscribers (MSISDN's) that appeared in the first month.
The query returns result for month 1 but ignores the second month. If I remove the last inner join to the CTE (INNER JOIN Test_Table tt ON tt.MSISDN = B.SUBSCRIBER_NUMBER) then I get a full list for both months but obviously this isn't limited to those MSISDN's in the first month.
The second issue that I'm having is that I can't select a sample of say only a 1000 MSISDN's from the first month...
WITH Test_Table (Report_Month, MSISDN, SUB_SEGMENT)
AS
(
Select
R.Report_Month,
R.MSISDN,
DV.SUB_SEGMENT
[code]....
View 9 Replies
View Related
Jul 20, 2005
I am having a problem restricting write access to tables in my database.In my database I have a table called, for the sake of argument, 'TableX'.In my SQL Server Logins, I have set up a login for 'Domain Users' using NTauthentication, and a login called 'FullTableX', using SQL Serverauthentication.I have added two users to my database relating to the above logins.I have added a role to my database called 'ReadTableX' with 'Domain Users'as a member of this role. 'ReadTableX' has SELECT permission only on arestricted set of tables.The only other role that 'Domain Users' is a member of is 'public', and'public' has no permissions on any of my tables.The user 'FullTableX' is a member of 'public', 'db_datareader' and'db_datawriter'With the above settings, I would expect user 'FullTableX' to have fullaccess (Select, Insert, Update and Delete) on all my database tables (so farso good), but any user connecting to the database with NT authentication(via ODBC System DSN) should only have read access to the limited set oftables. However, what is happening is that NT authenticated users also havefull access to all of the tables.What am I missing here??
View 3 Replies
View Related
Mar 19, 2008
We're attempting set the ConnectionString for our configuration database connection manager from an environment variable, but SSIS seems to ignore the environment variable value. Deployment process:
Create the Connection Manager
Create an Environment Variable type configuration with the Target Property: Package.Connections[acConfigDBManager].Properties[ConnectionString]
Build the package
Copy the package and the manifest from the project's inDeployment folder to a folder on the server
From the SSIS server's console, Import the package from the File System.
Run the package, after first inspecting the ConnectionString in the Connection Managers collection
In all cases, the ConnectionString variable for our configuration database is the value in the package at build time.
So far we've tried the following variations:
confirmed that the spelling and case of the environment variable is identical on the XP development computer and the Win2003 server.
restarted SQL Server and SSIS
rebooted the Win2003 server.
built the package with a blank ConnectionString value in the connection manager
re-imported the package, overwriting the old one
deleted the old package before reimporting
renamed the package and imported
run imports from SQL Management Studio from the server console
assign the connection string from an arbitrary system environment variable
assign the ServerName and use an expression to build ConnectionString
What now? Has anyone been able to set a Connection Manager property from an environment variable?
View 16 Replies
View Related
Jun 22, 2007
All,Just want to make sure that I understand what's going on here.I have a table with IGNORE_DUP_KEY set on a unique, multi-columnindex.What I'm seeing is this:1) When performing a BULK INSERT, the UNIQUE index is not beingrespected and rows which violate the unique index are inserted.2) When performing a regular INSERT, the UNIQUE index is beingrespected and rows which violate the unique index ARE NOT inserted.Is this expected behavior.Also, I have some questions, given the index described.Q1) Will a regular INSERT that attempts to insert duplicate data getan error back or just a warning?Q2) How can I set things up so that a BULK INSERT would NOT allowduplicates to be entered into the table?Thanks,Wes Gamble
View 2 Replies
View Related
Oct 26, 2006
Hello,
I'm using the SQL Native Client to connect my VB6 application to my SQL Server 2005 database. My SQL Server 2005 database has ANSI_NULLS turned off. I have a query embedded in my VB6 application that uses the syntax "fieldName = NULL" in the WHERE clause. When I execute the query via the SQL Native Client, the query returns zero rows. When I execute the same query via the old OLEDB driver, the query returns many rows. If I change my query to "fieldName IS NULL" syntax, the problem goes away. However, I am more interested in figuring out why ANSI_NULLS are turned on when using the SQL Native Client even though my database has them turned off. Is there a connection string property that I can use with the SQL Native Client to ensure that the query is executed with ANSI_NULLS off?
Thanks
View 15 Replies
View Related
Mar 16, 2006
I have written a script source component and attached a flat file connection. The connection string of which is defined by an expression.
However when I get the connectionstring from the connection in the script it has the default filename value of flat file not the value of the expression. This is proved by passing in the filename variable, and comparing the 2.
The flat file has an expression on the ConnectionString of @[User::filename]
Can someone confirm this is a bug.
View 3 Replies
View Related
Oct 12, 2007
We had a sql 2000 db that had full text implemented on it. We upgrade that server to a 2005 server and now the full text searches that once worked don't. Most do work just the ones with ; or special characters in the query string don't work.
Anyone have the same behavior and how to get it to wrok again?
thanks
View 14 Replies
View Related
Jan 26, 2007
I want to write a statement something like this
SELECT Add_Date, File_No FROM dbo.File_Storage WHERE (File_No = 11/11/1234/)
But i want the search to ignore the first 2 digits so that it will return e.g
10/11/1234, 09/11/1234 so that it's only matching the last part
Any Help Would be greatly appreciated Thanks
View 6 Replies
View Related
Oct 12, 2015
SSIS 2008 when I develop and debug in BIDS sometimes ignores debug break point.
The script component is in the main control flow and at some point the breakpoint did work.
If, for example, I create a new project and copy my script component there the debug breakpoint will work.So it's absolutely *random* when it works and when it does not.
Below is my BIDS detail:
Microsoft Visual Studio 2008
Version 9.0.30729.4462 QFE
Microsoft .NET Framework
Version 3.5 SP1
Installed Edition: IDE Standard
Enterprise Library v5 Configuration Editor  4.0
[code]....
View 2 Replies
View Related
May 25, 2015
Somewhere i read..that in SQL Server...usage of Built-in Functions on Columns, makes query optimizer to ignore indexes on that column...!
So lets say we have table EMP with Emp_id and Emp_Name....
Also we have Non-Clustered index on Emp_Name.
So following query would NOT use Non-Clustered index on Emp_Name column.
SELECTLEFT(emp_name, 3) as emp3
FROMdbo.EMP
Is this true? i am using SQL Server 2008.
View 4 Replies
View Related
Apr 11, 2007
Hi folks;
I have just realised that my language problem is because DB language; then I've changed the language to Turkish but it didn't effect tables.. When I wanted to change tables manually it worned data loss may occur..
What would you suggest to do it?
Thanks
View 3 Replies
View Related
Jan 11, 2006
Hi
I am using SQL server 2000 as backupend...
Pls suggest which language is used as frontend...
(web)
thanks
asm
View 1 Replies
View Related
Apr 14, 2007
i am went Language arbic fram windows xp media center edition 2005 modil number 1252736 please
..............................tomorrow
View 3 Replies
View Related
Apr 12, 2007
Hi;
I need Turkish characters in my DB therefore I have to change Collation from SQL_Latin1_General_CP1_CI_AS to Turkish
But what I realised is that aspnet membership tables' collation is SQL_Latin1_General_CP1_CI_AS as well and they can store Turkish chars but why not my tables?
Thanks..
View 2 Replies
View Related
Nov 21, 2003
I want to insert data into my database in greek language but i am getting some "???????" symbols. I have a table called "Words" with columns "Word"-as char and "Result"-as int. Can somebody please explain me what to do?
Thanks, Mike
View 3 Replies
View Related
Dec 9, 2004
I am looking into a production geared software called MassGroup. (www.massgroup.com) It says that its FactoryServer builds are on a standardized SQL framework and web architecture for data collection, work order requests, reporting and asset management. My questions are:
1. Is SQL its own programming language? If not what is it?
Answer: After going thru several pages and reading the fine print I discovered they use VB, ASP, COM technology, and Crystal Reports.
2. How powerful do you think this would be at gathering data and does it have the capability of creating a number sequence automatically? (example: 0001; 0002; 0003...)
Any help would be appreciated.
Thank you in advance!!!!!
View 1 Replies
View Related
Sep 30, 2004
Good morning. I have an interesting scenario where one of the requirements of the application is to translate an application to different languages. Modelling the system to translate the UI went over without a hitch, however, we have now been told that the application will need to translate all the existing database tables. Has anyone ever had to do anything like this?
I was curious if anyone out there has any suggestions on how to approach this issue... ways in which it could be modeled, alternative approaches, anything at all would be appreciated. Many thanks in advance!
View 3 Replies
View Related
May 19, 2008
Does anyone here know anything about the DCS Scripting Language.
A contract vacancy has arisen using this language but I've never heard of it and there does seem to be anything on the internet about it. Can anyone help?
View 1 Replies
View Related
Feb 13, 2008
Just curiosity ... never pick up this since beginning. Our box is setted the language to English (United States) while the local machine setted as English (Australia) which I thought it's corresponding to locale machine not sql box.
Will this language setting effecting date issue stuff (DD-MM-YYYY)? Can someone clarify on this?
This thing brought up my attention cause we've just ran a trace and there is a warning which is:
User Error Message - Changed language setting to us_english.
Thank you.
View 1 Replies
View Related
Mar 3, 2008
Hi all,
i need to store russian data in sql server db but i found the russain data appeared as odd character in the table, can sql server support it or is there other solution for it? thanks!
View 2 Replies
View Related
Apr 21, 2007
How could i do if i need to use another language, unavailabel in collation such as laos, burma ?
View 2 Replies
View Related
Oct 5, 2007
hey all
I am using Reporting Services 2005 and Microsoft Updates has been run on my machine.
All my reports were set on the above =User!Language and my regional settings to NZ - others to US etc and they
all worked fine until today!
If Sql P2 was run has anyone else struck this? and do you think this is the cause? the other updates were mainly XP.
Anyone have any ideas of what I can do now?
thanks
Dianne
View 4 Replies
View Related
Dec 6, 2006
i need to know in which language the standard SQL is implemented.. and that from where can i get the code.. i need the code for the "logical operators" of SQL.
Plz help..
View 5 Replies
View Related
Nov 27, 2007
Hi there,
I need help about storing data in chinese, arabic, english..... languages in one database. For that I create Database with Latin1_General_CI_AS and I have table Testing with two columns wich are LangName= nvarchar(50), and Comment = nvarchar(MAX). I tried to store comment in chinese language but I could not, when I entered the data "個編碼å?¯ä»¥åŒ…å?«è¶³å¤ çš„å—元：例如，單單æ?å·žå…±å?Œé«”就需è¦?好幾種ä¸?å?Œçš„編碼來包括所有的語言。å?³ä½¿æ˜¯å–®ä¸€ç¨®èªžè¨€ï¼Œä¾‹å¦‚英語，也沒有" it converted as ? sometimes or look as a square.
thanks
View 3 Replies
View Related
Jul 21, 2006
I've just moved servers - WK3 to WK3 - installed SQLserver 2005 and uploaded the database. Code base has not changed but now I'm getting
"String was not recognized as a valid DateTime.Couldn't store <21/07/2006>" . I suspect its to do with the default language , but although the default is English (United States) as in my last server, I have set the language in Advanced settings to be British English. I can't see any difference between the settings and my last server. I'm British BTW .
I also ran
EXEC @ret = sp_defaultlanguage 'sa', 'British English'
as the only login is sa . WK3 is itself set to English (United Kingdom) - I thought SQL 2005 would inherit this setting? Any help would be much appreciated.
View 1 Replies
View Related
Dec 30, 2006
i using sql server Express, i want to change the default language from US-English to British EnglishWhere and How?
View 3 Replies
View Related
Aug 16, 2007
I have to Make Department Table.
But this there names can be in multi language.
--------------------------------------------DepartmentGroup--------------------------------------------DepartmentGroupId (P.K.)UniqueNameCreatedDateModifiedDate--------------------------------------------
--------------------------------------------Department--------------------------------------------DepartmentId (P.K.)NativeNameNavigateUrlIsFavoriteLanguageId (F.K.)DepartmentGroupId (F.K.)IsVisibleCreatedDateModifiedDate--------------------------------------------
From this design we can move to same department in different language.
is it right?
View 2 Replies
View Related
Nov 16, 2007
Hi,I have a table in an MS SQL 2000 database that represents fields on a form.CREATE TABLE [dbo].[TagData]( [FieldName] [nvarchar](255), [UserID] [int] NOT NULL, [Data] [nvarchar](255)) A requirement has come up where some of these fields must contain Hebrew, or any other unicode character, data and some of the fields will be English. How can I go about saving and retrieving this information.The current solution is a legacy Classic ASP application and I suspect I am going to have to redo this in ASP.NetThanks,Leon
View 2 Replies
View Related
Apr 29, 2008
HI,
I am using Multi languages web application with sql database...I am using Arabaic and English languge is there is any thing to change sql database data in Arabic and English on run time.I am using only one database client add some record in Arabic in sql database but the another side some one wana check those records in English...plz let me know how can i do on run time asp.net
Thanks with best regards,
View 4 Replies
View Related
May 22, 2001
Hi ,
Can someone please help , we are trying to change the default language
from us_english to british englsish as the date formats have to be in dd/mm/yyy for our european clients.
We tried sp_configure 'default language' 23
Reconfigure . It worked 3 months back.
We are trying this on the reverse , now and it doesnt work.
Can some one please Help !! Its Urgent !
Thanks in advance
Nat
View 2 Replies
View Related
May 21, 2001
Hi ,
We are trying to change our SQL Database with default Us-English with mdy to
British with dmy format for dates . We had earlier tried it seemed to work. Now It is not working. Could some one please help.
we tried
sp_configure 'default language', 23
reconfigure
Should we shut down the server to see the changes, can someone please help.
Thanks in advance
Cheers
Nat
View 1 Replies
View Related
Sep 13, 2000
I've heard somewhere that SQL Server supports dual languages ? Can anyone confirm this ? How do you set it up please ?
Essentially we need to run our database in Japanese. It currently runs in english.
thanks
Paul
View 1 Replies
View Related
