Jay McCleery - jaysonm's Q&A profile

• SQL Server infromation about accuracy of the mining model problem

  Hello! I have a problem getting information about accuracy (percentage of the right predictions) of the model using DMX. Is it possible to get information about accuracy of the model using DMX I didn't find any useful function... My second idea was to build and process the model. And then compare states of the predictable columns of the test data to states that the model predicts on the same data. And count them. That would be the way to get pe ...Show All

• SQL Server Copy data from one table to another

  On the OLE DB Source, I have as following: select field1 , field2 , field3 from table_source On the OLE DB Destination, I used fast load option with table lock checked, and check constraints to copy data to table_destination. Both table_source and table_destination have the same table definitions. After the dtsx package ran, the number of rows copy over to the destination is not same. I got different results from different runs. This ...Show All

• Visual Studio Express Editions HOW TO programatically connect to Access DAtabase

  i want to connect to my Access datablse programatically i read through the help at... ms-help://MS.VSExpressCC.v80/MS.NETFramework.v20.en/dv_aspnetcon/html/c9caa6be-f3f2-400a-b6bc-2debbbf23703.htm "the local help" It says Open the Web.config file in the root directory of your ASP.NET application. If you do not have a Web.config file, create one. i have installed only VB express edotion 2005 do i need to install the completee v ...Show All

• Visual Basic vb.net and updating database

  I've been doing a tutorial on http://www.homeandlearn.co.uk/NET/vbNet.html and everything was fine until the part on databases and using dataAdapter.Update. I keep getting an error message. Here is the part that I have problems with Private Sub btn登 _Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn登 .Click Dim cb As New OleDb.OleDbCommandBuilder(dadapt) dset.Tables("bihin").Rows(incr ...Show All

• Visual Studio IS VSTA OK with Visual Basic 2005 Express?

  Hello All: Just saw the release of VSTA. Will this tool work with Visual Basic 2005 Express Thanks Can you explain your question Do you mean will they work on the same computer, can you develop applications that host VSTA, can you host VSTA inside of VB Express, etc Craig ...Show All

• .NET Development DataAdapter.Fill() is necessary?

  Hi all, In ADO.NET 2.0, there's a new method called DataTable.Load (DataReader) method, so is it necessary to use DataAdapater.Fill(DataSet) anymore I think all developers don't mind to write a few more line to change .Fill() to .Load() if the performance can be improved greatly after moving from DataAdapter to DataReader (as DataReader is native and fastest approach in retrieving record). Thanks, Fill() ...Show All

• Visual C++ command line build up-to-date when it shouldn't be

  I have a problem where a command line build of a *.vcproj file using the VCBuild task returns "BaseLib - up-to-date" when it really is not. BaseLib.vcproj produces the output library BaseLib.lib, and one of the *.cpp files in the project includes BaseLib.h. BaseLib.h has a last modified date of 5/30/2006, and BaseLib.lib has a modification date of 5/16/2006. The project is out-of-date right BaseLib.h *is* explicitly in the project. ...Show All

• SQL Server <Code>-8462</Code>

  Hi: My service broker is working with 2 different instances in local server.But could not able to get working on 2 different servers because of Conversation ID cannot be associated with an active conversation error which I have posted. After I receive the message successfully...in the end I get this message sent... < Error xmlns = " http://schemas.microsoft.com/SQL/ServiceBroker/Error " > < Code & ...Show All

• Windows Forms Can I change how Publish.html looks like?

  Hay! I'm new in Click Once publish and I don't know where to find any information regarding changing how publish.html looks like. I'd like to include in it my company logo and so on. Is there any tamplate on wich is based on Where can I change background color, fonts... And I don't want to change publish.html everytime I publish my app. Is there a way to make this changes only first time Thank you for your help! Hi pinkpan ...Show All

• Microsoft ISV Community Center Forums cannot save file as

  I can't save any files on any of my other drives. The message comes up as save file not responding. Also szAppname:WINWORDEXE, szAppver:11.06568.0, szModname:hungapp. Why can't you ever get help from microsoft without a fee After all this is their product. golferdrums I'm having the same problem. Did you get an answer to your question ...Show All

• SQL Server killing sqlservr.exe from sqlclr code

  I keep getting different answers from different people on regarding if you can or cannot kill the hosting sql server process with an unsafe assembly. Can you do this If so could you please attach a sample demonstrating this Thanks, Derek Is this simple enough public static void killsql() { System.Environment.Exit(-1); } Steven ...Show All

• SQL Server Best way to handle License issues

  Here is the scenario: We are developing an ETL type data load application and we're thinking building a SSIS package to assist with this. The application and data files to be loaded would be on the client Windows XP Workstation. The SQL Server 2005 instance would be on a networked server elsewhere. The XP Workstation would NOT have sql server 2005. What is the best way to handle this Can this be achieved fairly easily Kevin ...Show All

• SQL Server More than one data set, data region, or grouping in the report has the name ‘CustomerName’. Data set, data region, and grouping

  why am I getting this error  I have sevaral tables on my report and several datasources.  Each table is using CustomerName but using the same datasouce at the moment.  Why would this conflict   I'm not exactly sure what to look at. [rsDuplicateScopeName] More than one data set, data region, or grouping in the report has the name ‘CustomerName’. Data set, data region, and grouping names must be unique within a report. I'm us ...Show All

• SQL Server Microsoft people????

  Hi, The folks at Microsoft seem to frequent this forum a littlse less than they used to. So I'm reposting some links to some old queries that they may have missed. Hoping someone can help. Setting parameters in Web Service Task in SP1 - http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=261529&SiteID=1 Expressions not working on custom components - http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=264911&SiteID=1 Chec ...Show All

• Windows Forms ConfigManager filename issue

  My problem concerns using custom config files. When I load a config using 'System.Configuration.Configuration config = ConfigurationManager.OpenExeConfiguration("example.config");' the manager saves to "example.config.config". How can I stop it appending an additional ".config" to the filename I have been unable to duplicate this. Are you calling (essentially) the following two lin ...Show All