Alex Farber's Q&A profile

• Visual Studio Express Editions Display problems for my application

  I finally got my application to work!! Now I have a problem when I load the application onto another computer. The problem is that the program does not display the same as on the computer I used to write the application. What is the problem and how can I fix it When I put the program onto another computer, the right hand side of the forms are cut off( as if they are to long for the screen) and there are no scrollbars available. I di set the scrollbar property in an attempt to fix this, but still no scrollbars, and the program forms are cut off. ...Show All

• SQL Server Changing ASP Application to use SQL Native Client

  I am attempting to change an ASP application we've got to use SQL Native Client instead of MDAC and running into a problem. If I use ODBC driver our application runs without problem, but if I try to use the OLEDB provider certain pages are throwing the following error: Item cannot be found in the collection corresponding to the requested name or ordinal. The pages that are not working are using ADODB.Command object to execute a Stored Procedure and populate ADODB.Recordset object. The error is thrown when I try to access a field (by name or index) in the recordset. I am using recordsetname(0) or recordsetname("fieldname") to access the data in the recordset. I have other pages that are working that use this same technique, ...Show All

• Smart Device Development Issue with Device Emulator screen buffer limit set to 1 MB

  Hello All, I need to run 800x600x32 color depth which won't fit in the current device emulator settings. Any thoughts on how I can fix this Thanks in advance for any help :) Bob Hanson Sorry but deviceemulator.exe and BSP code restrict the limit to 1MB only. But since you will be having BSP code (From PB) and share source of Device Emulator (Free download from Web), you can generate your own custom DeviceEmulator.exe and corresponding image if your project requires it. Hope this helps. -Thanks, Mohit ...Show All

• Software Development for Windows Vista This workflow is not owned by the WorkflowRuntime.

  Hi, I've got a sequential workflow that occasionally starts throwing the above exception. The app works its way through all the activities successfully creating the "executing" record for the HandleExternalEvent activities up to and including the last one, then fails (regardless of which one is last) and then starts cancelling and closing the activities. I've disabled the "last" activity and it just fails on the next to last (now the last activity). I'm adding the Persistance service with the following: Dim owr As Object = HttpContext.Current.Cache(_WFName) ' Cache is per AppDomain If owr Is Nothing Then System.Threading.Monitor.Enter(_sync) owr = HttpContext.Current.Cache(_WFName) ...Show All

• Visual Studio Team System Just starting out with MSBuild

  Hello,I am just starting out with my MSBuild project for TFS, and I am having a little trouble wrapping my head around it ...I went into Team Explorer and created a new Build Project, and it built all my projects for me, etc. and everything seemed to work fine (for this scenario).However, our build process requires a lot more than just building - so I decided to investigate how to customize my MSBuild project. I tried starting out with a blank template, but I noticed that the .proj file which was created through the wizard used what is called a "DesktopBuild" as the DefaultTarget. I take it that this includes all of the Clean, Get Latest, Build and Copy-to-output directory functions, and these are all done behind the scenes Basic ...Show All

• Visual Basic Dynamically load a DLL in VB.net

  Is there a way to Dynamically load a DLL in VB.net Dunno where else to ask this question, so decided to post it here...tq Actually, I have yet to write the code. After I got the error " Failed copying C:\Program Files\Microsoft Visual Studio .NET 2003\CompactFrameworkSDK\v1.0.5000\Windows CE\wce400\X86\symbol.all.x86.cab to the device " while testing the app on Windows CE Emulator, I had stop coding with the assumption of the Symbol libraries would not load to devices other than Symbol devices. ...Show All

• Visual C++ Need help compiling 64-bit C++ Code in VS2005...

  Hello generous helper! I am trying to figure out how to port my code from 32-bit VC++ 6.0 to unmanaged C++ 64-bit VS2005. I have found the preprocessor definition changes and the linker changes, but I get errors compiling, like: error C2371: 'size_t' : redefinition; different basic types I get the feeling that I am doing something horribly wrong, even when I try to make a "Hello World" program, its not working out for me in 64-bit... Does anyone have an unmanaged C++ VS2005 Project in 64-bit that does "Hello World" just so I can see how it is done Thanks! - John Hi John, I am having the same problem, can you provide solutions how you got it to work Thanks! I have the Visual Studio 2005 Professiaonl Ed ...Show All

