View Complete Post
There are a lot of tools for comparing “regular” SQL databases, but I couldn’t find any tool for comparing SSAS databases
or cubes. Is there one or is it just no need in such a tool among BI community?
I have the following problem:
When creating a new ODBC data source to an SQL Server 2k5 I want to change the default database from 'master' to my database 'addresses'.
However my database 'addresses' doesn't appear in the drop down list.
I'm conneting with the 'sa' account.
I've activated all protocols in the SQL Server Configuration Manager.
What shall I do?
Any help is greatly appreciated.
I try to move databases from one SQL 2008 R2 to another SQL 2008 R2 Server with the copy database wizard.
On the page where I should choose the databases to move or copy the checkboxes are missing. The databases are listed but no way to choose one of them.
I searched a lot but did not find out what the reason could be for this.
Any hints are appreciated, thank you!
I am a 'newbie' to VWD and I am slowly working through the Basic Walkthrough Help files, and learning plenty along the way.
However, when I tried to create a new database in the LINQ control walkthrough I found that the option to create a new database is missing, and further investigation has found that many other new item templates are missing.
I am using a brand new machine with Windows 7 Ultimate and have enabled IIS and .NET from Control Panel-Programs-Turn Windows Features On-Off. I used the WPI to install all basic elements eg. IIS Components, SQL Server Express.
The only 'new item templates' I have when I right-click the App_Data Folder and choose 'new item' are:-
ADO.NET Data Service
AJAX Enabled WCF Service
Dynamic Data Field
SQL Server Database
Does anyone know where I have gone wrong.
Michael J. Hill
This month's products include DatabaseSpy, FileZilla, NCache, and more.
MSDN Magazine October 2007
Debugging Web applications can be a difficult process due to the logical, physical, and temporal differences between the mishmash of technologies that comprise such an application. For bugs that arise from the HTML and script received by the browser or in the transfer or request of a page's markup, developers often adopt archaic debugging techniques, such as using View Source and Notepad to scrutinize the contents received by the browser.
MSDN Magazine April 2006
I Am Continiously Getting Error For Following Line Of Code, It Work Fine In Other Database
Am I Doing Any Mistake
if (sh3itno != "" && dpsh3no != "")
string queryy = "SELECT [CHEQNO] FROM [SH3MAST] WHERE (([CHEQDATE] = " + chqdate + ") AND ([FAVOUR] = " + favour + ") AND ([CHQTYPE] = " + ctype + ") AND ([TRSTN] = " + trstn + ") AND ([TRBANK] = " + trbank + ") AND ([SH3ITNO] = " + sh3itno + ") AND ([DPSH3NO] = " + dpsh3no + "))";
OdbcCommand cmd3 = new OdbcCommand(queryy, connen1);
string chqno =cmd3.ExecuteScalar().ToString(); (Here Iam Getting Error)
tbl.Rows[i]["cheque no"] = chqno;
[OdbcException (0x80131937): ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).]
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +39
System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, Strin
please help - the problem is in post subject.
I have lots of warnings with following text:
"Warning 10 Element 'HyperLink' is not a known element. This can occur if there is a compilation error in the Web site, or the web.config file is missing. C:\Users\Pavel\Documents\Visual Studio 2010\WebSites\BioWebSite\ToScientist.aspx 26 18 C:\...\BioWebSite\"
But web.confg is there! And there's no compilation error!
Site builds just fine. And If I upload it to my hoster - it works!
But with all these errors I cant add controls to pages - VS2010 adds hyperlink without ID, and intelisens stoped to work.
Strange, but in my other project (web-application) I have no such difficuty.
It was doing exactly what I expected until I added more than 1 property to it. It seems if I set the value of a property this, in turn, sets every property in the handler to the same value. It's blatantly obvious I didn't have the understanding I thought I did on this. :-)
Could someone point out what I'm missing? I figured it had something to do with the "shared" but if it's not shared then I would have to declare an instance on my page which would kinda ruin the state of my variables (otherwise, I'd just put them all in my class), right??
Private Shared _strStudentName As String
Private Shared _strSchoolID As String
Public Shared Property StudentName() As String
If (HttpContext.Current.Session(SessionHandler._strStudentName) Is Nothing) Then
Set(ByVal value As String)
HttpContext.Current.Session(SessionHandler._strStudentName) = value
Public Shared Property SchoolID() As String
'constantes para auxiliar na verificaÃÂ§ÃÂ£o do cÃÂ³digo
Private Const Ascendente As Byte = 0
i have a problem to bring the data from the oracle (external database) and the
sql server together (with similar data). The linq entities are linked to each
other. The structure is like different countries with different cities and so
on. To display these "non original linq objects" i need to put them
into entities (linked to each other). Now i add some of them to my sql database.
But for every entity i must check the connection to the other objects i don't
want to add and delete them (otherwise linq will add all the connected objects, even those I don't want to add). If this goes wrong the whole input-method crashes. Is there any
other possibility, except from checking every single entity and removing unwanted connections, to handle this procedure?
Thanks a lot,
We have Usage Analysis enabled on our employee portal farm. The SSP in this farm crawls all local SharePoint sites and one child farm. When we view search and query reports, one of the site collections (in a dedicated web app) is missing.
All other web apps/site collections appear in the search/query reports. The missing site collection is using the standard search pages and web parts - no customization with the object model that might break usage logging.
Has anyone else ran into this or know the solution?
I realize this is probably going to be one of those vague questions that I am not going to get much help on here, but I thought I'd give this a shot before we go the MS Incident route on monday.
We have tried to setup Kerberos between MOSS 2007 AND SSAS 2005 to no avail. We have been through the knowledge base articles outlining the setup multiple times with all the experts on MOSS and Security here where I work. We've used other materials
we have on kerberos here. But the end result is that the double hop is not happening. We are trying to connect three ways: excel services, ssrs 2005 in integrated mode, and Sharepoint KPI's (using analysis services). In every case the connection
is not happening.
Other details are that the ssrs integrated mode seems to be setup right because I do get a report (albiet all it has is a connection error message). Excel services works fine if I use the unattended service account, but when I switch the odc file to
windows (should cause kerberos to kick in) it fails. When I try to add a kpi to the kpi list it can't retrieve a list of kpi's from ssas.
In all cases I am the user trying to perform these operations, and I have total access to the cube -- I'm the developer. I have no problems connecting to the cube directly through excel, so the security at that end passes t
i have a list with infopath form now i need to display the attach button when anyone try to edit items but i can't find it only in the menu i have only delete item icon and spiling icon.
anyone have any advice about this
i using moss 2007
We're running two MOSS 2007 environments that are (should be!) identical for Development and Validation. We don't have Production set up yet to compare...
In DEV, when you go to the Site Settings > View All Site Settings > People and Groups > Groups, you see a "1 - 100 >" link at the top right to page to the next 100 groups. In VAL, we do not see that link even though we have more than 100
Groups (the list ends on the first page with the letter "l").
Everything we have looked at between the two systems looks identical, has anyone seen something similar and has a fix? At this point we're waiting until we get the PRD environment set up to compare because we're stumped. Any help would be appreciated,