Answer Questions

• Langoti Semantic Model

  Hello, I got the following error while trying to create a report model: The semantic model is not valid. Details: The element 'Entity' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling' has incomplete content. List of possible elements expected: 'IdentifyingAttributes' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling'. Line 943, position 3. (rsModelingError) (Report Services SOAP ...Show All

• jackstraw Can't Attach Database using SQL Server Management Studio Express

  I am having a problem Attaching, well actually not being able to see a database when attempting to attach it. I suspect this is more of a security issue rather than a problem with Management Studio, but I can't figure out what is happening. If I copy a database to Documents and Settings\All Users\... and attempt to attach I can see the file in the selection tree. This also is the case if I copy it to Documents and Settings\Default User\... Bu ...Show All

• HitechRider Cannot install SQLExpress after uninstalling June CTP

  I try to install SQL Server Express after uninstalling its beta and get the following error in the log file.  Can anyone help me   Thanks.   Microsoft SQL Server 2005 Setup beginning at Thu Dec 15 20:28:39 2005 Process ID      : 110612 c:\e7b4645908c60721e3107fa330d0184a\setup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2005/11/15 20:28:38 Complete: LoadResourcesAction at: 2005/ ...Show All

• Chas75287 Failure to run when using DTC

  Does anyone hany any experience of using SSIS with MS DTC I have a package that runs successfully. When I switch it to using transactions (i.e. TransactionOption= Required ) it fails. I get the following messages in the log: -Starting distributed transaction for this container.  -Failed to acquire connection " <connection-manager-name> ". Connection may not be configured correctly or you may not have the right permissions on this ...Show All

• Dotnetjunky Using resultset.IsDBNUll and getting error

  I've got the statements: if (rs.Read()) { if (!rs.IsDBNull(endTimeColumnOrdinal)) { tsDuration = rs.GetDateTime(3) - rs.GetDateTime(2); } else { // other stuff goes here } } But this chokes on the call to the function rs.IsDBNull(), with the error: "No data exists for the row/column". So what is the proper way to check for the possibility of it being NULL, if not that method Seems like that is what it is there for. Thanks! - ...Show All

• NMM How to insert a byte() to a blob column?

  Hi everybody,     I don't where to asked this question in this forum. How do you insert to a column of a table with a blob or binary datatype if there is one, from a byte() datatype  What is wrong How can I fixed this I need help. Thanks. Code: string sqlText = "Insert table1(id, dataByte) values('" + id + "'," + byteData + ")"; OdbcCommand cmd = new OdbcCommand(sqlText, odConn); //opening connection here int iRes = cmd.Execu ...Show All

• bambinor Help says ODBC is Available. Where?

  In BOL it clearly says that you can "use the Microsoft OLE DB Provider for ODBC Drivers provided." in relation to Analysis Services. ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/uas9/html/9fab8298-10dc-45a9-9a91-0c8e6d947468.htm Unfortunately, this provider is not in my list. Here is the full text section from help. "Other relational systems support the older Open Database Connectivity (ODBC) specification but do n ...Show All

• fred79g Reporting Services

  About a month ago I was able to download the Reporting Services for free to use with SQLExpress. Now I am unable to locate the download. I upgraded my PC so need to reinstall everything. Anybody know where the download is. Thanks You are looking for SQL Server Express Edition with Advanced Services. Download link: http://www.microsoft.com/downloads/details.aspx familyid=4C6BA9FD-319A-4887-BC75-3B02B5E48 ...Show All

• Sunchaser Strings as measure

  Is it possible to have strings as a measure I tried to build a cube with string measures and I choose no aggregation function for that measure, but I always get the error message: Measures are fundamentally numeric values, so strings do not make sense. The only exception is Count and DistinctCount measures where you can point to a string column (since you're just counting these values). I am having the same p ...Show All

• BeGran Death of ODBC

  ODBC is not supported as a data source in SQL Analysis Services 2005. ODBC is not supported as a data source in SQL Reporting Services 2005 Model Designer. Any thoughts Joe With regard to Model builder - in SQL Server 2005 Reporting Services supports building models on top of Analysis Services and SQL Server 2005 and SQL Server 2000 data source.  This is not to be read as a 'death of ODBC', rather ...Show All

• VimalaLawrence Creating SQL 2005 Logins during installation

  Hello, We use one standard account with a password that is never given out. In SQL 2000 we had a script to extract the password in encrypted format so that it could be run as part of the installation process. That same process does not work for SQL 2005. Below is a sample of the script that we were deploying for SQL 2000 installations. --------------------------------------------------------------------------------------------------------- ...Show All

• Ahoapap Please help with explicit permissions for a database

  Hello! I've just installed SQL Server 2005 CTP and now I have a question.  If I open any database properties window, click "Permissions" tab in the bottom grid (under the title "Explicit permissions for...") I see several columns and one of them is "With grant". When I click a check box in this column then "Grant" chek box is automatically checked as well. Please explain me the purpose and meaning of "With Grant" check box. (I do under ...Show All

• IndControl ~* Total Pages mismatch *~

  Hi, The number of pages in the report viewer and the number of pages in print preview are different. how could the prob. be resolved... Thanks in advance. Cheers Chakri. Hi, My Report Page size are as follows. Width - 8.5 in Height - 11.5 in all Margins set to 1 cm. Body Size are as follows. Width - 7.5 in Height - 1.95 in Anythings else i need to change Thanks in advance. Cheers, ...Show All

• raj78 Adding Reference and Importing .NET into Script Transformation

  I have a .NET component that I want to import into a Script Transformation of a Data Flow. Going into the script code (editing Script transformation and clocking "Design Script" button), I try to "Add Reference" to the component (Add Reference selection under "Project" menu), but I do not see it - nor do I have the option to Browse for the component. How do I establish a reference to an external .NET component so I can use it in my transformati ...Show All

• helsingfors SQL server 2005 DTS conversion, activex and MSDASQL

  Hi all I am migrating some DTS2000 packages to SSIS via the migration wizard. However there is an activex script in each DTS that connects to an AS400 to retrieve record count for integrity checking. Under SQL server 2000 this worked fine but now it errors with "The OLE DB provider "MSADSQL" has not been registered" how do i get this to work i suspect its because this is a 32 bit dll and my new system is a 64bit sql server ...Show All