• SQL Server Error message

  Hello, When I try to run a query on a server, I get the following error: "Cannot resolve collation conflict for equal to operation." The same query, but on another server works without any problems. Any idea how I can resolve this You are joining two different coallations which each other. To solve the collation conflict you will have to either change the collation on the server / database / table / or expression server you are using (whereas the latter is the quickfix for your problem. It has be to implemented whereever you are joining different collations: select ca.account_status, cs.code from customer as ca inner join v_customer_status as cs on ca.account_status = cs.descr ...Show All

• SQL Server UPDATE The records in table 1 that I just imported into Table 2

  Hello there, I need to move data from one table to another. Is there a way to set a flag (say isProcessed) in table 1 upon the successful import of data to table 2 I know I could use a temp table, but I was hoping for some sort of built in command/table @TransactionScope.Table or something like that. I know that triggers have UPDATED and DELETED tables or some such, but I would like to stay away from triggers as well. Any hints You could use the OUTPUT clause 8which is new to SQL Server 2005) and write the existing ids after inserting them in one table to a loca variable and using this afterwards in the other query. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server How to give "public" access to cubes

  Hi, I'm deploying cubes over an intranet on web pages using OWC (OWC11). We can create roles to restrict access to dimensions or even the whole cube itself. On the intranet I must give access to everyone, that is users who are not registered on AS2005 Server. How can I give an Anonymous access over my cubes to my cube readers such that anyone can view the cube I've created a role named "public" in which I've added Anonymous Logon but OWC still denies access to non registered users. Thanks. This could be something else. Some connectivity problems. Take a look at this http://www.sqljunkies.com/WebLog/edwardm/ You should find your error there and some clues how to troubleshoot connectivity. Edward. -- Thi ...Show All

• Visual Studio Team System TFS Dual Server Deployment Licensing Question

  One doc I read on TFS licensing said that you need a license for every server you install TFS on. That sounds reasonable but what does that mean in a dual server (separate App/Data tier) deployment Does that mean you need to buy two TFS licenses for a dual server deployment I mean it's a single "logical" server, right Yeah I agree with you on the last point. It's just that our IT folks tend to "over engineer" things, jump straight to the dual server model with SQL installed on an 8 proc server and then complain that they have to buy two TFS licenses (and a separate SQL license for 8 proc support). And we don't have anywhere near the number of TFS users yet or in the near future to jus ...Show All

• Windows Forms VB 2005; CentertoScreen/ScreenResolution

  Hello: I create a single form application with VB.Net(2005). In the code for Form Load I set the property Me.CenterToScreen When the application is run the form is centered in the screen if the screen resolution is the same as the screen resolution during application creation. If the application is run on a system where the screen resolution is different the form is no longer centered in the screen. Question: Is this an inherent problem with no solution If there is a solution where should I be looking for the proper coding techniques Thanks for consideration... jes ...Show All

• Software Development for Windows Vista Vista desktop search preview?

  In the preview pane for desktop search I see metadata about the item selected but not a preview of the content itself. For emails/docs I should see the actual item contents. Without this functionality I'm forced to install some other desktop search tool; X1, Copernic, Google, etc. These show content not just metadata. Am I missing something You can open a "preview pane" that lets you see the contents of the selected item. Click the Organize button, then Layout, then Preview Pane. ...Show All

• SQL Server how to loop through several excel sheets in a file in integration services

  Hello, I'm new at Integration services and I have an excel file with information in several worksheets. I want to loop through some specific sheets to retrieve the data and save it in a database table. I know how to retrieve the data from one sheet, but I don't know how to do it for several sheets. Any ideas ...I would appreciate any help. The last bit of pre-processing I want to do in Excel, I know how to do in an Excel macro, but not in SSIS. Can anyone adapt this into an SSIS Script task Here is the macro code snippet: Sub ClearWorksheets() With Application .Calculation = xlManual .EnableEvents = False Worksheets("MyData").Range("A:H").Clear .EnableEvents = ...Show All

• Windows Forms HTTP Redirect error during clickonce

  Hi, I have a simple windows forms assembly referencing a dll, which I include in the project, and which is copied successfully to the webserver/network address for click once deployment. However, when I try and install, I get the error: 'Following failure messages were detected: + HTTP redirect is not allowed for application files and assemblies. Cannot download ********.dll. All the Mime settings are correct or the webserver, so could this be a permissions problem Why should 'HTTP redirect' be being used When I create a clickonce deployment to CD all works fine. Any help greatly appreciated. When are you getting the error message during the install process or after the install during initial applicati ...Show All