FranciscoDaniel's Q&A profile

• Microsoft ISV Community Center Forums VBA in EXCEL - Connect to SQL Server

  I am a new programmer try to write some VBA codes in excel to get data out from the Sql server database. When I try to compile the codes, it said "compile error: user defined typed not defined" for the following sentences Dim dbsCurrent As Database Dim qdfPassThrough As QueryDef Dim qdfLocal As QueryDef Dim rstTopFive As Recordset Dim strMessage As String What I need to define for Database,recordset or QueryDef Please help! ...Show All

• .NET Development I don't understand an SQL statement

  I got this code in a program that works I links proper to an SQL server but I got a problem with the SQL statement, theres a Db named : oroNails and a Table named Colors with coloms like : " Id, name , htmlcode , ... " Code ------ Dim oCmd as SqlCommand oCmd.CommandText = sSql the sSql can be : "admin_colorsGetAll" or "admin_colorGetById" anyone who can explain me what ...Show All

• SQL Server Deploying RS reports with XML datasources?

  Hello- We've been developing RS 2005 reports which consume XML data from several webservices we've written. Now comes the issue of deployment. Our production server is not our development server. We've been using the development server URL for our connection string when we built our datasets... how does that work when we want to deploy these reports I suppose we can edit the RDL of each report and manually change the connection strings to refle ...Show All

• Software Development for Windows Vista ASP.net and workflowaborted

  Hi, I have a state machine which works fine until it reaches the Completed State. At this point, it doesn't complete, but the runtime raises the workflowaborted event after a long period. Where's the problem I use SqlPersistenceService for persistence. Thanks Here is how I usually debug problems like this. Run the workflow in the debugger - but before do Ctrl-Alt-E - this brings up the exceptions di ...Show All

• SQL Server running number

  how do i create running number in sql reporting services 1,2,3 and so on. it is beside my record. PLS HELP. thanks. guys pls post ur suggestions.. hi i got it. thanks. but i have this problem. i have this reports for gross pay, deduction and payroll report. with the deduction report it works but with the other it doesnt. they are similar to one another [in terms of groupings, etc. im using this code = RunningVa ...Show All

• Visual Studio Tools for Office Microsoft Object Library 10.0 vs Microsoft Object Library 11.0

  I am trying to Change some data through my app on a MS word Documents but i dont really know what object library i need to add a reference too, to make changes to my word doc in the code, any help out there You need to go to Add Reference and go to Microsoft Word Object 10.0 and then you will have the functionality u need for the word doc...hope this helps! ...Show All

• Visual Basic How can I prevent any type of pasting onto a txtbox.

  How can I prevent any type of pasting onto a txtbox. Thanks   William I'm curious to see if this has solved your dilemma. Let me know, if you don't mind, if this solved your problem. Thanks! ...Show All

• Smart Device Development Reservation System

  Hi. I want to make a client-server application used for reservations. The client is a pocket pc 2003 CF2 and the server app is a basic C# application running on a Windows XP Sp2. I am using VS 2005 and C#. So the basic idea is that the Pocket PC is connected by WIFI to the windows machine running the C# app. With the PP you should be able to make a reservation which will be shown in the C# app and the pp should be able to show reservati ...Show All

• SQL Server Bulk Insert Speed Problems

  Dear Experts, Our Server Information is: HP Proliant ML570 with 4 CPU (2.00GHz 512KB L2, 2 MB L3) It has 4GB RAM. We have 2 HP Smart Array 6400 Controllers with 192MB RAM. The Disks of the system are all HP ULTRA320 SCSI. We have 8 x 146.8 GB 15K, 2 x 72.8 GB 10K and 2 x 36.4 GB 15K We configured the Disks as follows: First Controller RAID 1 = 2 x 36.4 GB 15K - Operating System(Microsoft Windows Server 2003 Standard Edition Service Pack 1) ...Show All

• Visual Studio In RC1 - The option to "Leave this file" in unavailable

  After installing ssexp.exe from VStudio RC1 the option "Leave this file" is greyed out and unavailable when getting files for files that are writable. Can that be modified Is this an optional behavior Hi Gad, In the GetLatestVersion VSS dialog you can press the Advanced button, and set "Replace Writable" dropdown value to "Skip" instead of "Ask". This will prevent the ReplaceWritable dialog to come up.   Ye ...Show All

• Visual Studio Express Editions WebBrowser.Print method - no completion event?????

  Trying to print an html doc from a webbrowser object (VisStudio 2005) There isnt any PrintDone event that I can locate - how does one ensure the doc got sent from the browser so the browser object can be safely closed (Closing the object right after executing print and you will find that your doc does not get printed) I really need some help with this one! Code sample being used shown... static void Main(string [] args) ...Show All

• .NET Development Losing callback subscription in remote object delegate event

  Hi Firstly, I hope I described subject header correctly. Problem is that I seems to loose the subscribed delegate events on the remote server but look at the client remote object & events delegate seems to be valid. I am working a monitoring system, as below, Mon. client app <<<< Msg Provider <<<< Msg Service <<< Telesale Sys where Mon. client app & Telesale app is windows base app Msg ...Show All

• Visual Studio Interactive Crystal Report/VB.net

  Does anyone have any ideas on how to make an interactive Crystal Report I am using CR XI and when I develep a report in the Crystal development environment when the report is previewed I can cut and paste report values. I would like to run a report in VB using the report viewer, allow the user to click on the report, and have various code functions run based on where they clicked on the report. Can I do this with Crystal Is there a dif ...Show All

• Software Development for Windows Vista Workflow Persistence

  I need to store about 10 000 000 workflows in a database. With standart serialization one workflow takes 25 kb. Every instance has the same schema. Is there a way to minimalize the required db space My idea is to save the schema somewhere and then during the deserialization recreate the activity tree ( not deserialize workflow instance ). However, there're problems with activities' internal state. Does anybody know how to do it ...Show All

• SQL Server Unabel to connect to SQL 2005 Analysis Services in SQL Management Studio

  I just installed visual studio 2005 and SQL sever 2005 standard edition. I experimented a bit, and I got the following messag when I want to connect to Analysis services in SQL Sever 2005 Management studio. When I click the connect button, I got the following message: " A connection cannot be made. Ensure that the server is running (Microsoft.AnalysisServices.AdomnClient). No connection could be made because the target ...Show All