Answer Questions

• HowardRoark System.Data.SqlServerCE.dll reference causes error ...

  Hello All ... I am attempting to create a program that will run on the PocketPC 2003 environment. I have upgraded Visual Studio to SP1, I have installed SQL Server Compact Edition on my development machine and I have installed SQL Server Compact Edition Tools For Visual Studio on the development machine. I have created a new project Visual Basic - Smart Device - Pocket PC 2003. I have created a form for user input. I build and deploy the form to the Symbol Pocket PC to test - no connection to data and it works. I then add a reference to System.Data.SqlServerCE.dll and rebuild and redeploy the application to the handheld. When I attempt to open the form I receive the following error: psmPocket.exe NotSupportedException System.D ...Show All

• WXS123 Couldn't connect to reports

  Hi, I'm not able to browse through http://localhost/reports . When I'm trying to connect it gives me "Server Error in '/Reports' Application."At the same time I'm able to view Reportserver.At the same time I'm able to view Reportserver.(i.e)http://localhost/reportserver please can anyone suggest me some solution to this problem.. Server Error in '/Reports' Application. Hi, What are the security settings in IIS for both sites Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog Did you migrate from one domain to another Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog Is this the same as for the report server By de ...Show All

• robhare Why is there a 256 JOIN Limit in SQL Server 2000/2005?

  Hi, Does anyone know why there is a 256 JOIN limit in SQL Server 2000/2005 Are there any plans to raise this limit (or do any add-ins exist to raise this limit) Thanks. BTW, a separate question -- is there a limit to the number of rows a SQL Server 2000 database table can have What about SQL 2005. Thanks. Almost sounds like the classic "Noone will ever need more than 64k memory..." Unfortunately, I've run into this problem as well. In my case, SSAS is generating queries to populate and optimize it's dimensions. I cannot control how it creates those queries, but it is trying to use more than 256 joins to do so. (My data warehouse only has 43 tables btw.. so it must have to do with ...Show All

• Tracy Woo How to block access during peer-to-peer transaction recovery?

  Is there a clean way to block access to a peer which has been offline, during peer-to-peer transaction recovery (while the outstanding transactions are being applied) Thanks, Liston Hi Liston. You could set the db into priviledged user mode, which would only allow dbo's to connect to the given database. Of course, this assumes that standard users/application users aren't dbo's as well. Aside from this, you'd have to write custom code to handle the scenario... HTH, Chad Chad - thanks. Thought I might be missing something more straight forward - will do. Liston ...Show All

• Ilan D Forms Authentication in Reporting Service-- ReportServer\App_Data' is denied error is coming

  Hi, After doing Forms Authentication from the link http://msdn2.microsoft.com/en-us/library/aa902691(SQL.80).aspx When i navigate to http://localhost/ReportServer , I am getting following error "Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.7\Reporting Services\ReportServer\App_Data' is denied." But there is not folder like App_Data in under ReportServer Can anybody tell me What is the cause of Error --Thanks ...Show All

• John Risk oracle oledb provider not registered in local machine

  Hi, I am trying to establish a connection to an Oracle database using the following code in a script task: Dim oOleDbConnection As OleDbConnection Dim sConnString As String = _ "Provider=OraOLEDB.Oracle;" & _ "Data Source=DBxxx;" & _ "User ID=Userxxx;" & _ "Password=Passxxx" oOleDbConnection = New OleDb.OleDbConnection(sConnString) oOleDbConnection.Open() When I execute the script task, I receive the following error: The 'OraOLEDB.Oracle' provider is not registered on the local machine. Am using the correct provider I do not know how to resolve the said error. Here are some facts: Oracle 8i is installed. Tnsnames.ora is updated. I have successfully ...Show All

• Pockey is SSIS wonderful?

  Hi guys, I'm using sql 2000 now but eventually will upgrade existing server to sql 2005. currently we only have OLTP dbs. I would like to set up data warehouse & OLAP functionality to drive reporting from the system, is SSIS the product I need can you please give me the suggestions regards TheViewMaster wrote: SQL has better maintainability - changes can be made to SPs, VIEWS without having to go through of hassle to recompile & deploy package Now I *really* disagree with this statement. Using package configurations, you can create a package such that you'll never have to touch it again. I frequently use configurations to store sql so that I can make changes ...Show All

• Michael Covington Cube Deploy Error

  Hello, I'm trying to deploy a cube on Analysis Services and I'm getting the next error: Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: DSAP PRODUCTO of Dimension: DSAP PRODUCTO from Database: SAPIN_BI, Cube: Sapin BI Dllo, Measure Group: DSAP COMBOS, Partition: DSAP COMBOS, Record: 1. I'm sure the data is consistent and has integrity.... and I verified It ... Could you please give me a clue What do I have to post or which script do I have to send you Thanks a lot ! Based on the errror message, it would appear that your fact table has a column named NMPRODUCTO_KEY and a record was read from the fact table that has a value of 1 in tha ...Show All

• eTape BCP fails with 134 columns

  I'm trying to BCP from a csv file to a table, both have 134 columns. The error message coming back from BCP "SQLState = 37000, NativeError = 170 Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '1'." By reducing the number of columns in both csv file and table to around 20 column , the bcp call will work and the data will load into the table.Here's a sample that shows the problem The command line I'm using to call bcp:- "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\bcp.exe" em.dbo.mytable1 in c:\temp\_rrs\datafile.csv -S SQL_SERVER_NAME -U username -P password -t "|" -c -F 2 The version of BCP this is using :- 8.00.194 on SQL Server 2000. Sample data in datafile.csv ...Show All

• Jonathan Clark RDA Pull method not creating tables/inserting data

  I can't see what is going on, this is the situation: I call the Pull method, specify the table to be affected, the query to be used, the connection string to the remote SQL server , the tracking options (On) and the Error table. The pull method executes with no errors however, no table is ever created. I don't know why, here's what I have done so far: I read the SQL BOOKS ONLINE help on preparing RDA, I set up the IIS virtual directory for anonymous access and on the connection string I send in the user name and password for the SQL server , I went into the SQL Server and grated access to the user name to the database that I am going to access and I made the user a db_owner. So, according to SQL BOOKS ONLINE I have everything right however ...Show All

• doctatrips SqlCeResultSet - Problem After Deleting First Record

  Hi, I've noticed that after the first record from a ResultSet is deleted, HasRows property throws an exception like "The current row was deleted." Method ReadFirst() throws similar exception as well. More details: 1. Create a ResultSet: ExecuteResultSet( ResultSetOptions .Updatable | ResultSetOptions .Scrollable | ResultSetOptions .Sensitive) 2. Let's say, there is no records in the resultset. Insert two new ones. Then call: ReadAbsolute(0); Delete(); HasRows; and the exception is thrown. 3. Then you can call ReadFirst() or Read with the same result. 4. Now call ReadAbsolute(0). It returns true. Call HasRows, ReadFirst() or Read() and you will get the exception each time. I tried to explain th ...Show All

• stephanielauym Matrix with 2 subtotal

  Hi All, I wish to have a report with 2 subtotal using matrix control given by reporting service. CD DVD Total Price Total Qty 2.00 5.00 JOHN 5 25.00 5 JOLIN 5 10.00 5 Total Price 10.00 25.00 Total Qty 5 5 I only can came out total price(subtotal) which provided by matrix control. Does the matrix control able to come out as table above with 2 subtotal Thanks Kendy Thanks for your helps and advi ...Show All

• Andre's group numbering issue

  Hi everyone, The problem is about numbering groups. I'm trying to display data like this- 1. U.S 1.1 San Francisco 1.1.1 employee1 1.1.2 employee2 1.2 Dallas 1.2.1 employee3 2. UK 2.1 London 2.1.1 employee4 I've tried using RunningValue(1, Sum, "group_name") but it gives erroneous results. I'm using 3 lists, one at each group level. The outermost list (1st list) is grouped by "country" (group_1), 2nd one is grouped by city (group_2) and the innermost (3rd one) by employee name (group_3). I can't figure whats wrong. Can anyone help me Thanks in advance. Thank you so much. It works! The SUM aggregation w ...Show All

• Egyde overload function call

  Hi, I want to write one function like that dbo.function( number , 1 , 2 ) , but I would like to overload, and send char or number dbo.function( number, 'abx' , ' xpto' ). I would like to keep the same name, Can I do this or Do I need to write to differents functions thanks, Hi Alessandro, Sure can, in the above example, you'd simply change the returning datatype: create function fntest2 (@one sql_variant, @two sql_variant) returns sql_variant as begin Cheers, Rob Hi Rob, Yes, but when you call with float from Select clauses like select fntest( 1 , value1(float) , value2 (float) ) doesn't work I need to convert, have you tried Thanks ...Show All

• bw12117 Five new SQL Server Express Absolute Beginners Videos now available!

  In our continuous effort help new developers get better acquainted with SQL Server Express, we’ve released five new learning videos to bring the total number of videos to thirteen – that’s almost nine hours of video-based instruction! The Absolute Beginner video series is designed for new users interested in learning the basics of how to create, manage and connect to SQL Server Express databases through self-paced and on-demand learning resources. The new videos include: § Using SQL Server Management Studio Express § Getting Started with Reporting Services § Embedding, Packaging and Deploying SQL Server Express Reporting Services § Creating and Using Stored Procedures § Enabling Full-Text S ...Show All