Sam Skrivan's Q&A profile

• SQL Server RDA Pull with existing table

  Hi Forum, I am currently implementing RDA Pulls and Pushes. Both worked fine for me, except when I try to pull a certain table twice. I read that in order to pull the table a second time I must drop it on the client. My original approach was to use a select statement with a where criterium in the pull statement (e.g. SELECT * from tblPhonebook where Pulled = 0), then set Pulled to 1 and pull again later. My understanding of RDA was that I use th ...Show All

• Smart Device Development Unable to connect to live Web Service with Smartphone Emulator in RC

  I'm still struggling with Emulator connectivity in the SmartPhone Emulator. Here's the setup: VS.NET 2005 RC SmartPhone 1.0 Framework App Connecting to a Web Service both on local machine and on the Web Emulator set up running and cradled Network Configuration has the Enable NE2000 PCMCIA Network Adapter set No other options are explicitly set from default The emulator seems to have good connections to both the local machine and the Web using I ...Show All

• SQL Server Verify Database as in Crystal Reports

  In Crystal Reports designer, there is a way for me to invoke 'verify database' which basically makes sure the report definition is in synch with the referenced database table. However I can't seem to find such command in Microsoft Report Designer.  For example, when creating a report, one of the columns used to be 'Last_Name'.  The report is built and deployed successfully to Report Server.  When I run the report, the results are ...Show All

• SQL Server How to programmatically render reports?

  We are working on a new C# application. This application will not have a user interface; it will run "behind-the-scenes". This application needs to programmatically generate reports--it needs to be able to render reports to a predefined output format (HTML, Excel, etc.) and it needs to be able to send the rendered report to a predefined location (fileshare, e-mail, printer, etc.). How can we programmatically render reports with a sp ...Show All

• Visual C++ OpenThemeData() error

  hi, I try to add XP visual styles to a Tab control in my application, but I can't get it to work. The 'OpenThemeData' function generates the error below when I try to build the appliction. why I have added the manifest file to the resource, link to the ComCtl32.lib and all that described in the MSDN. But the error appears anyway. What have I do wrong error LNK2001: unresolved external symbol __imp__OpenThemeData@8 fatal error LNK1120: 1 unres ...Show All

• Windows Forms PocketVision vs Offline App Block

  I'm currently evaluating these two frameworks as a basis for a mobile workforce project. I first attempted the new Microsoft Offline application block but found that this isn't compatible with the compact framework (the most usefull application of the solutio ...Show All

• Visual Studio AssemblyInfoTask: Overwriting read-only files?

  Hey All, I just found the AssemblyInfoTask for MSBuild and it's almost exactly what I need! I'm creating a build system for our product using CruiseControl.net where the source is fetched from SourceSafe before a build. I've got a version generated by CC being passed into the MSBuild engine, and in testing, being written to the assemblies via the AssemblyVersion property. The problem I'm encountering is that when the files are fetched from ...Show All

• Visual Studio Express Editions I really need a piece of advice...

  Hello again. I am really wavering. I am a developer, windows applications, not web. Until now I used VB6 to build client side user friendly applications. Server side usually are DCOM VC++6 applications (we develop laboratories and quality systems for manufacture). Now I have to develop a new client application, and I would like to try VB2005: I downloaded the express edition to evaluate it. Of coarse I have a lot of code, and tested user interfa ...Show All

• SQL Server OLE DB Source parameters ignored when subquery?

  I am using an OLE DB Source with SQL command for the data access mode. I defined parameters, then added a complex query with subqueries. It seems like the parameters for a query are not being filled correctly (because I am getting too many rows returned). At one point I saw an error message the said something to the effect that the parameters would be ignored when there was a subquery in the SQL. Can anyone shed some light on this Thanks, ...Show All

• Windows Forms Determine loading completed

  Is there anyway that I can determine whether a loading is completed. I've a textbox which has a initial text string. What I'm going to do is to make it invisible when user change its text. However, I found that the initial text string assignment has already trigger the event of making the textbox invisible. So, I would like to know is there anyway that I can check whether the loading is completed or not and add this code into the event handle ...Show All

• Windows Live Developer Forums BOTS on MSN

  There have been a number of questions about BOTS in the forum in various theads so I thought I would provide this post with a broader update on the topic. MSN has recently started licensing BOTS on the network.  The huge benefit of a licensed BOT is that it will have contact limitations removed (the reverse list), so that millions of people could connect to the same ID.  Our goal is to enable a broad network of these IM applications ...Show All

• Windows Forms Unbound DataGridView adding many rows is very slow

  Hello, I hope this is the right place to post; if it's not, someone let know, okay I am using an unbound DataGridView, and would like to add something on the order of a 1000 rows. It works fine, but it quite a long time to add the rows.  I am not sure if I should be using sometype of method to cause the data not to be refreshed until I am done drawing. Something similiar in concept to .SuspendLayout/.ResumeLayout. Anyone have any ideas &nb ...Show All

• Windows Search Technologies Querying the Vista Index using ADO

  (I originally posted this in the Search, Organize and Visualize in Windows Vista group on 6/16) Interested in searching the Windows Vista index using standard DB queries It's easy, but I can't find much documentation on it anywhere (please correct me if I'm just missing it). After searching a lot, I discovered/guessed the connection string and can successfully query the new index. Very fast, very nice! I posted about it on my blog ( http:/ ...Show All

• Windows Forms Need help with combo box

  I'm new to VB .NET, and I'm having trouble making a combo box do what I need. I'm sure you've seen this before. I have a table of US states called "tbl", containing the columns "ID" and "StateName". I have a table of co ...Show All

• Visual Studio #/Current Project/NewTest in Use. Can't Restore Path from Archive File

  I created a backup of my suspect VSS project (using Admin Tool). I then created a new VSS database. When I tried to restore the backup (Test.ssa) to a new VSS project ($/Current Projects/NewTest), I get the above error. I tried rebooting the server but that did no good.  Still getting same error. Can anyone assist Thanks Tom   Hi Tom, It looks from the error that the ssa file has the same ...Show All