Answer Questions

• GethWho Major Problem!...Multiple user connection problem in reporting service 2000 with SOAP

  Hi Everyone, I am having a big problem here. I am using Reporting Service 2000 and Visual Studio 2005. I have developed a custom web control which communicates with reporting web service and displays report. I pass username, password and domain information as network credential for communicating with report server (report server is remote). This is a web application in which users can see reports on the web page which uses my custom web control. Everything works fine when there is single user. But when another user logs onto website and tries to access same or different report it seems like connection of the first user gets lost. And everything crashes for first user and for second user it works fine. In fact if second user is ...Show All

• Jeremy Jarrell Windows Vista and Setup Question

  Hi, I was finally able to get my hands of Vista so I excitely upgraded my PC to it yesterday. After the installation goes smoothly and I ran the setup files from my SQL Server 2005 Developer Edition and I found that the setup script cannot detect IIS (perhaps it is due to the fact that Front Page extension is no longer part of IIS 7.0 ) - So I faced with the problem of not able to setup Reporting Service on my PC.... Does anybody faced the same problem and how to fix this issue Thanks for the information in advance! Mark There is a KB that documents how to configure IIS7 in order to be able to install Reporting Services. I've included a link below for Vista Beta 2, but the instructions are pretty similar for RTM: ...Show All

• jon albinini Double Quotes in CSV File

  I have a lot of data coming in from CSV files.  I have many CSV files (~20), with varying amounts of data- but some are quite large (largest file is ~230mb) I'm trying to import it into a SQL database via SSIS, but the data is a little bit frustrating.  I have data that looks like this: "Text from vendor ""Vendor Name, Inc."" blah blah", "Next string", "", 1234 Many things to notice here - as well you can imagine some of the difficulties here. After parsing, this data should have 4 columns- Column1                                    &n ...Show All

• RAMPRAKASH How do you SELECT just one row?

  Hi All... How to you SELECT just one row from a table when you dont have something to match a field with That is how would I get only the first record with the following statement: SELECT * FROM MyTable ORDER BY DateAdded Thnx! --- Curt Thanks, All!! I knew it'd be easy - just didnt know the magic word.... It doesn't make sense to return just one row if you aren't matching on something... You can, however, do: - select count(*) from MyTable - select * from MyTable where DateAdded = (select max(DateAdded) from MyTable)) - select * from MyTable where DateAdded = (select min(DateAdded) from MyTable)) - select top(1) from MyTable order by DateAdded (which is real ...Show All

• spshah Newbie problem using Windows Groups and Schema

  I created a Windows Group in Active Directory ("Database1Users"). populated it with users, and planned to allow everyone in it to have access to a sql 2005 database. I went to the sql server, Security (at the general level), Logins, New login, and created the Login "<domain name>\Database1Users". I assigned "Database1" as Default database, selected the database and assigned it to the above user name (which is actually a group name). I also typed in a default schema of "dbo" and gave the user account the role "db_owner" (just learning....) . Pressing OK gave me this error message: >>>> The DEFAULT_SCHEMA clause can not be used with a Windows Group or with principal ...Show All

• Sioln How to concatenate columns in parameter listbox (MDX)

  In the Data pane one can add a dimension and check the parameter box. The chosen hierarchy determines what columns is used to display the listbox. Is it possible to concatenate 2 columns Thanks, Henk ...Show All

