Answer Questions

• BigAl_NZ SRS 2000, ASP.NET 2.0 (Programmatic Render)

  Hi, I have read quite broadly on the issue of compatibility between SRS 2000, and ASP.NET 2.0. I gather that ASP.NET 1.1 and ASP.NET 2.0 can co-exist with each other and with reporting services 2000. What I now need to do is call the render web method for a report in SRS 2000 from an ASP.NET web page. Does this web service method work in that way (from .NET 2.0). I need to know that I can use this method while our client continues to debat ...Show All

• Myron Marston How to uninstall SQL Server 2005 Sept CTP and install SQL Server 2005 April CTP?

  I installed the following components in my laptop in this order: 1. .NET Framework 2.0 Redistributable Package (x86) (From microsoft website) 2. SQL Server Express 2005 September CTP 3. Visual Studio 2005 Beta 2 Version (I have the DVD for this) I realised that SQL Server Express 2005 September CTP is not compatible / does not work with Visual Studio 2005.  Visual Studio 2005 can only be used together with SQL Server Express 2005 APRIL CTP ...Show All

• mspres Migrating from 2005 to 2005 Mobile

  Hello All, I have a database created on SQL Server 2005 and now I would like to migrate the table structure to a SQL Server 2005 Mobile database. Generating the scripts and running them against the mobile database generates a lot of error that I suppose are caused by not supported features or keywords on the mobile engine. I would like to know what are the best procedure for doing such migration. Note that this has nothing to do with repli ...Show All

• aatik Differences between MSDE and SSE2005

  Good Afternoon, Everyone. I know SSE2005 is built on Sql Server 2005 and MSDE was built on Sql Server 2000 so let's not start a thread discussing that. My question is more about the concurrency governor found in MSDE. I've heard people talking about the concurrency governor in MSDE being removed in SSE2005. Instead, performance is limited by the server configuration; one CPU, 1 GB RAM, and a maximum 4GB database. Can anyone confirm this ...Show All

• Thomas Kaiser Microsoft OLE DB Provider for DB2

  The Microsoft OLE DB Provider for DB2 can be downloaded as a part of the SQL Server 2005 Feature Pack located at: http://www.microsoft.com/downloads/details.aspx familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en Thanks - it will be good to hear if anyone has comments on their experience with this provider. Donald Alright. Let me post my connection string so you can compare with yours. Provider=DB2OLEDB; ...Show All

• Danik How to set empty a space from a derived column expression?

  hi, This field comes from a flat file and sometimes own zero and sometimes own a empty position (after 'EUR'): 2006053000499236000005307700108287457080200408287452006052953990000000010000EUR 2006053000499236004414989200101423426004400501423422006052953990000000010000EUR0 [Column 12] == "0" [Column 12] : TIA So you are inputting a DT_STR but outputting a DT_WSTR Is that correct That seems like a strange thi ...Show All

• Stef_T NS 2.0 and SQL Server 2005?

  Will NS 2.0 work with SQL Server 2005   Or does it require SQL Server 2000 for the database components Dave Fackler Hi Dave - Rama is right. SQLNS v2.0 will not work with SQL Server 2005. There are of course a couple of workarounds for some situations, but these do not seem to address your primary objective. Here they are just in case it helps out. 1) If the problem is related to custom components (even ...Show All

• Mangix Database Diagram error on SQL 2005

  I upgraded from SQL 2000 to SQL 2005. The database owner is sa and I am logging in as sa in Management Studio. But when I click on Database diagrams I get the following error "Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, ...Show All

• .NetRocks SQL Server 2005

  I have sucessfully installed SQL Server 2005 onto one of our test servers. I then installed microsoft developers edition onto a client pc, but when I try and connect to one of the databaes I get the following error message: TITLE: Microsoft SQL Server Management Studio ---------------------------------------- Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink ProdName=Microso ...Show All

• Mikeyw Can not connect to a flat file

  Hi all.... With Visual Studio, I have created a new "Integration Services Project". As per the tutorial instructions, I right-click in the "Connection Managers" box, and I select "New Flat File Connection" When I do so, I get this error: The new connection manager could not be created. Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap) Any suggestions   (BTW, I'm using 64-Bit Enterprise edition for x64) Thanks! Forch & ...Show All

• RONE162622 Data type conversion SQL Server to Access

  Hi all, I have two conversion problems while exporting data (using the "Import and Export Wizard") from SQL Server to an Access 2003 file: Varchar (even smaller sizes like 43) is getting converted to "long text" (type in Access: Memo) Bit is getting converted to "short" (type in Access: integer) Does anybody know the reason for this And how to change this behaviour I could change the data type with &q ...Show All

• Gad Rosenthal Problem with Boolean Nullable parameter in Report Viewer

  I have a problem with a nullable boolean parameter. By default, the value is Null and that's working fine. The User clicks either true or false, view the report: fine again. However, from that point on, if the user checks the Null checkbox and submits the reports, it reverts automatically back to the last True or False value. Is this a known problem Or am I doing something wrong Eric You are ...Show All

• GuidoBrunner SQL 2005 Standard Replication

  Hi, We are looking into implementing SQL 2005 on one box and have SQL 2005 Reporting Services run on another box with its own replicated database. Mirrioring would not work in this scenario as the primary box has to be down for the secondary box to accept any incoming request. My questions here is Microsoft website states that Transactional replication is supported for SQL 2005 Standard Edition, but I did watch some presentation on microsoft ...Show All

• Terkamian try to setup membership with ASP.NET configuration

    When I whant the use the new ASP.NET configuration tool (2005) and I want to define a provider I get the following error. You should know that on installation of VS 2005 SQL-Server Express did not install and I installed SQL-Server 2005 (shiped with VS 2005). So now it seems that VS waits for the Express edition. I changed under Tools/Options/Database Tools/Data Connections the SQL Server Instance Name to "MSSQLSERVER" but this does ...Show All

• Andreas Asterlund Debugging Custom Report Data Processing extension

  Hi, I've created our own custom report data processing extension and it works successfully.  I also know how to debug the extension while in the Report Designer environment (in Visual Studio).  However, is it possible to debug the extension in the run-time mode.  That is, when I run Report Manager to view the report that usees this extension. Thank you very much Please help!  I still don't know how to debug during run ...Show All