VOC's Q&A profile

• SQL Server Queryign multiple databases

  Hi, I'm a newbie to SQL Everywhere. I have gon e through the examples and created a C# application to create and a manipulate database on desktop. SFSG. For my application, though, I see the need to work around the 4GB limit. So I will need to segment my data into multiple databases. Does SQL Server Everywhere supports joins across mutiple SQL/e databases on the same machine I have not found any examples that guide to address this issue. can anyone point me to something/help me write queries that join D1.T1 and D2.T2. what JP is saying is to load your data from the database into ADO.NET DataTables in your app and then you can use the features of the DataSet and ability to merge DataTables in ADO ...Show All

• .NET Development Retrieving @@Identity from Access database table

  I just tried the code in http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=58862&SiteID=1 and it doesn't work in the partial class that is part of the dataset designer because the _adapter is a private event. When compiling I get the message:"Error 3 Handles clause requires a WithEvents variable defined in the containing type or one of its base types. " Any idea how to work around this To retrive the @@IDENTITY: Private Function GET_Identity() Try ' Include a variable and a command to retrieve the identity value from the Access database Dim newID As Integer = 0 Dim idCMD As OleDbCommand = New OleDbCommand("SELECT @@IDENTITY Fr ...Show All

• Visual Studio Team System TF30063: You are not authorized to access <servername>

  Every few days one of our team members receives this error when attempting to check files out of version control. I have seen other postings related to this error, but it seems that it occurs when using proxies or other configurations. These solutions do not apply to use because we are using the single deployment model for TFS.  At present time our workaround is to have the developer reboot their workstation. Is anyone aware of the root cause of this problem and how to solve it Hi Ariel: We have not seen this in our dogfooding or heard from customers about this problem. There have been reports of antivirus, firewalls, and things like Desktop Se ...Show All

• SQL Server Reporting Services Upgrade Blocked?

  I recently ran an upgrade from SQL 2000 to SQL 2005. I selected SQL DB and Reporting Services for the upgrade and the program allowed me to move forward and install. However, during the upgrade there was a strange error about not being able to update tables or something like that. This forced me to cancel out of the upgrade. I was able to restart the suspended upgrade by going through Add/Remove programs but that only upgraded SQL DB not RS. I went back in to upgrade Reporting Services and I got an error saying the upgrade was blocked due to version/edition. Now I cannot upgrade. Did it partially start to upgrade RS before it failed Would that be why it worked the first time around and not the second Is there something I ...Show All

• SQL Server OLEDB Source Table Locks?

  Hi All, Is it possible that an OLEDB Data Flow Source is imposing locks on the source tables The source is an SQL Server OLTP environment, and although the package will be scheduled to run nightly when the application sees little to no use, I want to be sure that the process isn't impacting any application functions. Thanks for the advice! Rocco An OLE-DB source will impose the same locks as if you were running the SELECT satement yourself from any other tool, so normaly you would expect some shared locks to allow you to consistently read the data requested. Using Profiler will show you details of the SQL statement, and you can also choose to show locks details in profier, just filter for the SSIS connection/machine/user ...Show All

• Visual Studio Express Editions Alternative to Timers

  Yeah, are there some other things I can use that replaces timers Like a loop or something You could do this, however it would chew up your compute resources for the whole operating system for the duration of the loop. What are you attempting to accomplish ...Show All

• Visual Studio Express Editions VB 2005 Express Issues

  I got the hotfixes today and installed them. They seem to help some with the crashes. But, I'm still having this issue: I have a table in a SQL database I made with SQL express edition. I have the db connected to my program. In this table I have a field called Last Name. I place a listbox item on my form, then on the controls bind it to Lastname field. When I click on the small triangle, I select build query at the bottom. I use the query builder to build me a query. Everything is fine, until I go to add a second query. I then get this message: Unable to write the custom tool "MSDatasetGenerator" to file Database1dataset.designer.vb. Process cannot access file because user by another process. Also, then my dataset i ...Show All

• Visual C# Checking for ilegal symbols in a string.

  Hi! I want check a string looking for characteres that aren't letters from A to Z or numbers from 0 to 9. I can do it with multiple string.Contains(character) but isn't a good way. Some way mor efficient and fast Regards. Just insert a space in the pattern (see below, after number 9): [^A-Z0-9 ] Andrej ...Show All

• Visual Studio 2008 (Pre-release) Events on WPF Grid Container Rows/Columns

  Hello All, I wish to draw a grid (container element) on my WPF window and have some rows and columns (using rowdefinitions and columndefinitions within that). I want to know which cell is the one on which my mouse is currently located and then change its background a little and extract some information stored in that grid cell. The grid cell(s) will be datatemplate(ed) to some DB. Please help me in figuring out what is the best way to do this. I have tried putting mousemove event on the columndefinition and rowdefinitons, but that simply does'nt work (because the sender for the mouse move event is the grid and not the cell). How to overcome this Thanks in advance. Best Regards, Rohit. ...Show All

• Software Development for Windows Vista sqlPersistence

  Hi, A simple question. I am using sqlPersistence services to persist my workflow instances. An instance was already created say 2 days back and was persisted in the database. If I want to work on the same instance again, what should I do workflowInstanceId = <Comes from the database if record exist or new GuiID) WFInstance = workflowRuntime.CreateWorkflow( typeof ( InterviewProcessWorkflow ), null , workflowInstanceId); WFInstance.Start(); or WFInstance = workflowRuntime.GetWorkflow(workflowInstanceId); WFInstance.Resume(); Please help. hi. Joel how i let runtime to persistent the instance and then call UnloadOnIdle ai idle time？ if the workflow instance is idle or suspended, the runtime ...Show All

