Answer Questions

• okluge Error Opening Report in Report Builder

  I try to open an existing report definition like "Bug Rates" (or any other ones for that matter) and always recieve an error with this: "Server data sources do not match RDL". Has anyone experienced this or know of a way to fix this I too get this error. These are not reports that have been created in Report Builder by us, but are part of the MSF Agile process template with Team Foundation Server. A range of sta ...Show All

• Juan Suarez One-to-many query, returns double rows

    This part is solved, please see my question at the bottom of this topic Hi, my problem is the following, doesn't seem too hard but it's been puzzling me for hours now, and haven't solved it yet, so I need your help! I'm creating an application to read from an existing db running on SQL-server 2000. This db contains the tables:   tClient ,   tCommunication  and tAddress . All of the three tables share a ...Show All

• airwick TOP 100 ordering of Data Question

  Hi, I was trying to use the UNION construct to combine two tables. The second table was to be sorted before effecting the UNION. The first attempt was the following: SELECT emp_id , assigned_branch_id FROM employee WHERE title = 'Teller' UNION SELECT open_emp_id , open_branch_id FROM account ORDER BY open_emp_id The above was generating an error. I then tried SELECT emp_id , assigned_branch_id FROM e ...Show All

• Klingon ODBC Returning success but actually failing (SQL Native)

  I'm talking to SQL 2005 using the SQL Native client in ODBC: Here's what I'm doing: 1) SQLPrepare () -- Prepair an insert stmt 2) SQLBindParameter() -- Binding the parameter 3) Set the Parameter to a value 4) SQLExecute() -- Execute the statment 5) Set the Parameter to a different value 6) SQLExecute() -- Execute the statment Both calls to SQLExecute() return SUCCESS_WITH_INFO. The problem is that only the 1st SQLExecute() ever makes ...Show All

• keenan10000 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

  I'm having problems determining the source of this RPC Endpoint Mapper error. I'm running a web page (web server - win2k) that uses the ReportViewer control to display a server report located on a different server and domain (report server - Server 2003).    Any ideas would be appreciated. The event viewer message is: Event Type: Error Event Source: DCOM Event Category: None Event ID: 10002 Date ...Show All

• cu-blenge RSClientPrint Download

  I have an asp.net application which is launched from our B2B site. The primary purpose of the application is to allow our external clients access to reports, along with the ability to export and print. The RS2005 report viewer component was used within the application to render the reports. The problem is when the our client users click on the print button on the report viewer's tool bar, many of them are receiving a window asking them if they w ...Show All

• Smalldust Cannot figure out how to write this script?

  Hi was wondering if somebody could help on this one. I have a table called LocalisationText and a field called "ResourceText".After localization bad data went into the ResourceText field (double and triple quotes instead of singles). EG Entrada ""{0}"" en ubicacion """"{1}""""" 在或大 ""{0}"" 的命令出 User Post Code Group of Type ""{0}"" is ""{1}""  Now I have been asked to write a script that converts all the double/triple quotes preceding ...Show All

• Bob Cohen Upgrade msdb database from CTP April build

  We are currently running a number of jobs using SQL 2005 CTP April. How do I upgrade the msdb database to the new June CTP Thanks You can script the jobs. -Euan I guess that's the only way. Thanks ...Show All

• pbergeron SQL Sever 2005 only has client side?

  Why I couldn't find any datebase engine setup SQL Server 2005 Developer Windows xp Do you have enough space on the system partition Make sure that the system partition has the appropiate amount of space, othwerwise the installation can't be done. Thats something you can't change in the core installation, though you can specify the database file location you can't change the core file location. ...Show All

• bvdrsganesh1404 RAPI fails on CeMountDBVol (WinMobile 5)

  My PC app uses RAPI to install files to a CEDB database on Windows Mobile devices. Works for PPC 2002, 2003 devices, ActiveSync v3.8 and 4.1 On Windows Mobile 5.0 devices with AS 4.1, RAPI fails on CeMountDBVol with an ERROR_INVALID_PARAMETER. What needs to be done to correct this I have read about RAPI Security policy, but this case doesn't seem to apply. I am loading RAPI DLL dynamically. ex: bResult = (*pCeMountDBVo ...Show All

• JJK An incorrect or unsupported HTTP function call was made error

  Hi All, I've got this error " An incorrect or unsupported HTTP function call was made " I can't browse SQL CE Agent using IE also. How to solve this error TQ thanks Darren.. but i'm using SQL Server 2000 regardless, you should generate a new snapshot of your publication. Darren thankss Darren, I tried so many time to generate new snapsh ...Show All

• pbd 2005 SP1 install, another can't authenticate...

  win 2003 sp1 with sql 2005 enterprise. Tried SA.. Tried AD Admin, tried local administrator. Set up in mixed mode so i tried windows and sql authen... I can log in normally with SA and the password and the windows admin account. Nothing works, tried services off and on. Tried clearing everything Reinstalled completely... Only the SQL Server part fails because it requires authentication. All the other parts succeed. I don't get a l ...Show All

• ian at arcontech Visual Studio Web development possible with SQL2005's Visual Studio?

  Hi, I have SQL 2005 Enterprise installed, which also installed a version of Visual Studio called "Microsoft Visual Studio 2005 Premier Partner Edition - ENU". Is it possible to created web application projects within this version When I open Visual Studio and do new file or new project there is no web application option. I tried to install the web application add-in ( http://support.microsoft.com/ kbid=915364 ) , but that yields th ...Show All

• stevenback7 Pass XML Data to a Stored Procedure

  Does anyone know how to pass a XML File to a MS SQL 2005 Stored Procedure (INSERT/UPDATE), and how to create the stored procedure so it will accept the XML values using VB 2005. Here is an example of the XML File. Code: <MYROOT> <TableName> <Field1>String</Field1> <Field2>String</Field2> <Field3>String</Field3> </TableName> </MYROOT> Thank you. bty The following lin ...Show All

• scott xxxxxxxx Sql Configuration Problems (Desperately in need of help)

  Hi I am currently working on my final year project for uni using vs 2005, sql server express and xp pro sp2. Basically I created a website in asp.net and created a database in the app_data directory. Everything was working fine up until last week until I downloaded sql server management studio. I was experimenting with the IDE and attached the database from the app_data directory of the website to the sqlserver management studio. Ev ...Show All