sophmoricinbehavior's Q&A profile
Windows Networking Development Trying to use Winsock control in Microsoft Access Database Form
I'm trying to create a telnet session within my microsoft access form. I included the microsoft winsocket control and some text boxes to place the recieved data. The problem I'm having is I recieve data but it is all scrambled like yt%yy and it doesn't take any of my data I'm entering. The current telnet software I'm using is using VT101 emulation if that might have something to do with the scrambled info, but I dont want to use this software and Access. I would like to keep it all in one application if possible. I just need some help where I might be going wrong or any other idea's. Here is a sample of the code I'm using. Option Explicit Const EchoPort = 23 Private Sub cmdConnect_Click() Dim temp As String temp = ...Show All
SQL Server Copy data from 2000 to 2005 using Express Edition
Hi all I am using Windows XP Prof, SP2 and having Sql Server 2000, SP4 and SQL Server 2005 Express Edition with Advanced Services SP1, and SQL Server 2005 Express Edition Toolkit SP1 installed. The toolkit is the one which created me the DTS folder in the root with this applicattion: C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe I start now this Wizard and choose from Sql server - which is my 2000 version and to my sql express version, id/pw or windows authentication. I receive then the message: Cannot continue for the following reason: 1) You have chosen a server that does not contain any packages. 2) The server you have chosen is neither a sql server 2000 nor sql server 7 The SSIS Migration Wizard c ...Show All
SQL Server Adding Row Numbers to Flat File Source
Hi, I was wondering if it was possible to add an identity column to a flat file data source as it is being processed in a data flow. I need to know the record number of each row in the file. Can this be done with the derived column task or is it possible to return the value of row count on each row of the data Any help on this is greatly recieved. Cheers, Grant Rafael, Jamie, Thanks for both your posts on this matter. I'm looking into Rafael's suggestion at present and see that the only way to access variables in the data flow section is within the PostExecute phase. That problem with this is that it doesn't seem to update the variable as i move through the rows in the dataflow. Is this because of how SSI ...Show All
Smart Device Development where and how to start off to get your home automated
where and how to start off to get your home automated where and how to start off to get your home automated Requirements: prices and locaton a device to control more than 20 devices on a single storey apartment centralised touch screen(preferbably) and remote control most importantly to be compatible to use in singapore. Sorry, but this forum is for questions related to the DeviceEmulator, not general Q&A about hardware. Barry ...Show All
SharePoint Products and Technologies Sorting and combining two different lists
Hi, I'm struggling with a problem scenario.... I have two lists....both having few common columns and few individual... there is one column common to these two....Timestamp What I want is that I need to sort these two list as a whole on timestamp....can this be done... I have read somewhere that we can create views.....can I create a view of both lists contaning only common columns and combine the views and finally put them into single list and sort on timestamp.... has anybody already done this Thanks Manu ...Show All
Visual Studio Express Editions Storing Stuff
Dear All, This may seem a little simple to some of you but its been slowly winding me up for a while now, so any pointers or advice would be greatly received. What I'm looking to do is store information inside my application, with out using a database (I mean Access, SQL etc.) I have used *.bin files in the past but I'm not sure that they would meet the needs of what I need to do. The project is for a small charity and so far has about 850 records that they wish to store, they mainly use open source or freeware and need to be able to move the data between desks and back it up on a daily basis. Also some times they are not connected into the network so a local copy of the said information needs to be copied to the local machine. ...Show All
Windows Forms Editing in Datagridview!
Wadup! I have a GUI with a datagridview . The user can select some data (out of an integrated table) and the selected data from this table will be automatically written into a row of the Datagridview. Now that the data has been entered in the datagridview row, i want to implement a feature in which the user can manually go to row( with a mouse click for example) and make some changes in the data (for example change age=23 to age =24) which was automatically transferred from the table based on user selection. so basically i want to implement edit functionality for a datagridview row on a mouse click event after some data has been entered in the row. Ho do i do it Cheers! The first thing to ...Show All
SQL Server loading mining model error
Hello, I am using SQL Server 2005, and trying to load a mining model : microsoft association rules through a VB.net. When it is loading, this error msg displayed : "An error was encountered in the transport layer. The peer prematurely closed the connection." Any help is really appreciated. Thanks a lot, Mita Are you doing this in a VB.Net app where you've embedded the DM viewer controls The error you're seeing might be due to mismatched client components. Did you happen to have pre-release bits of the client components (the OLE DB provider, msolap90.dll, as well as ADOMD.NET) on the machine where you're running your app Re-installing RTM client components on the machine would fix the proble ...Show All
Smart Device Development obfuscate CAB files
Hello, I would like to obfuscate my assembly before deploying it to my PPC. Using Dotfuscator from the VS i created an obfuscated .exe. my question is how can i incorporate this .exe into the CAB setup wizard or what is the sequence for obfuscating the assembly I figure out that i can put several .exe (obfuscated or not) into one cab file. however when installing, windows mobile will treat the cab file as one programs even thu there's multiple .exe files. ...Show All
SQL Server Ignore conversion error
I have a table that has a date column formatted as char(6), MMDDYY. The dates need to be converted to datetime. I use the following command: UPDATE Table1 SET CorrectedDate = CONVERT(datetime, SUBSTRING(Date, 5, 2) + SUBSTRING(Date, 1, 2) + SUBSTRING(Date, 3, 2), 1) That works until it hits a date formatted incorrectly. The date could have blank spaces, double zeros or an invalid month/day/year (e.g. 033986). The command stops with a conversion error and no values are written to the CorrectedDate fields. Is there a way to have the command skip the invalid dates and continue to write the datetime conversion for the dates that are formatted correctly Edit: Forgot to mention this is on ...Show All
Visual C++ /DEBUG option for release build
I want to create PDB files for my release builds using VS8. Will doing this impact the run-time performance of the module Thank you. -Mike Passing /DEBUG to the linker will disable a couple of optimizations, identical comdat folding (ICF) and removal of unreferenced code/data, so you have to manually enable them. We use /DEBUG /opt:icf /opt:ref in our release builds. ...Show All
Visual Basic Force the printer to print to a new page
I have a situation where I want to force PrintDocument to start a new page even though the previous page is not full. This would be like placing a page break in Word. I have tried using (.HasMorePages) but to no avail. The output has a combination of text and graphics if that makes a difference. Thanks. The code is quite extensive so I will try to explain what I am doing. The code preceeding the HasMorePages=true is a combination of .Graphics.DrawString, .Graphics.DrawLine and .Graphics.DrawImage methods. I then set HasMorePages=true, in order to start a second page, set the line counter to 0 and then perform the additional .Graphics.DrawString methods. The preview shows the subsequent text written over th ...Show All
Windows Search Technologies Problem with WDS 3 beta 2 indexing locations
After installing WDS 3 beta 2 everything seemed to be working as expected. However after a few days I noticed that WDS was no longer indexing documents and settings. When I looked under indexing options, included locations, the only item present was Outlook 2007. I thought this was strange as I knew that documents and settings were definitely being indexed before, and that there was an entry under excluded locations for application data; default user, when I last checked, which had obviously also disappeared. I then clicked on modify and re-selected the missing locations and clicked OK, WDS then re-indexed and all seemed fine....for a day or two, then these locations disappeared again! This time I clicked on restore defaults, clicked OK, r ...Show All
SQL Server extract data from SSAS and feed to a formated file / another application
Hello, I'm looking for a tool which is able to connect to SSAS Cube, extract data and transfer it to a file (as interface to another application). With reporting services I can extract Cube data but can't transform to the right file format and with SSIS I can't extract the data from Cube. Do you have any ideas, tools, links, etc. Thanks in advanced! -flyall- Hi, I tried a MDX query in "OLE DB Source" -> "SQL Command" but the tool can't identify the output coumns. Is this a typical problem cu -flyall- ...Show All
Visual C# Generics: Test for a datatype
Hello, I want to add special handling for a generic class I am writing. See below: class MyGeneric<T> { private T val; public MyGeneric(int src) { // I want to add customized handling such as this below: if (T is string) val = src.ToString() } } Is this possible with generics The code belos is not exactly what I want to do, but hopefully it gets the point across... I want to have customized handling for cartain types for T. Thanks for the suggestions... I tried doing the cast as suggested, but got yet another couple of compile-time errors (see code below): error CS0131: The left-hand side of an assignment must be a variable, property or indexer| error CS0029: Cannot implicitly con ...Show All