• Visual Studio Team System Customize Team Foundation Server instance of Sharepoint Services

  We have a corporate Sharepoint Portal Server setup that has a 'Virtual Server Gallery' with a 'Office Spreadsheet' webpart. Is there a way to add this to our Team Foundation Server instance of Sharepoint Services so that the 'Office Spreadsheet' webpart can be added to Team Sites I've also posted this to the Sharepoint Communities forum. Thanks, John ...Show All

• Visual Basic OFSTRUCT Structure - Exception

  Hi, When I use OFSTRUCT Structure in VB.Net without Marshalling the szPathName field throws the following error "An unhandled exception of type 'System.ExecutionEngineException' occurred" while opening a file with LZOpenFile. Is there any way that this could be solved without Marshalling Pls find Piece of code used. Public Structure OFSTRUCT Dim cBytes As Byte Dim fFixedDisk As Byte Dim nErrCode As Byte Dim Reserved As Byte '<MarshalAs(System.Runtime.InteropServices.UnmanagedType.ByValTStr, SizeConst:=OFS_MAXPATHNAME)> Dim szPathName As String Dim szPathName() As Byte Public Sub Initialize() ReDim szPathName(OFS_MAXPATHNAME) End S ...Show All

• SQL Server Error with attributeKey

  Hi everybody, I have a problem while creating my cube. In my database i have two tables Article (ArticleKey, Libelle, ...) articleKey is the pk FactStock (stockKey, ArticleKey,...) strockKey is the PK and articleKey reference column articleKey in article table. There is integrity constraint between this two columns In BIDS, when i try to mount my cube with this two elements and others. i have an error : "Erreurs dans le moteur de stockage OLAP : La cle d'attribut est introuvable : Table : dbo_factStocks, Colonne : ArticleKey, Valeur : 47107" . So, I search help on web and I found this page : http://support.microsoft.com/kb/922673/en-us . So i try element that was written on it. but it doesn't seems to work. If I ...Show All

• SQL Server How to encryt a Date field??

  How do we encrypt/decrypt a datetime field For e.g. Date of Birth Hi Ks, I'm not sure if I understand your question. Encrypted data will be varbinary so the encrypted text should be stored in a varbinary column.  As for decrypting the data, I am copying and pasting Raul's response from before: DECLARE @mySecretDateBlob varbinary ( 100 ) -- To decrypt, do teh same trick, after decrypting, convert/cast to datetime SELECT Convert( datetime, DecryptByKey( @mySecretDateBlob )) as 'datetime plaintext'   This should convert the encrypted text back into a plaintext datetime format.  Please let us know if this helps you out and please post any further questions you may have. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. My 2D particle engine now available

  here > http://www.codeplex.com/Wiki/View.aspx ProjectName=mpe Here be my first contribution to the XNA community, a fast, powerful & flexible 2D particle engine that can easily & seamlessly integrate into your game project. Features: Completely drag & drop, no code required! Complete control over scale, alpha, rotation and color at all stages of a particles life. Definable random variation of particle speed & lifespan. 5 emitter shapes - Point, Spray, Circle, Ring & Spiral (more to come!) Extremely easy to add custom emitter shapes! Hope you find it useful, there's still a few things to iron out but i think it's near enough usable right now :) Jeff Johnson wrote: ...am I just totally missing it ...Show All