• S&amp;#233;bastien Nunes AMO Security Scripting Problem

  Hi! I have a little program that creates roles for a catalog and cubes. The roles is created fine and all the read permissions on the different cubes as well. Also adding different users to the roles is no problem. Then when i look in BIDS( open analysis services database) everything looks exactly as it should. However, the different roles does not work for the users that are added through the script. But, if i manually add a user to one of the created roles, it works for that user. Anybody who knows what is going on   The roles both have users and user groups in them. Hi! This is basically what i do. Role role = _oDb.Roles.Add(_sRoleID); role.Members.Add(new RoleMember("domain\user"); role.Update( ...Show All

• venup Filtering In Merg replication

  Dear ... This is one of sql server 2005 's users. I put filter for one of my merge replicate articles .But it dosent work correctly .plaese help me to set my article correctly. Best regards R.Marandi I need to know how you setup the filter for your publication, what the publication looks like, etc. Technical details. I understand what you are trying to do, but if you have a switch set incorrectly somewhere, then we'll only be able to find it with complete technical details on your publications. What is the contents of that table in both databases on the subscriber What is the value returned by the function in both databases What is the value returned by the function within both publ ...Show All

• Saruth Connect problem with DMO and SQL Express

  Hi ! I try using DMO with sqlexpress . I write program in VFP8. osql = CreateObject("SQLDMO.SQLServer") With oSQL .LoginTimeout = 10 .LoginSecure = .f. .Connect("MARIUSZ\SQLEXPRESS","sa","mariza1234") EndWith Metod connect get error message "OLE Idispatch exception code 0 ....(ODBC SQLState :08001):[microsoft]ODBC SQL Server Driver][DBMSLPCN]Invalid connection.[microsoft]DBMSLPCNConnectionOpen (ParseConnectParams))... What is wrong . I install " Microsoft SQL Server 2005 Backward Compatibility Components" and connection to database through odbc run OK. pc_constr="driver="+"{SQL Native Client}"+"; server="+"MARIUSZ\SQLEXPRESS"+"; " + ...Show All

• Hery Susanto WR system error 126

  I'm getting this error when trying to run Query Analyzer Server Msg 160 , Level 16 , State 1 . Specified driver could not be loaded due to system error 126 (SQL Server) This is a new SQL Server 2000 install on a PC that has had different versions of SQL Server installed previously, including 2005. I'm assuming this has to do with an incomplete uninstall. Is there a fix or workaround for this HI Nicolas, Can u tell me steps that u implemented for removing oracle error. Even I am also getting the same error Thanks, Rakesh When you installed SQL Server 2000, was SQL Server 2005 already installed   If so, installing 2000 after 2005 is not recommended, and probably not sup ...Show All

• newgreen does Internet Explorer generate logs.

  Hi, I have an query. Does Internet Explorer generate logs files. If so where does the files get generated. Thanks in advance. Try www.sysinternals.com filemon to determine where logging is happening. What kind of log are you looking for IE logs your internet history in your documents & settings - temporary internet files. IE 7 has it's own log source in Event Viewer. Depending on your logging needs, you may need a 3rd-party tool. You may have better luck in a different group, since this isn't really related to Reporting Services. cheers, Andrew ...Show All

• OmidQRose Blank pages in report preview

  Hello, Everyone, I'm new to Reporting Services.  I wrote a report today containing one grouping.  Everything appears all right in the report preview, except that every other page is "blank", i.e., shows only the page header and page footer; all grouping and detail information is missing.  The data on the page following the blank page seems to pick up where the previous non-blank page left off, so all information seems to be present within the report. The report width and height properties are typical portrait-style  -- 8.5 x 11 inches.  The columns do not "run off the edge" of the report page boundary.  I haven't selected any page break for the grouping, as the grouping detail is typically only a few rows ...Show All

• CirdanCelebrindal loading old data from Staging

  I'm populating a table (B) in SQL Server from a Staging table (A) using a stored procedure.At any point of time, the Staging table holds 60 months' old data.In the first load of the destination table B, I get 13 months of old data whereas for every subsequent load,I need to load the data for the most recent month and delete data for the 1st(oldest) month. For example, if the load procedure runs on December 02,2006, it should pick data for the month of November,2006 from the Staging table and delete data for the 1st month. I have a column DATA_MONTH_KEY in table B which maps to the column DATA_MONTH in my staging table A. I get the data for the first 13 months using: (B.DATA_MONTH_KEY BETWEEN ( DATEADD(month,-13,@startdate)) AND @star ...Show All

• Gert Christiansen Partition Slice Property

  I'm having trouble processing a partition that has a slice property selected. My data is partitioned on a montly basis, hence the slice is along the lines of [Date].[Date Hierarchy].[Month].&[200607]. When I do process index or process full, it fails. Iget the following error: Error: The script threw an exception: Errors in the OLAP storage engine: The slice specified for the Half Year attribute is incorrect. Errors in the OLAP storage engine: An error occurred while processing the indexes for the Viewers 200607 partition of the Viewers measure group of the Viewing cube from the BDW database. I didn't type the mdx myself, just click and drag from metadata pane. Anyone know why this might be happening Thank. Rahil ...Show All

• Flap Inserting Symbols into Fields (like ?)

  I am attempting to insert a trademark symbol into a database field but it is not working. Does anyone have any ideas on how to do this properly Any help would be very appreciated. Since the Symbol is Ascii charater it should insert on Both Varchar & Nvarchar fields properly. The equalent to the symbol is char(153) insert mytable (col1) values (char(153)) ...Show All