Daveo__'s Q&A profile

• SQL Server Could not create Maintenance Plan

  Hello, if I try to create a Maintenance Plan from my local workstation I get the following Error Message: TITLE: Microsoft SQL Server Management Studio ------------------------------ The action you attempted to perform on a remote instance of SQL Server has failed because the action requires a SQL Server component that is not installed on the remote computer. To proceed, install SQL Server 2005 Management Tools on the remote computer, and then try again. For more information, see "How to: Install SQL Server 2005 (Setup)" in SQL Server 2005 Books Online, or find the article on MSDN at http://go.microsoft.com/fwlink/ LinkID=57083 . (ObjectExplorer) For help, click: http://go.microsoft.com/fwlink/ LinkID=57083 On my loca ...Show All

• Visual FoxPro multiple line data entry into memo field

  I am fairly new so please excuse any mistakes I make in posting my question. Our company runs a debt collection software that has a foxpro 6 backend. We run a telephone dialer that I am trying to report multiple contact attempts into the data base. Her is how I do it if I want to import one line of data: tables used: Destination table = coldbtr Destination Memo Field = dbtrref Record ID = dbtrno Import dbf = data ( there are 5 fields included the first being my unique id field which = dbtrno I will refer to them as 1, 2, 3, 4, 5 (1 being the record id)) use data index on 1 to data select 0 use coldbtr set relation to dbtrno into data set filter to data.1 = dbtrno replace all dbtrref with "DI ...Show All

• SQL Server Update or insert into SQL table from excel source

  Hi all, I've had little success gooling/searching for this (so far). Given a simple spreadsheet: StoreNumber StoreName 1 UPDStoreName_1 2 UPDStoreName_2 3 UPDStoreName_3 4 NEWStoreName_4 I want to have an SSIS package that will update a table: mystores (storenumber int, storename nvarchar(255)) StoreNumber StoreName 1 StoreName_1 2 StoreName_2 3 StoreName_3 5 StoreName_5 .. what I need to do is insert the new, update the existing and leave the remaining unchanged. i.e. : StoreNumber StoreName 1 UPDStoreName_1 2 UPDStoreName_2 3 UPDStoreName_3 4 N ...Show All

• SQL Server How to use CLR security ..Impersonation to access external resources?

  I want to Access External resources inside the CLR Code... But I am getting Security Exception I have marked Assembly with External Access... here is the way I am doing.. I read articles and MSDN .. everywhere is written to use impersonation like using ( WindowsIdentity id = SqlContext .WindowsIdentity) { WindowsImpersonationContext c = id.Impersonate(); //perform operations with external resources and then undo c.Undo(); } In above case .. I tried both Windows Authentications and SQL Authentications ... In case of Windows.. I am have a domain login to logon to my pc, while sql server is at another machine and Active directory is at different machine .. when connect to Database .. it says cannot fin ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 360 Deployment Issues

  Hello   I've downloaded the latest version of XNA: GSE, signed up to Creators Club, downloaded the launcher, created a key and entered it into GSE.  The 360 is sitting there waiting for a PC connection but the deployment just times out.   I've checked the subnet and they're both 255,255,255,0. It doesn't work whether it's wireless or wired. I can't ping it from the PC, it just times out. Got another pal to try pinging their 360 from their PC and they get a similar time out.   I've also made sure all the required ports are open, I think.  I'm not sure, we have a Belkin router and I've added the ports the docs say to add but I can't test whether they are actually open or not.   L ...Show All

• SQL Server DTS Wizard SQL 2005 - Enable Identity Insert

  I have a large number of Access tables that I need to periodically bring to SQL using the DTS Wizard in SQL 2000 (via Ent. Man). I am only interested in bring over the data from the MS Access tables as I had a separate script (application drive) that would create the SQL tables. The problem is this: with SQL 2000 when bringing over the tables, the check box for 'Enable Identity Insert' for each of the tables was checked , this worked fine. With SQL 2005, this checkbox is not checked hence, I have to click 'edit' for each of the table data being brought over and check the 'Enable Identity Insert' box manualy. My question is whether there is a way to have SQL 2005 have this 'Enable Identity Insert Box' checked by default as it did with SQL ...Show All

• Visual Basic Refresh the table adapter

  First lets start with, I downloaded the 2005 Visual Studio beta 2 ver. and I am programming in Visual Basic. This is my first project with this language and I let the wizards do all the work. To my suprise the automatic wizard code fail to write the correct code. Steps I made a connection to a access database. I installed a dataview grid and then tried to correct data. I got the following error when I tried to (save data). Update requires a valid UpdateCommand when passed DataRow collection with modified rows. Look at the Public Overloads Overridable Function Update( ByVal dataTable As SubContractorsDataSet.SubContractorsDataTable) As Integer Return Me .Adapter.Update(dataTable) End Function I read some other ...Show All

• Visual Studio Express Editions Error font when bind data to Dropdownlist control?

  I store data in SQL Server, when i display it in < select id ="Select1" name ="calling" size ="25" ondblclick ="selectcall()" onkeypress ="selectcall()"> <% Response.Write( "<option style=color:" + colors + " value=" + calldetailrow.CallID + ">" + calldetailrow.CallID + "-" + calldetailrow.CusName + "-" + RecallTime + "-" + csmail + "-" + calldetailrow.CusTel2 + "-" + calldetailrow.CusCreateUser + "-" + calldetailrow.CusLastUser2 + "- Z:" + calldetailrow.ZoneID + "" + uname + "</option>" ); } %> ...Show All

