This is a data base question so don't switch off thinking it is a Data
Protection Act Question.
I'm Looking for some general information regarding the UK Law on
rights to access data within a database provided by a third party
software provider.
They are preventing me from ODBC Access to their data base and say
that the only way I can access the data held in the data base is
through CSV reports that their custom app can provide.
I am building a datawarehouse and require the data to be DTS'sed to my
OLAP server on a regular basis....but theyt rae denying me access the
database is Oracle so their should really be no problems but they are
hitting me with all the usual invalidate warranty claims.
Does anyone know what UK law has to say in this matter, o0r can you
point me to a good resource.
Usability and relevance have been identified as the major factors preventing mass adoption of Business Intelligence applications. What we have today are traditional BI tools that don't work nearly as well as they should, even for analysts and power users. The reason they haven't reached the masses is because most of the tools are so difficult to use and reveal so little about the data that only power users are willing to put up with them. Just as Google redefined the web by making search and therefore access easy … the same needs to occur with the BI suite.
Overwhelmingly, traditional BI products are designed for the technology expert. The perceived functionality requirements are driven by widget wish lists rather than actual business user (the BI consumers) needs.
Our design philosophy has been honed through experience and results in a simple equation:
Usability = Simplicity + Unity
This paper is a reflection on some of the design approaches used in the development of Yellowfin. Its purpose is to provide an insight into what makes web based applications ‘work’ and how Yellowfin will continue to evolve and improve. The principles are defined by 5 laws and 5 myths.
The laws:
1. Simplicity – the art of Zen and interface design 2. Strive for internal and external unity 3. Innovation stretchs engineering capability 4. Everything changes except change itself 5. First impressions count The Myths:
1. Form follows function 2. Only users know what they want 3. Involve many people in your design process 4. Usability testing will ensure a great UI 5. You can’t live without rigorous design processes At Yellowfin we use the principles outlined in this paper to continue to deliver innovation, improvements and what we hope is an exceptional software experience for our customers.
#1 Simplicity – the art of Zen and interface design
Users want simplicity! They want to do the job they need to do with the minimum of effort and complexity. Users must be able to perform their most frequent, most important tasks without any resistance. This means:
1. not having to spend time sifting through an array of irrelevant options, and 2. not having to browse help files or a manual to accomplish simple tasks The goal, then, is obvious: to maximize performance while minimizing confusion. But as vendors and users are discovering, that's no small trick. Simplicity is sometimes the least simple thing to achieve." 1
Simplicity requires that your code does all the hard work, rather than the user. Google, as an example, maintains the simplest of search interfaces. No distractions from blogs, news or ads, you simply type in your query and go. Behind this simplicity is up to 500,000 computers globally linked and participating in answering your query. In essence, one of the most complex hardware/software systems on the planet is hidden behind a very simple webpage that is virtually 100% whitespace.
Deliver the right level of blatant functionality to suit user skills
The most common UI issue in report writers is BOS (Button Overuse Syndrome). If there is a formatting option, or any option for that matter, then traditionally it needs a button. How wrong can you be! BOS delivers too many options and results in a user confused by choice.
The cure for BOS is UI simplification through minimalism – the art of Zen and interface design. Focus on what users do 90% of the time. Chances are your users will not mind using a drop down menu or popup forms if the action they are performing is not regularly repeated. Provide buttons for those actions that are regularly used and then drop down menus or side panel menus for all the others. Whatever you do, keep the interface simple and consistent.
Of course the level of competence of your user will influence your design decisions. An example of a product that is tailored for user sophistication is the video camera. Consumer versions have lots of functionality but hidden in layers of menus, whilst professional versions tend to be button centric to allow rapid access to all the functions desired.
Taking this lesson into account we have designed the UI specifically to suit the technical ability of the average user. The interface is made more flexible through role based access, where greater control is exposed as technical proficiency increases. For example the report writer (a business user function is menu driven) but the more technical metadata layer is panel and options driven.
I'm trying to re-write my database to de-couple the interface (MS Access) from the SQL Backend. Â As a result, I'm going to write a number of Stored Procedures to replace the MS Access code. Â My first attempt worked on a small sample, however, trying to move this on to a real table hasn't worked (I've amended the SP and code to try and get it to work on 2 fields, rather than the full 20 plus).It works in SQL Management console (supply a Client ID, it returns all the client details), but does not return anything (recordset closed) when trying to access via VBA code.The Stored procedure is:-
USE [VMSProd] GO /****** Object: StoredProcedure [Clients].[vms_Get_Specified_Client] Script Date: 22/09/2015 16:29:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON
I have a client who has SSMS installed on her laptop. She is able to connect to the SQL server via SSMS in the office and query data on the server.
She needs to be out of site often and doesn't have internet access. She asks if the data tables can be "backed up" or saved on her laptop, so she can look at them without worrying connecting to the server. I am not sure if this can be achieved, as SSMS is built for accessing a server, not a desktop. Myself never have this need. If I really need it, I would go to Microsoft Access and create an ODBC connection to the datatables. But this client thinks that Microsoft Access is beneath her.Â
I have recently upgraded to SQL2014 on Win2012. The Access front end program works fine.
But, previously created Excel reports with built in MS Queries now fail with the above error for users with MS 2013. The queries still work for users still using MS 2007.Â
I also cannot create any new queries and get the same error message. If I log on as myself on the domain to another PC with 2007 installed it works fine, so I don't think it is anything to do with AD groups or permissions.
We need to insert data/rows from a SQL Server 2014 database into MS Access database. The problem is, there are so many columns (100+) in the table and there are so many insert transactions of this kind (from different tables) that it is not very easy to write the code in VB.NET that lists all column names.
Both the Access and SQL Server tables have the same number of columns and the equivalent data types, so inserting is not really the problem. It's just that is there a way to do an insert statement in T-SQL that does not name all the columns?
I've been developing desktop client-server and web apps and have used Access and SQL Server Standard most of the time. I'm looking into using SQL CE, and had a few questions that I can't seem to get a clear picture on:
- The documentation for CE says that it supports 256 simultaneous connections and offers the Isolation levels, Transactions, Locking, etc with a 4GB DB. But most people say that CE is strictly a single-user DB and should not be used as a DB Server. Could CE be extended for use as a multi-user DB Server by creating a custom server such as a .NET Remoting Server hosted through a Windows Service (or any other custom host) on a machine whereby the CE DB would run in-process with this server on the machine which would then be accessed by multiple users from multiple machines?? Clients PCs -> Server PC hosting Remoting Service -> ADO.NET -> SQL CE
- and further more can we use Enterprise Services (Serviced Components) to connect to SQL CE and further extend this model to offer a pure high-quality DB Server? Clients PCs -> Server PC hosting Remoting Service -> Enterprise Services -> ADO.NET -> SQL CE
Seems quite doable to me, but I may be wrong..please let me know either ways
When i am trying to start our hospital software based on SQL server 2000, it shows Following Error.Search Condition is not valid, (DBNETLIB) Connection Open (connect()).  SQL server does not exist or excess denied. Due to Fetch data.I run our software in Windows 8.1, while it smothly runs in previous version of Windows XP and 7.
When I execute the below stored procedure I get the error that "Arithmetic overflow error converting expression to data type int".
USE [FileSharing] GO /****** Object: StoredProcedure [dbo].[xlaAFSsp_reports] Script Date: 24.07.2015 17:04:10 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO
[Code] .....
Msg 8115, Level 16, State 2, Procedure xlaAFSsp_reports, Line 25 Arithmetic overflow error converting expression to data type int. The statement has been terminated. (1 row(s) affected)
is there a step by step paper to get there? here is what i need to consider. I Iwill have many customers that will need their own set of records and access pages "branded for their company" each customer will have many clients. I am hosting this application on a windows 2003 server with SQL 2005 server enterprise.
I am using windows authentication, I have created a username in windows, then i added the windows user in SQL management studio in security, granted "DB Read" and "DB write" and again under the database security tab. still from the web authentication fails. i must be nissing a step or two?
I expect to set up a username for each database as i setup new customers.
HiI'm having problems following the tutorial on creating a data access layer - http://www.asp.net/learn/dataaccess/tutorial01cs.aspx?tabid=63 - when I try to compile in Visual Studio 2005 I get namespace could not be found. I followed exactly the tutorial - I created a dataset and added this code in my aspx page. <asp:GridView ID="GridView1" runat="server" CssClass="DataWebControlStyle"> <HeaderStyle CssClass="HeaderStyle" /> <AlternatingRowStyle CssClass="AlternatingRowStyle" />In my C# file I added these lines... using NorthwindTableAdapters; <<<<<this is the problem - where does this come from? protected void Page_Load(object sender, EventArgs e) { ProductsTableAdapter productsAdapter = new ProductsTableAdapter(); GridView1.DataSource = productsAdapter.GetProducts(); GridView1.DataBind(); }Thanks in advance
I'm currently working on a BI architecture for a customer, and consider to propose the Power BI data catalog as a data distribution layer. The customer will use Power BI, but also has other BI tools.
Are data sets in the data catalog available to other clients than Power Query alone? E.g. are there OData feed endpoints available? If not, what would be the best way to give other tools access to the data?
I have two database(MYDB1 , MYDB2) on two different server's(SERVER1 , SERVER2) . I want to create an store procedure in MYDB1 on SERVER1 and get some data from a table of MYDB2 on SERVER2. How can i do this?
I'm using a legacy application built using VB5 and SQL Server 7. After recompiling it, and putting the database in SQL Server 2012. I want to access the current login user using the SQL function SUSER_SNAME().
This is the code.
Set rdoRes = goDatabase.Connection.OpenResultset("select suser_sname()")
But I'm unable to get the current user login in the application. If I write any other SQL statement instead of this, then it runs. But only this statement is not running. Is there any security reasons for this?
I have a table that is returning rows from a table query. It seems I have done it before but I cannot seem to get the right procedure to obtain the values. I will paste in the code below in which you will see my bad attempts at accomplishing what I need.
Dim uid As String Dim pw As String Dim em As String, fn, ln, mi As String Dim par As String Dim Field, n, j As Integer Dim JJ As Integer
how I can load the CSV file data into the sql server table. I know there are ways like bulk insert and other to load the csv file data into the table. But in my case the table doesn't exist and has to be created at the run time. With simple insert in temp table we do like select * into #temp from tablename and that creates the temp table. So. I need something like that which create the temp table and load the data into it. because the CSV file would have different number of columns and names so I can not create the table structure in advance. I have to create the table at run time.Â
I have an MVC asp.net application that stores many records in a table on sql server, in its own system. Â used the system for 2 months, worked fine accessing, changing data.
Now that other users are logging in? there is cross coupling going on. Â one user gets the data from another users sql search.
In the mvc app it had used the get async method to read the ID record from the db, i set that to synchronous. Â no effect; Â the user makes their own login id but that does nt matter either.
I have one column in SQL Server 2005 of data type VARCHAR(4000).
I have imported sql Server 2005 database data into one mdb file.After importing a data into the mdb file, above column data type converted into the memo type in the Access database.
now when I am trying to import a data from this MS Access File(db1.mdb) into the another SQL Server 2005 database, got the error of Unicode Converting a memo data type conversion in Export/Import data wizard.
Could you please let me know what is the reason?
I know that memo data type does not supported into the SQl Server 2005.
I am with SQL Server 2005 Standard Edition with SP2.
Please help me to understans this issue correctly?
Aaarrgghhhhhhh, still searchin' for a nice step-by-step article to learn data access (all insert delete update commands) with the SQL Server .NET Data Provider found in [System.Data.SqlClient] namespace....
While run time these values are lets suppose @SSN = '999-000-000' & @State='ABC'
Now the Result is displayed with the state data Like 'AB' only.
Output: 1 999-000-000 AB
instead it should give system generated error.
Here I have 2 Questions: 1. Why it is taking 1st 2 Charecters? 2. Why it does not have any system generated for length?
I can do validation with Length function for these 2 variables however if have 100 variables then it should not feasible case. So, what is the reason behind?Â
I have a view that give me the data of all the batched. Now I am using a query on view to get a single batched data. when I am using direct query it was taking 0 sec but when I am using Through view "select * from myView where batched=2" then its taking 30 mnt.
We have a daily process, which copies millions of rows of data from one DB to another over Linked Server. Just checking on the best practise, are there more efficient ways than the Linked server to copy millions of rows of data from one DB to another? I checked bulk insert but that transfers the data from the file to DB not DB to DB.Â
Can anyone tell me how to access data from Stored Procedures using data adapters? My task is to select a row which is valid with data particular value. Suppose i had to get all values of particular user after validating username and password. Can anyone give me some hint regarding store procedure and retriving data from stored procedure using data adapters ? How can i bind data to dropdownbox of one field in the table using datasets and data adapters? How can i insert data in database using data adapters?Can any one solve this?
I have a scenarios where if I execute select * from tbl it should display the all the records without waiting to release any lock. For example suppose I have one table called tbl and one session is updating one records and not committed yet and in other session if i execute select * from table I can see all the records, for that records it can show me older version. but my select statement should not wait to commit another session and also it should not show the modified data.
I'm new to sql server. Last week I made my first cube. Everything went fine. But when I want to explore the cube (from the explore panel in Visual Studio 2012) in Excel then I'm getting the error "Initialization of the data source failed".
Check your database server or contact your database administrator. Make sure the external database is available, and then try the operation again. If you see this message again, create a new datasource to connect to the database.
I'm using Sql Server 2012. Visual studio 2012. Excel 2013 on Windows 10
I'm stucked in a problem and I thought if you would be so kind as to helping me to resolve it.
I'm implementing a clustering algorithm plugin for text mining. I've already read the tutorials and sample codes provided by the MSDN Library.
Well... My problem is: I can't go through the data when the Predict method is called. I've read that this method implements the "core" of the custom algorithms. Here is a small snippet of my code for you to understand my doubt:
As you can see, I'm going through in_rgValues to get its values, but i'm only obtaining the first register of the table on the database. I need to roll over a kind of resultset so I could access all the registers I need. Is there any way to do so ?
I expected Predict() received a matrix containing all my data, but the only thing I noticed that could represent the data is that in_rgValues vector. So I can go through this vector, but it holds only the first register of the table in the database (that's what's being saved on my log). I need all of the registers in order to pre-process the data and implement my clustering algorithm.
Well... That's it... I would be very pleased if you could help me.
Hi all, We have access database with lots of data in it. I want to move all the dat to the new database which has completely differenet database structure (e.g different tables, different rows). What I was thinking is that there are 2 ways. one is manually, which will take long tome probably, and the other is to rum queries that will move the data from access to the new sql express. The question is how to that. I know that I used onw CSV files exported for ms access, but now the queries will be much more complex and I will use more then one table for te query. How can I query from 2 different databases, which from one I read data(access), and from the other I write data (express)? Thanks alot.
hi: i want to ask that i have developed a web application using ado.net.actually the records are more than 50000,but when i populate my dataset,50000 records in it.it consumes a lot of recources and memory and the application goes down.i access the record in dataset through "Dataset.Tables.Rows.items".i want to decrease the load bcoz application run in efficient way.so tell me that how can i make application more efficient to keep the dataset or i will use datareader to access the record or if there is another way to achieve this so plz tell.
Hi, I'm trying to do a simple project that involves asking the user to input a name, age and grade from a webform and then inserting this as a new record into an sql server database. But I must be doing something wrong because it doesn't get inserted into my table. The table (tblStudent) has 5 fields ( ID (an int, identity), Name (varchar), Age (int), Grade (int), Fees (automatically calculated based on what grade was input) ). This is my code: 1 using System; 2 using System.Data; 3 using System.Configuration; 4 using System.Web; 5 using System.Web.Security; 6 using System.Web.UI; 7 using System.Web.UI.WebControls; 8 using System.Web.UI.WebControls.WebParts; 9 using System.Web.UI.HtmlControls; 10 using System.Data.SqlClient; 11 using System.Web.Configuration; 12 13 public partial class _Default : System.Web.UI.Page 14 { 15 SqlConnection myConnection = new SqlConnection(WebConfigurationManager.ConnectionStrings[1].ConnectionString); 16 17 protected void Page_Load(object sender, EventArgs e) 18 { 19 20 } 21 protected void btnAdd_Click(object sender, EventArgs e) 22 { 23 24 float fees; 25 26 if (Convert.ToInt32(txtGrade.Text) < 5) 27 { 28 fees = 10000; 29 } 30 else 31 { 32 fees = 20000; 33 } 34 35 myConnection.Open(); 36 SqlCommand myCommand = new SqlCommand("insert into tblStudent VALUES ('" + txtName.Text + "'," + Convert.ToInt32(txtAge.Text) + "," + Convert.ToInt32(txtGrade.Text) + "," + fees + ")", myConnection); 37 myCommand.ExecuteNonQuery(); 38 myConnection.Close(); 39 40 } 41 } 42
I am migrating a database from Access97 to SQL 7 using DTS. The default conversion for an Access yes/no data type is to bit in SQL server. Has anyone had any experience with this??
