Answer Questions

• Zenaku213 Passing constants in data flows

  Hi Does anyone know what would be the best technique to use for passing constants into data flows shapes For example if I had a lookup that required a static value to be passed into it as part of a concatenated key etc... Cheers Al Use a derived column transform with a constant as expression... ...Show All

• Ryan Garaygay A Problems after the install of the Hotfix

  After installing SP1 and then the hotfix: http://support.microsoft.com/Default.aspx id=918222 We now get the following error when trying to work with date parameters in Report Builder: Query (6, 117) The '[VBA].[DateSerial]' function does not exist. ---------------------------- Semantic query execution failed. ---------------------------- Query execution failed for data set 'dataSet'. ---------------------------- An error has occurred duri ...Show All

• Lars Lautrup-Larsen Report Viewer control and ASPX

  I am trying to use the Report Viewer Control in an ASPX page but getting the following error "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method". This is with September CTP of SQL Server 2005. I am not trying to set any DTD, the same report works if displayed using the WinForm viewer control. ...Show All

• jmsigler2 SQL Native: Connection refused by using IP

  Hi!!! I got a problem, if i try to connect with SQL Native client by IP (exemple: 192.168.1.2\MYDATABASE) it doesn't work. But I use: HOME\MYDATABASE it works. But in the 2nd case i cannot connect to SQL Server from another computer. Thanks fr your help. fred This tool is located under: Start Menu -> Programs -> Microsoft SQL Server 2005 -> SQL Server Surface Area Configuration. ...Show All

• Sean_Kim Problems with Parameterized insert SQL with OLEDB Destination

  Hello, I've searched around and can't find any references to the problem I'm having. I'd appreciate any ideas or input. I'm trying to use the OLEDB Destination for an insert at the end of a long data flow. I need to parameterize the input, and for some of the columns I need to use literal values instead of parameters. It seems like this should be the most common thing in the world, but I'm at a loss to get it to work. I type in the SQL statement ...Show All

• houtexwebdev Problem with managed code simple example "Target string size is too small to represent the XML instance"

  I am trying to understand creating SQL Server projects and managed code. So I created a C# SQL Server Database project and named it " CSharpSqlServerProject1 " and followed the steps in the following "How to: " from the Help files: " How to: Create and Run a CLR SQL Server Stored Procedure " I used the exact code in this "How to: " for creating a SQL Server managed code stored procedure (see belo ...Show All

• ivanc RS 2005 and RS 2000 on Windows XP

  I installed a new instance of RS 2005 on a Windows XP machine already running RS 2000.  Install and configuration of RS 2005 went fine (using the Report Server Configuration Manager). However, after getting everything up and running with the new instance of RS 2005, I had a problem with RS 2000.  When trying to open Report Manager, I received an error concerning the symmetric encryption key.  The report server complained that the ...Show All

• Il-Sung Lee - MSFT Performance Issues with Analysis Services 2005

  Hello I create a cube using SSAS 2005. The cube has 2 years' data. There are 4 dimensions (including date) . Thee are not large dimensions. THe largest dimension has 300 members. (other than the date ofcourse). I am facing serious performance issues while querying the cube. each query (click on a dimension member) takes about 15 seconds. I noticed that SSAS was using only 55 MB of memory - eventhough we have 2 GB on the machine. Th ...Show All

• Nitesh Ambastha data source connection problem

  Hello, I created a new data source file for my existing database. While I am changing the data source for the datasets, I got the following error message and didn't allow me to make the connection with the new data source. By the way, I connect most of the datasets to the new datasource. I don't know why this error happened. TITLE: Microsoft Report Designer ------------------------------ A connection cannot be made to the database. ...Show All

• VandyDave Export from SQL To SQL Mobile

  Supposedly it is possible, but I can't figure it out... Simple - export data from SQL Server 2005 to SQL Mobile SDF. One would think to use the Export from SQL Server 2005, but no provider seems to exist. Or in VS 2005 - can't figure that either. Roger SSIS is the replacement for DTS, its well covered in Books On Line you can create SSIS Packages from inside BI Developement Studio. ok at this point I suggest you go try the integratio ...Show All

• Andrej Benedik Could not load file or assembly ADODB, Version=7.0.3300.0

  I have an application broadly deployed (about 10 computers). As of yesterday, two of these computers are unable to start the application, and failing with the error below. All other computers run the application just fine. System.IO.FileNotFoundException: Could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified ...Show All

• shade_rigal Alerting on SQL Server events in SQL Server 2005

  In SQL Server 2000 I have several Alerts set to respond to SQL Server events. One in particular is 3738 which lets me know a database is deleted. In SQL Server 2005, this event is not set to log, and therefore I am not getting the alert to fire. I tried to run sp_altermessage, but it will not let you modify system messages. I configured a WMI alert to trigger off of SELECT * FROM DROP_DATABASE, and this tells me that a database has been deleted ...Show All

• Saviourmachine generate table or database schema

  what is the sql servre equivalent to 'describe' keyword. how do we generate the schema of the database and tables of a database. schema here refers to column names and its types. Thanks, that was very helpful. is there a way to just list the column name and column types of the tables in a database created by the user and not the system tables. Hi, have a look at the INFORMATION_SCHEMA views, in yo ...Show All

• John Lemire Failed to generate a user instance of SQL Server

  Hello all, I unisntall products as it are recommended (VS 2005 and SQL Server 2005 beta 2) in readme.txt of MSDN products subscription... I install VS 2005 Pro and I have no problem during install. Now, if I want to open database, I have this error mesage : "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." In MBSA report, I see that the folders of SQL ...Show All

• Eigil SMO Connection String conversion

  Hi, I am using SMO in my application to retrieve data from SQL Server in order to display it in the UI (such as DB list, tables list, etc.). Eventually the user has a connection definition screen, in which he inserts his data. The thing is that in the background my application needs to use this data to connect via OLE DB. Is there a way to convert the connection string generated by SMO to an OLE DB connection string Thanks. ...Show All