problem with SQL analysis services 2000 and VB.net

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Asynchronous Sql Write ends in odd out of memory error. I am getting the following error when trying to execute an Insert Statement against a SQL database. The query is executed Asynchronousely with the command.BeginExecute() method. The interesting thing is that the error happens VERY sporatically. I do about 100-1000 writes a minute all day long with no errors and have this error thown about once every 2 weeks. I've monitored the system memory with perfmon as well as various GC memory settings directly before and after the error and there seems to be plenty of memory available. In fact there is no change in memory sizes before the issue occurs. There is no error reported by the Sql Server or in any event logs except for this single error. Any ideas? System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. at System.Data.SqlClient.TdsParserStateObject.SetPacketSize(Int32 size) at System.Data.SqlClient.TdsParserStateObject..ctor(TdsParser parser, SNIHandle physicalConnection, Boolean async) at System.Data.SqlClient.TdsParser.CreateSession() at System.Data.SqlClient.TdsParserSessionPool.CreateSession() at System.Data.SqlClient.TdsParserSessionPool.GetSession(Object owner) at System.Data.SqlClient.TdsParser.GetSession(Object owner) at System.Data.SqlClient.SqlCommand.GetStateObject() at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.BeginExecuteNonQuery(AsyncCallback callback, Object stateObject) -- -Scott Frye ----- "The person who says it cannot be done should not interrupt the person doing it." Chinese Proverb. ----- Tag: problem with SQL analysis services 2000 and VB.net Tag: 145879
  - 2
    - to buy ampicillin ampicillin online ampicillin stock solution ampicillin sodium sterile ampicillin pregnancy to buy ampicillin ampicillin online ampicillin stock solution ampicillin sodium sterile ampicillin pregnancy +++ ANTIBIOTICS +++ ANTIBIOTICS +++ ANTIBIOTICS ++ http://jhku.net/BUY-AMPICILLIN http://jhku.net/BUY-AMPICILLIN http://jhku.net/BUY-AMPICILLIN http://jhku.net/BUY-AMPICILLIN Alabama, Alaska, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, Florida, Georgia Hawaii, Idaho, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York North Carolina, North Dakota, Ohio, Oklahoma, Oregon, Pennsylvania, Rhode Island, South Carolina, South Dakota Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin, Wyoming http://ibm-news.for-um.de/showthread.php?t=1178 http://ibm-news.for-um.de/showthread.php?t=1175 http://www.salsapresse.com/modules.php?name=Forums&file=viewtopic&t=602 http://ibm-news.for-um.de/showthread.php?t=1493 http://ibm-news.for-um.de/showthread.php?t=1174 http://ibm-news.for-um.de/showthread.php?t=1453 http://ibm-news.for-um.de/showthread.php?t=1176 uti antibioti ampicillin and pregnanc ampicillin alcoho antibiotics ampicilli generic msd ampicillin resistant gen cheap flight antibiotic 500m ampicillin clavulanat ampicillin acn antibiotic sepsi amoxicillin antibioti ampicillin kanamyci ampicillin resistant gen ampicillin i ampicillin treatmen ampicillin anhydrou ampicillin actio ampicillin alcoho antibacterial antibioti ampicillin on e col ampicillin resistance gen generic side effect generic medicin cheap ampicilli ampicillin acn antibiotic sepsi generic formulation ampicillin ras antibiotic 500m synthesis of ampicilli ampicillin for dog mode of action of ampicilli augmentin ampicilli ampicillin medicatio lb agar ampicillin Tag: problem with SQL analysis services 2000 and VB.net Tag: 145873
  - 3
    - Insert data only if Table is empty in MySQL Hallo, I'm creating a Wizard in VB.NET. In this wizard I establish the connection to MySQL and then if it's successful then it creates (if not exists) a database, tables, amoung others. The question is, how do I insert data to a table only if it's empty. Logically if it's not empty, then it shouldn't insert anything. I want to add this in VB.NET code but don't know how to achive this. To get the total rows I should use this: SELECT count(*) from db.table t; But as I had said, I don't know how to make the wizard know if the table is empty or not. Hope somebody can help me on this or show me the way. Thanks in advance. Regards, iDesmet Tag: problem with SQL analysis services 2000 and VB.net Tag: 145872
  - 4
    - using parameters, yet single apostrophe dropping hello, i have some simple code that updates my db w/ a user-input string. as always, i use a Command object w/ Parameters, and pass my text in as such. like so: //conn & command SqlConnection conn = new SqlConnection(myConnStr); SqlCommand command = new SqlCommand("UpdateFoo", conn); command.CommandType = CommandType.StoredProcedure; //params command.Parameters.Add("@height", SqlDbType.VarChar, 10).Value = height; ...the height variable is in the format, "6'7". it was my understanding that since its a parameter, the db would be cool w/ the single apostrophe. yet, when i review my table's rows, only "6" is inserted. any idea what's up? thanks, sm Tag: problem with SQL analysis services 2000 and VB.net Tag: 145869
  - 5
    - Joining data tables Hi, Ive two data tables..I need to perform a join on these datatables.. and fetch the data..I need to do it programaticlaly.. How can I acheive it...any sample code wpuld be of great help.. Tag: problem with SQL analysis services 2000 and VB.net Tag: 145856
  - 6
    - Datatable query hi, I've a requireemnt ..in which my query will pull all the data from the database table..and binds to a grid based on some calculations..... the count of records wil be around 700000 records.... can I store this data in datatable..and bind to the grid.. what effect will it have on the performance of the page... can someone sayy if it's optimal way ??? Tag: problem with SQL analysis services 2000 and VB.net Tag: 145855
  - 7
    - Dataset and MS Access Do you have VB.NET - MS Access Samples that Uses a Dataset and Updates the MS Access Database. Also, how can we resolve the ID Uniqueness in case there are multiple users accessing and updating the same table? Thanks Again Tag: problem with SQL analysis services 2000 and VB.net Tag: 145851
  - 8
    - ado.net equivalent of ado code Hi Is there an ado.net equivalent of below ADO code? Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Set rs = cn.OpenSchema(adSchemaProviderSpecific,, "{947bb102-5d43-11d1-bdbf-00c04fb92675}") Many Thanks Regards Tag: problem with SQL analysis services 2000 and VB.net Tag: 145847
  - 9
    - Improving queries resource usage Hi I have a 10 user access backend/front end app which runs sufficiently ok. Recently I deployed a winform/ado.net app that runs a sequence of queries on the access backend db using OleDb ExecuteNonQuery method. Problem is some users have started reporting frozen front end access app. I can not say for sure that my ado.net app is responsible but problem seems to have come up in the same time frame. Is there any way I can avoid this sort of blocking and specifically if I can have a shorter timeout period for queries if a record/table is being used and can not be made available to the query? Any other ideas to help the situation would be much appreciated. Many Thanks Regards Tag: problem with SQL analysis services 2000 and VB.net Tag: 145836
  - 10
    - Strongly typed datasets: Can table adapter handle multiple resultsets? Hi, I am using Visual Studio 2008 and strongly typed datasets. My stored procedure returns 2 result sets (it has two select statements in it). how can I receive and transfer both result sets into two strongly typed datatables with only one database call? Any help would be appreciated, Max Tag: problem with SQL analysis services 2000 and VB.net Tag: 145833
  - 11
    - test test Tag: problem with SQL analysis services 2000 and VB.net Tag: 145825
  - 12
    - test test Tag: problem with SQL analysis services 2000 and VB.net Tag: 145824
  - 13
    - test test Tag: problem with SQL analysis services 2000 and VB.net Tag: 145823
  - 14
    - Complex Database Transactions Until now, I've been using stored procedures to update my databases because I've been taught stored procedures are faster (precompiled) and eliminate the possibility of some kinds of injection attacks. But now I need to create code to record a purchase transaction. Not only would this require around a dozen arguments, but these arguments could include any number of invoice items. Based only on trying to pass these arguments, it does not appear that a stored procedures is up to the job. I'm still pretty new to database development and would appreciate any comments on the best way to proceed with this. Thanks. -- Jonathan Wood SoftCircuits Programming http://www.softcircuits.com Tag: problem with SQL analysis services 2000 and VB.net Tag: 145819
  - 15
    - see for dotnet questions C# Interview Questions and Answers8 http://allinterviewsbooks.blogspot.com/2008/07/c-interview-questions-and-answers8.html C# Interview Questions and Answers7 http://allinterviewsbooks.blogspot.com/2008/07/c-interview-questions-and-answers7.html C# Interview Questions and Answers 6 http://allinterviewsbooks.blogspot.com/2008/07/c-interview-questions-and-answers-6.html C# Interview Questions and Answers 5 http://allinterviewsbooks.blogspot.com/2008/07/c-interview-questions-and-answers-5.html C# Interview Questions and Answers 4 http://allinterviewsbooks.blogspot.com/2008/07/c-interview-questions-and-answers-4.html C Interview Questions 3 http://allinterviewsbooks.blogspot.com/2008/07/c-interview-questions-3.html C Interview Questions 2 http://allinterviewsbooks.blogspot.com/2008/07/c-interview-questions-2.html C Interview Questions http://allinterviewsbooks.blogspot.com/2008/07/c-interview-questions.html Tag: problem with SQL analysis services 2000 and VB.net Tag: 145816
  - 16
    - Mounting a file as a database Hi Guys, I am trying to create a Windows Service to update 14000+ products on my website every 30 minutes I download CSV pricelists from my suppliers during this process but I found an article on the internet a while ago, but I cant seem to find it any more about mounting a file as a database using ADO Any ideas how I would do this? or where the website is? TIA Tag: problem with SQL analysis services 2000 and VB.net Tag: 145814
  - 17
    - ====> Secret SEX Couples M M S Clips <==== HAI.......... Guys this web site s very useful to you........... How This site helps.......... how to earn money form online...... In this site, you wil earn more than 10000/- Rs per month.... its true ....... just login this site and << EARN MONEY >> www.freeonlinedollers.blogspot.com www.freedollers.blogspot.com www.moviesgossips.blogspot.com Tag: problem with SQL analysis services 2000 and VB.net Tag: 145813
  - 18
    - =?KOI8-R?B?Lo0gjSCNII0gU0VDUkVUIFdFQiBDQU1TII0gjSCNII0=?= HAI.......... Guys this web site s very useful to you........... How This site helps.......... how to earn money form online...... In this site, you wil earn more than 10000/- Rs per month.... its true ....... just login this site and << EARN MONEY >> www.freeonlinedollers.blogspot.com www.freedollers.blogspot.com www.moviesgossips.blogspot.com Tag: problem with SQL analysis services 2000 and VB.net Tag: 145812
  - 19
    - reg datatable hi, I've a requireemnt ..in which my query will pull all the data from the database table..and binds to a grid based on some calculations..... the count of records wil be around 700000 records.... can I store this data in datatable..and bind to the grid.. what effect will it have on the performance of the page... can someone sayy if it's optimal way ??? Tag: problem with SQL analysis services 2000 and VB.net Tag: 145811
  - 20
    - Concurrency error handling Hi I have asked this question before but have not received any clear answer. I have a winform app with bound controls via dataadapter/dataset combination.I have a dbconcurrency exception ex. Now I have the following; DataRow = ex.Row DataTable = ex.Row.Table DataColumns = ex.Row.Table.Columns DataSet = ex.row.Table.Dataset How can I now via code, do the following; 1. Make a copy of the datarow, 2. Re-read the row from datasource, 3. Update read row with values form row copy. Any help woudl be appreciated. Many Thanks Regards Tag: problem with SQL analysis services 2000 and VB.net Tag: 145810
  - 21
    - Changes to DataSet not sticking I am currently making the move from ADO in VB6 to ADO.Net. It seems very straightforward, but I have a serious, nagging problem w/ some code I've written. Here's the pseudo-code Instantiate an object of Class WDABase (a class that is used in one of my tutorials to encapsulate some basic DB functions) Fill a DataSet from table Set a DataView with which I will be doing my searches and updates Do the last two items again for a different table Loop a delimited text file Pass an array of values to a procedure to either add a record or update existing records If no rows are found, add a new row Else, update any rows that were found Accept all changes using the DataSet's AcceptChanges method Set my views to nothing Close my database connection I've pasted the code below. I'm stumped! Can one of you ADO.Net jocks easily spot what I am doing wrong? ----------------------------------------------------------------- 'Global Declarations in VB Code Module Dim objAccessDB As New WDABase Dim objDBView1 As New DataView Dim objDBView2 As New DataView Dim objDataSet As New DataSet ----------------------------------------------------------------- 'Instantiate the Access DB object and fill DataSet (imbedded in Select Case logic 'in a procedure) Using objAccessDB 'Set DataView SetABCDataViews() 'Call to SetABCDataViews procedure, which works well 'Revise label MainForm.StatusLabel.Text = "Data Loaded...Processing Data" MainForm.StatusLabel.Refresh() '******* AT THIS POINT...I call a proce that opens a text file and loop through it ' calling the UpdateABCMergeDB for each line, passing it an array ' of values that were read from a delimited file...then I return here ' once the entire file has been read and delt with. LoopTextFile() '******* THIS is the point where I expect changes that I saw occur ' in the update procedure to "stick". But when the process ' concludes, w/ no errors, NONE of the new records are in ' the database and NONE of the updated records are updated??? objDataSet.AcceptChanges() 'Clear Dataviews objDBView1 = Nothing objDBView2 = Nothing objAccessDB.CloseConnection() End Using ----------------------------------------------------------------------- ' WDABase snippent - for clarity 'Class WDABase Constructor: Public Sub New() 'Build the SQL connection string and initialize the Connection object Connection = New OleDbConnection( _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\ABC merges 97.mdb;") End Sub --------------------------------------------------------------------------- 'Procedure to set up DBViews for each table to be searched Private Sub SetABCDataViews() Try 'Set up DataView for Subscriber objAccessDB.OpenConnection() 'Get all Subscribers in a DataReader object objAccessDB.SQL = "SELECT SubscriberID, SSN, MemberName, GroupNumber, " & _ "GroupName FROM tblSubscriber" 'Fill the DataSet objAccessDB.FillDataSet(objDataSet, "Subscriber") 'Set DataView one objDBView1.Table = objDataSet.Tables(0) objDBView1.Sort = "SubscriberID, GroupNumber" Application.DoEvents() MainForm.Refresh() 'Set up DataView for Group objAccessDB.Command = Nothing 'Get all Groups in a DataReader object objAccessDB.SQL = "SELECT GroupNumber, GroupName " & _ "FROM tblGroups" 'Fill the DataTable objAccessDB.FillDataSet(objDataSet, "Group") 'Set DataView one objDBView2.Table = objDataSet.Tables(1) objDBView2.Sort = "GroupNumber" Catch ExceptionErr As Exception MessageBox.Show(ExceptionErr.Message) End Try End Sub -------------------------------------------------------------------- ' Perform Updates - Called from the procedure that loops my datafile, which ' passes in an array of values. When new records are change or updated, I ' examine the IntelliSense field values and the proper data is in the associated ' record in the DataViews. So, this logic seems to be working fine... Private Sub UpdateABCMergeDB(ByRef Values As String()) Try 'Find this item's row(s) Dim SearchValues As Object() = {Values(0), Values(3)} Dim FoundRows As DataRowView() = objDBView1.FindRows(SearchValues) If FoundRows.Length = 0 Then 'There were no hits, add this row Dim NewRow As DataRowView = objDBView1.AddNew NewRow(0) = Values(0) NewRow(1) = Values(1) NewRow(2) = Values(2).ToUpper NewRow(3) = Values(4) NewRow(4) = Values(4).ToUpper NewRow.EndEdit() Else 'There were hits, loop them and modify the values For Each RowToUpdate As DataRowView In FoundRows RowToUpdate.BeginEdit() RowToUpdate(1) = Values(1) RowToUpdate(2) = Values(2).ToUpper RowToUpdate(4) = Values(4).ToUpper RowToUpdate.EndEdit() Next End If 'Get all Groups in a DataReader object 'Find this item's row(s) FoundRows = Nothing FoundRows = objDBView2.FindRows(Values(3)) If FoundRows.Length = 0 Then 'There were no hits, add this row Dim NewRow As DataRowView = objDBView2.AddNew NewRow(0) = Values(3) NewRow(1) = Values(4).ToUpper NewRow.EndEdit() Else 'There were hits, loop them and modify the values For Each RowToUpdate As DataRowView In FoundRows RowToUpdate.BeginEdit() RowToUpdate(1) = Values(4).ToUpper RowToUpdate.EndEdit() Next End If Catch ExceptionErr As Exception MessageBox.Show(ExceptionErr.Message) End Try End Sub Tag: problem with SQL analysis services 2000 and VB.net Tag: 145808
  - 22
    - data adapter command type advise Hi In data adapter I have a choice to select command types text, stored procedure or table direct. Which one is most appropriate for sql server 2005 backend. Many Thanks Regards Tag: problem with SQL analysis services 2000 and VB.net Tag: 145803
  - 23
    - Issues w/ using a DataTable with a TableAdapter's Update method I created a TableAdapter (TA) in my VB 2005 project. I tested it to ensure that its CRUD functionality is what I expected it to be. I'm using the TA and its strongly-typed DataTable (DT) in my Wizard. Initially, I populate the DT using the TA.GetData. I pass the DT to a ASCX-styled control that 'pivots' (turns years into columns) the data into a new DataTable (DT2), then binds it (DT2) to a GridView form. I save the original DT in the viewstate. So far so good. When I want to save the data, I compare the values in GridView to the DT that has been retrieve from the viewstate. The DT's rows are modified accordingly. So far so good. However, when I attempt to use the TA's Update method, passing the DT, I get an error about a missing parameter. I'm assuming that the parameter's value is supplied by the field that has a matching name. I've noticed that each row has a value in this field. What am I missing here? Another oddity, perhaps. If don't make an changes in the pivot grid, there won't be any changes to the DT. Why is it that the each row's rowstate is 'modified'? Could this be related my the Update issue? Thanks in advance. Craig Buchanan Tag: problem with SQL analysis services 2000 and VB.net Tag: 145802
  - 24
    - Working example for Inheritance in LINQ to Entity Framework using Visual Studio 2008 SP1 Does someone know any place to get working examples of inherence implemented in Entity Framework using Visual Studio 2008 SP1. I could only implement just one table per hierarchy ( http://www.codeproject.com/KB/architecture/LinqEntityFramework.aspx ) -- Fakher Halim Tag: problem with SQL analysis services 2000 and VB.net Tag: 145801
  - 25
    - Best ASP.NET Hosting? I am looking for a new ASP.NET hosting company. I prefer... UPTIME, RELIABILITY and SPEED!!!! ASP.NET 3.5 support SQL Server support Good, proactive customer support Any thoughts? What are your experiences? (I trust you all more than reviews.) Tag: problem with SQL analysis services 2000 and VB.net Tag: 145794
- Next
  - 1
    - Comparing Data This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C8E735.6D5CF270 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable We have an xml representation that we read over http. We turn this into = ado data sets for use in our application. We bind to these data sets.=20 We download load this data on a periodic basis. We want to compare the = newly downloaded data with the current data and have data change events = trigger for only changes(adds, modifies, and deletes) in the data.=20 What is the best approach for this? TIA=20 --=20 Howard Swope [ mailto:howard.swopeATnavteqDOTcom ] Technical Lead Media Development Navteq Traffic [ http://www.navteq.com ] [ http://www.traffic.com ] ------=_NextPart_000_0006_01C8E735.6D5CF270 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.6000.16674" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>We have an xml representation that we = read over=20 http. We turn this into ado data sets for use in our application. We = bind to=20 these data sets. </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>We download load this data on a = periodic basis. We=20 want to compare the newly downloaded data with the current data and have = data=20 change events trigger for only changes(adds, modifies, and=20 deletes) in the data. </FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>What is the best approach for = this?</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>TIA</FONT> </DIV><FONT = face=3DArial size=3D2> <DIV><BR>-- <BR>Howard Swope [ <A=20 href=3D"mailto:howard.swopeATnavteqDOTcom">mailto:howard.swopeATnavteqDOT= com</A>=20 ]<BR>Technical Lead<BR>Media Development<BR>Navteq Traffic [ <A=20 href=3D"http://www.navteq.com">http://www.navteq.com</A> ] [ <A=20 href=3D"http://www.traffic.com">http://www.traffic.com</A> ]</DIV> <DIV> </DIV> <DIV></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0006_01C8E735.6D5CF270-- Tag: problem with SQL analysis services 2000 and VB.net Tag: 145792
  - 2
    - Parameter in Subquery Hello, I am trying to do a query to obtain the quantity bought of articles by Families between a period of date and I am using the following query: Select f.nombre, (select sum (ldp.cant) as ' Cant. Comprada' from LINDPRO as ldp where ldp.codfam=fam.codigo and ldp.fecha <=desfec and ldp.fecha> =hasfec)) from Familas as f; When I executed the query get a error because it takes parameters (desfec and hasfec). Is it possible to do it. Thanks. Jose A. FernÃ¡ndez Tag: problem with SQL analysis services 2000 and VB.net Tag: 145791
  - 3
    - see dot net interview questions .NET database dev questions http://freedownloadablebooks.blogspot.com/2008/03/net-database-dev-questions.html Some general quickies http://freedownloadablebooks.blogspot.com/2008/03/some-general-quickies.html .NET WebDev interview questions - Part 1 http://freedownloadablebooks.blogspot.com/2008/03/net-webdev-interview-questions-part-1.html .NET WebDev interview questions - Part 3 http://freedownloadablebooks.blogspot.com/2008/03/net-webdev-interview-questions-part-3.html Electronic engineer interview questions http://freedownloadablebooks.blogspot.com/2008/03/electronic-engineer-interview-questions.html C++ notes for discussion http://freedownloadablebooks.blogspot.com/2008/03/c-notes-for-discussion.html Tag: problem with SQL analysis services 2000 and VB.net Tag: 145790
  - 4
    - IsolationLevel of ReadUncommitted Hi, I was wondering if you could use SqlCommand.BeginTransaction( IsolationLevel.ReadUncommitted ) to speed up a database read, and if so, is it necessary to perform the EndTransaction after the read is complete? Can you use this approach for asynchronous database reading as well? Any suggestions are welcome - my problem is that there are several users who are notified any time a particular table is changed, and they will all try and read the table the moment they are notified, and noticable delays occur (longer than you would expect from the time it takes to get the result set from running the query from the Query Analyzer - not necessarily a fair comparison). Any help would be appreciated. Thanks in advance. Tag: problem with SQL analysis services 2000 and VB.net Tag: 145789
  - 5
    - Does a DataView increase the speed of an DataTable.Select ? Hi out there, I use an algorithm which uses different selects in loops and needs some optimizations. I read in a book that when I define a DataView with a specific sort my DataTable.select is faster. (The tables have a primary key and the select is containing these fields). Is it true? Thanks, Frank Tag: problem with SQL analysis services 2000 and VB.net Tag: 145787
  - 6
    - Designer Louis Vuitton Geant Canvas Couguar - Gray 93084gray Designer Louis Vuitton Geant Canvas Couguar - Gray 93084gray Handbags, Luxury, Best,Inspired Designer Handbags : http://www.bagsbrand.com Louis Vuitton Geant Canvas Couguar - Gray 93084gray Link : http://www.bagsbrand.com/Louis-Vuitton-93084gray.html Brand : Louis Vuitton ( http://www.bagsbrand.com/Louis-Vuitton-Handbags.html ) Model : 93084gray Louis Vuitton Geant Canvas Couguar - Gray Details : Gray color Louis Vuitton leather with canvasRound type leathr handle with silver buckleSilver color zipper closure at the topLouis Vuitton name at the frontInside it has flat pocket and a cellphone holderComes with serial numbers, authenticity card, dust bag, and care booklet SIZE : 16.5" x 14.2" x 6.7" Louis Vuitton Geant Canvas Couguar - Gray 93084gray : http://www.bagsbrand.com/Louis-Vuitton-93084gray.html Tag: problem with SQL analysis services 2000 and VB.net Tag: 145786
  - 7
    - Designer Chloe Tracy Pocket Tote - Black 049 black Handbags, Luxury, Designer Chloe Tracy Pocket Tote - Black 049 black Handbags, Luxury, Best,Inspired Designer Handbags : http://www.bagsbrand.com Chloe Tracy Pocket Tote - Black 049 black Link : http://www.bagsbrand.com/Chloe-049-black.html Brand : Chloe ( http://www.bagsbrand.com/Chloe-Handbags.html ) Model : 049 black Chloe Tracy Pocket Tote - Black Details : Gorgeous black leather handbagZip closure on top, elegant lining, and zip pocket insideFlat hand straps fixed by cute metallic studsFront pockets with hidden snaps and zip fastener aside Metallic six protective studs on the base Comes with serial numbers, authenticity card, dust bag, and care booklet SIZE : 17.5" x 10" x 4.5" Chloe Tracy Pocket Tote - Black 049 black : http://www.bagsbrand.com/Chloe-049-black.html Tag: problem with SQL analysis services 2000 and VB.net Tag: 145785
  - 8
    - Winform sql server app Hi I am new to sql server and need to build a one-many winform app with visual studio 2008 and sql server backend and need some pointers. I have the following questions; 1. If I create the app by creating a relationship between master and child tables in dataset and then dragging the master table and relation onto a form to auto generate everything, would that be a good enough way to cerate the app? If so, what more can I do to turn it into a robust enough app such as error handling etc? If this is not a good way to cerate app what should I instead do? 2. Is there a good book on the subject of vs2008/vb2008 and sql server 2005 specifically, that will me sufficient advise on how to develop the app? Many Thanks Regards Tag: problem with SQL analysis services 2000 and VB.net Tag: 145783
  - 9
    - DataColumnMapping error Hi I just don't get this. If I create a DataColumnMappingCollection and then copy it to an array when I then try to use the array like this I get error: System.ArgumentException was unhandled Message="The DataColumnMapping is already contained by another DataColumnMappingCollection." If I create the DataColumnMapping arrays manually it works. I was just using 1 item in both arrays. DataColumnMapping[] mappings = GetColumnMappings(maps); DataTableMapping tableMap = new DataTableMapping(null, null, mappings); public static DataColumnMapping[] GetColumnMappings(JobRuleColumnMapping[] mappings) { DataColumnMappingCollection mapColl = new DataColumnMappingCollection(); foreach (JobRuleColumnMapping map in mappings) { if (map.Source != null && map.Destination != null) mapColl.Add(map.Source, map.Destination); } DataColumnMapping[] mapArr = new DataColumnMapping[mapColl.Count]; mapColl.CopyTo(mapArr, 0); return mapArr; } Can someone please explain this? Thanks Andrew Tag: problem with SQL analysis services 2000 and VB.net Tag: 145782
  - 10
    - dataset and different connections when i design application which has dataset, i create connection at design time. Then I use this connection to design table adapters. Now assume this application will run in different environments. The structure of database will be the same, however connection string may change. Is it possible to create connection string dinamically such way that designed table adapters still work? -- Aleks Kleyn http://www.geocities.com/aleks_kleyn Tag: problem with SQL analysis services 2000 and VB.net Tag: 145781
  - 11
    - Connection poolling Hi, Despite somme reading (including doc, Reflector, etc.), i dont't really understand wich is the best method between Close and Dispose (or perhaps the both) to get pooling with SQL Server with a well defined connection string ? If any body have some idea or a good pattern to close a connection ? Best regards Gilles *** Sent via Developersdex http://www.developersdex.com *** Tag: problem with SQL analysis services 2000 and VB.net Tag: 145773
  - 12
    - MDB is not Updated only data Set Good Afternoon, I did the following step by step and i found out that the MDB or Access 2003 Database was not updated. 1. Create a new solution 2. Click Data Sources on the Solution Explorer 3. Create a new connection on an MDB File 4. Under the Dataset of Data Sources I Click Choose Detail 5. I Click and Drag the Dataset on my Form. 6. Automatically Binding Navigator, Add, Edit, Delete and Save Button Appeared. 7. Click Run 8. Add a new Record 9. Save it 10. I check the MDB but no record was added. 11. Only the Dataset was updated. When I exit the Application no changes were made. I did the same for SQL. it was updated. How come it doesnt work with MS Access??? Tag: problem with SQL analysis services 2000 and VB.net Tag: 145771
  - 13
    - SQL Express Edition We are currently tied between two options. One is to use Microsoft Access 2003 or Use MS SQL Express Edition (Bundled with Visual Studio.Net 2005). I read a documentation Saying that in The Express Edition you can't make a parallel Query etc... Our company is just a small business catering to a maximum of 20 Concurrent Connections on a Database. Is it ok if we use SQL Express Edition? What are the Pros and Cons? We are finding it hard to develop Application using MS Access because of Limited Resources and one thing more we are all new to this technology because we are using Foxpro for DOS 2.6 and Visual Foxpro 7.0. MS SQL 2005 is very expensive and our company can't afford it now. Will you please give me some advice. Do you have sample source codes that implements MS Access VB.NEt 2005 with Parent and Child Tables using DataGridView and having Default Buttons such as Add, Edit, Delete, Find, Save where everything was done programmatically including connection strings, Data Adapter etc... This will really fastrack our Development Process. We downloaded a few but some are not working when we run it our Visual Studio.Net 2005. It is really hard on part to develop since our company is using only Dial Up internet with 56 KBPS Connection. Thanks in advance for your kind support. Tag: problem with SQL analysis services 2000 and VB.net Tag: 145766
  - 14
    - Currency manager changes position on endedit Hi I have a winform app with fields bound to a backbend db via a currency manager (System.Windows.Forms.CurrencyManager). The app generally works fine but in a specific instance where I select a value from a drop down control and then call the MyCurrencyManager.EndCurrentEdit(), to begin to try to save the record, the position of the currency manger becomes -1 which creates problem in saving and accessing the original record. What could be the problem and how can I debug this? Many Thanks Regards Tag: problem with SQL analysis services 2000 and VB.net Tag: 145765
  - 15
    - Running queries with low priority in ado.net on access database Hi We have an access database with several users. I run a number of queries in sequence via ado.net on the same database form time to time. The problem is that when the queries are run the users are almost locked out of database due to low responsiveness of the database during the period the queries are run. I am running the queries via OleDBCommand.ExecuteNonQuery(). Is there any way to run these queries at low priority? Also what is the correct way to give delay between queries to allow access database to be responsive to other users? Many Thanks Regards Tag: problem with SQL analysis services 2000 and VB.net Tag: 145761
  - 16
    - Running queries with low priority Hi We have an access database with several users. I run a number of queries in sequence via ado.net on the same database form time to time. The problem is that when the queries are run the users are almost locked out of database due to low responsiveness of the database during the period the queries are run. I am running the queries via OleDBCommand.ExecuteNonQuery(). Is there any way to run these queries at low priority? Also what is the correct way to give delay between queries to allow access database to be responsive to other users? Many Thanks Regards Tag: problem with SQL analysis services 2000 and VB.net Tag: 145760
  - 17
    - DataSet Cascade update is slow Hi, I have a master-detail relation between two tables in a typed DataSet. The relation is enforced by forgein-key relation with update/delete cascade. The user can create a master recorde (the session) and then adds details to the session. Which can be some tens of thousands of rows. Saving the session to the database (calling DataAdapter.Update) never ends for large number of details. I am suspecting the cascade update to take a lot of time. I mean when the new ID of the session is set on all the details rows before saving them in their turn. How can I accelerate this step of cascade? Why setting a field value (the master ID) on some 10 of thousands of rows is that slow? Thanks Tag: problem with SQL analysis services 2000 and VB.net Tag: 145759
  - 18
    - Query regarding DataReader I was trying to fill an object using DataReader. but the queries were such that one query returned 14 columns and another returned 18 columns. i was trying to read data from reader in such a way that it incorporated this in single method. but the problem was that it was throwing an IndexOutOfRange exception is there is way except for reading schema that i can fetch data only if if exists? Tag: problem with SQL analysis services 2000 and VB.net Tag: 145757
  - 19
    - "Linq to Sql" - Creating a Non-Unique Index on a Property Hello, Is there a way to set up a non-unique index during database creation (i.e. on the call to DataContext.CreateDatabase), with Linq to Sql? A second property marked as a primary key won't quite work for my scenario. I could always execute a custom script in DataContext.OnCreated(), but if there is a way to do this in the designer or the XML, that would be ideal. Cheers, Rich Tag: problem with SQL analysis services 2000 and VB.net Tag: 145756
  - 20
    - Select from multiple tables in typed DataSet Hi, This may be a very silly question, but it has me beat at the moment. How do I select data from more than one table into a typed DataSet? I added a typed DataSet to my project with two related tables, and I specified the relationship between them. What I need to do is execute a query like this: SELECT a.col1, a.col2, b.col3 FROM a, b WHERE a.col1 = b.col1 AND b.col4 IN (@list) The list parameter is a string holding a comma separated (and quoted), arbitrary length list. Obviously I can only define the query on one of the tables in the DataSet - but when I get results back, they only contain columns for the one table. I.e. if I've defined the query on table a, I only get two columns in the result. I can see why this should be the case, but is there a way that I can get a result that contains columns from both tables. Sorry if this is really obvious and I've just missed it. Cheers Peter Tag: problem with SQL analysis services 2000 and VB.net Tag: 145754
  - 21
    - WQL query builder Prompt UI control which would allow to construct WQL queries? http://www.alvas.net - Audio tools for C# and VB.Net developers Tag: problem with SQL analysis services 2000 and VB.net Tag: 145753
  - 22
    - Please ignore This is a test. Please ignore it Tag: problem with SQL analysis services 2000 and VB.net Tag: 145752
  - 23
    - Map data from one DataTable to another Hi I have a DataTable with data which I need to import into another typed DataTable at runtime. The columns in the first DataTable may be different. I have a DataColumnMappingCollection (which the application user creates) which maps the first DataTable column names to the second. The first table may have more columns than I need to import to the second. It's also possible that I may need to convert types from rows in the first table to the second. What's the most efficient way to get the data into the correct columns in the second table? I did wonder about doing something with the DbDataAdapter before filling the first table. However it looked like I would have to query the data twice from the data source. The first time to get the column names and then the second after creating new column mappings. Is this a good idea? Cheers Andrew Tag: problem with SQL analysis services 2000 and VB.net Tag: 145748
  - 24
    - to find the data from one dataview not in another dataview Dear all I have a two dataview e.g. dataview A row 1 A B C D dataview B A B C D E I want to find the data in dataview B not in dataview A e.g. E Tag: problem with SQL analysis services 2000 and VB.net Tag: 145747
  - 25
    - Power Packs 3.0 Data Repeater I can't add a control on a data repeater included on Visual Basic Power Packs 3.0... Will you please help me out. I'm using MS Access 2003 and Visual Basic.NEt 2005 Express. I will be using a weak type. I was just starting to build. Here are the steps. 1. I created a form 2. I Drag a data repeater from the Toolbox 3. I add a textbox inside the data repeater 4. When I run the Form. The Textbox did not appear. 5. It did not generate any error then.. 6. When I click Close or Click a part of the Form: Object reference not set to an instance of an object. System.NullReferenceException was unhandled Message="Object reference not set to an instance of an object." Source="Microsoft.VisualBasic.PowerPacks" StackTrace: at Microsoft.VisualBasic.PowerPacks.NullDataManager.CancelCurrentEdit() at Microsoft.VisualBasic.PowerPacks.DataRepeater.CancelEdit() at Microsoft.VisualBasic.PowerPacks.DataRepeater.EndCurrentItemEdit() at Microsoft.VisualBasic.PowerPacks.DataRepeater.OnValidating(CancelEventArgs e) at System.Windows.Forms.Control.PerformControlValidation(Boolean bulkValidation) at System.Windows.Forms.ContainerControl.ValidateThroughAncestor(Control ancestorControl, Boolean preventFocusChangeOnError) at System.Windows.Forms.ContainerControl.ValidateInternal(Boolean checkAutoValidate, Boolean& validatedControlAllowsFocusChange) at System.Windows.Forms.ContainerControl.Validate(Boolean checkAutoValidate) at System.Windows.Forms.Form.WmClose(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr wndProc, IntPtr hWnd, Int32 msg, IntPtr wParam, IntPtr lParam) at System.Windows.Forms.NativeWindow.DefWndProc(Message& m) at System.Windows.Forms.Form.DefWndProc(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ContainerControl.WndProc(Message& m) at System.Windows.Forms.Form.WmSysCommand(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr wndProc, IntPtr hWnd, Int32 msg, IntPtr wParam, IntPtr lParam) at System.Windows.Forms.NativeWindow.DefWndProc(Message& m) at System.Windows.Forms.Form.DefWndProc(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ContainerControl.WndProc(Message& m) at System.Windows.Forms.Form.WmNcButtonDown(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.Run(ApplicationContext context) at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun() at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel() at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine) at Purchasing_and_Warehousing_System.My.MyApplication.Main(String[] Args) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 81 at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args) at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() What does this mean? Tag: problem with SQL analysis services 2000 and VB.net Tag: 145745

HI,
im working in VB.net project and i use Analysis services 2000. When I
generate deployment package and try to setup the software on client
machine i get a message that analysis services missing. I dont want to
install Analysis services.
if some one knows any way to help me out it will be great
thanks

Top