• Windows Forms DataGridView wont show new entry..until i run it again

  Guys..i'm new here...and new with VB2005..im having this problem..that my datagridview wont show the new entry(i have a reg page) until i rerun the program...can anyone please look it up..tnx very much..could really use some help.. Form1.vb: Imports System.Data.OleDb Public Class Form1 Private AccountsDataSource As New BindingSource(My.Application.DAL.dbDataService, "Accounts") Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.dg.DataSource = Me.AccountsDataSource End Sub Private Sub dg_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dg.CellContentClick End Sub Private Sub Fill_Click(ByVal s ...Show All

• Visual Basic Finding a quoted string

  I am trying to write a macro for Visual Studio that will search my source code and put a bookmark on all quoted strings that the first character is not an underscore (_). I have written many macros but this one is giving me a problem, I cannot get it to escape the " in my search string. I can perform the search manually, but cannot get the macro to work. Any Ideas I am sure it is just a matter of specifying the correct FindWhat string, but I have tried everything I can think of and nothing works. Here is the macro - Sub FindNonConformingStrings() DTE.ExecuteCommand( "Edit.Find" ) DTE.Find.Target = vsFindTarget.vsFindTargetCurrentProject DTE.Find.MatchCase = True DTE.Find.MatchWholeWord = True ...Show All

• Visual C# Howto see what files are changed?

  Hello! I got txt file of all files selected. and treeView. How i can keep track of that list of files, and see if they get changed All help is "more than welcome". use FileSystemWatcher to monitor directory or files for changes for more info look at http://www.c-sharpcorner.com/3/FSWatcherMB.asp http://www.c-sharpcorner.com/3/FSWatcherDesMA.asp ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Drawing points

  Hi - new to C# and XNA, but an experienced C/C++ coder. Maybe I'm being an idiot, but having gone through the XNA Game Studio Express (beta) docs I can't see any convenient way to draw 2D primitives such as rectangles, lines or points (ie. things other than sprites). Is there any equivalent in XNA for a Direct3D point list for example I just want to plot some raw pixels in 2D, and right now the only way I can see to do that is to create a big Surface or Texture2D and then use the setData method, which seems a little wasteful to me. Is there a better practise for this kind of thing, a more efficient way to just set pixel values Thanks for the replies and the advice. Of course I understand the options, but ...Show All

• .NET Development Difference between ADO Execute and (Delete, Update, Addnew)

  This forum topic is for ADO. I am working in Pro*C to ADO equivalent conversion. In Pro*C method, update, delete and insert sql statements are availabe. The same code should be used for both ORACLE and SQL Server database. There are 2 approaches to convert these statements: 1. Connection.Execute "sql statement for update, delete or insert" 2. Open the Recordset with use of select statement for update, delete or insert. Change the feild values and call the Recordset.Update method for update query, Recordset.Delete method for delete query or Recordset.Addnew & Recordset.Update for insert query. Which is the correct approach in ADO for the above 3 types of SQL statements Thanks for your response. Consi ...Show All

• Visual C++ Converting Hanlde to string

  hello, i'm doing some key hooks and I need to convert the HWND or Handle types to string in C. is this possible as I know this types are simple integers, I'm converting it without any problem with delphi, but I'm too week in C :( any help would be appreciated :) Would that be C or C++ In the former case, use snprintf, such as char buf[9] = {0}; _snprintf(buf, sizeof(buf), "%p", someHandle); Print the buffer to screen by use of printf. For C++, you can use the stream classes, such as std::ostringstream str; str << std::uppercase << std::setw(8) << std::setfill('0') << std::hex << (unsigned long)someHandle; Print the buffer to screen by use of std::cout << str.str( ...Show All

• Visual Basic Storing the value of a field from a table into a variable to be displayed on the screen

  I know I am close with what I am doing but haven't found quite the right combination yet. I am a newbie so please bare with me!! I have a table called Dimension1Goal1 in a dataset called CCADPDataset that I am trying to pull the value of a field called Intervention1_1 out of to display on the screen. Her is what I have coded: Dim DimGoalMethod As String DimGoalMethod = CCADPDataSet._Dimension1_Goal1.Intervention1_1Column I keep getting the error Value of type 'System.Data.DataColumn' cannot be converted to 'String'. The properties of the field is a system.string, why can't I do this and what should I do HELP!! Hmm well lets see if this helps. Row Index | | 1 | 2 | 3 | 4 | Column Index | | test | ...Show All