corbin's Q&A profile

• .NET Development Connection problem to an Excel File with ado.net (OleDb.OleDbConnection)

  Hi everyone, I'm trying to add tables and data to an excel file with ado.net And I got this message : Driver ISAM not found while it's trying to open the connection I let you my connection string, I don't think there is error, neither in the register because, I checked it. olecon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & My.Application.Info.DirectoryPath & "\..\" & "Activity.xls" & ";Extended Properties=""Excel 10.0;HDR=YES""" olecon.open() I'm using Excel 2002 on the computer. Is soemeone ever had this problem thanks david Since you are having a driver issue...I would see if installing the latest and greatest MDAC will solve your ...Show All

• .NET Development .NET TCP/IP

  can someone please show me how me to create a very simple tcplistener app and tcpclient app here's my sample code on TCP Listener: Imports System.Net.Sockets Imports System.Net Imports System.Threading Public Class Form1 Dim server As TcpListener Delegate Sub DelegateServer() Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim thdServer As New Thread(AddressOf ServerStart) thdServer.Start() End Sub Sub ServerStart() If server Is Nothing Then server = New TcpListener(IPAddress.Any, 3030) server.Start() End If RunServer() End Sub Sub RunServer() Dim done As Boolean = False Dim client As New TcpClient() W ...Show All

• Smart Device Development Problem in windows mobile 5 sdk installation

  Hello, I have been installed Visual studio 2005. I installed : ActiveSync 4.1, Windows Mobile 5.0 SDKs for Pocket PC. In "device" I see windows mobile 5.0 emulator, but in "New project" I only see : pocket pc 2003, smartphone 2003, windows ce 5.0. I can choose in smart device project : windows mobile 5.0 pocket pc. Is somenone can help me please Thank you very much. I'm also having problems installing the sdk, however it seems to be that the sdk install won't complete - anyone got an idea why this would be ...Show All

• SQL Server Need ID after OLEDB command (insert)

  Hi, I'm stuck on the following thing: After a slowly changing dimension task I replaced the OLE DB Destination task by an OLE DB Command and created the insert manually. This because I need to work further on the dataset. So I do a union all between the output of the two OLE DB Commands (insert and update). Untill here no problem. But than, because I need an ID further on, I do a lookup in the table in which I just inserted and updated my data for the right ID's. When I run this project I get the error message " row yielded no match during lookup ". I don't understand this beacause I just inserted the data and I've checked, it's there. I could resolve this by splitting up in two control flows (reselect all the needed d ...Show All

• SQL Server continuous merge replication - event log

  Hi I have set up merge replication and it works nicely. I have set it up to work continuously, because I thought that if it can't find the subscriber or is offline then that's fine it will just sync again when it's back on line. This is true BUT it keeps throwing lots of messages into the event log to tell me the merge has failed. SO a. Can i just turn off the error reporting or b. How can I get it to sync this way automatically on connection without the error messages thanks ICW Unfortunately there's nothing built in to suppress these messages.  Maybe instead of running continuously, you can schedule it to run frequently, like every 10 minutes ...Show All

• Smart Device Development Symbol MC70XX series physical assigned button

  Hi, I am working on Symbol MC70XX device. I assigned buttons from Start_Settings_Buttons to some programs but I can not find the right physical keys for these assigned keys to start the assigned programs. For example for Button 1, what key do I press on the device to start the assigned program Any advice would be appreciated. Thanks Bahman Thanks, I did it, but no one of the keys starts the programs. Also I have looked at the link but I couldn't find the right answer. I mean on the symbol device, which key is Button 1 and so on uo tp Button 4. Thank you ...Show All

• Visual Studio 2008 (Pre-release) BitmapImage holding onto File??

  Anyone know what the behavior of BitmapImages created with a uri is suppose to be as far as holding onto the file handle In our application, we need to update images, but get file in use exceptions. This happens even when the parent windows of elements that are bound to the Uri are closed... Is there some standard way of updating images that are used for binding (it would be great if you could save the images to the same location) We have the same problem with deleting files (we work around this by deleting files when our application restarts). As a simple example of this problem (note there is no binding), we made two windows (the xaml is below). Window1 has a single button that has an image background. The application starts with Wind ...Show All

• Visual Studio Team System putting lib files in another directory

  Hi How do I put my generated lib files in a subfolder, and use them in the next projects using tfsbuild in my lib project i set Output directory to $(SolutionDir)$(ConfigurationName) librarian output file to $(OutDir)\lib\$(ProjectName).lib And the lib files end up in the correct folder \lib But my C++ project then fails because it looks in $(OutDir)\$(ConfigurationName) and fails beacause it cannot find the lib. Im using project reference to the lib project. I have an environmentvariable LIBPATH the includes the correct lib folder. If I just put the lib files in the outdir there's no problem, but how can I move them regards Kim Carlsen Thanks Is it ...Show All

• Visual Studio Team System TSD3006 Warning - Why?

  I have the following T-SQL fragment: Declare StepCursor SCROLL CURSOR FOR select GroupID from sdbsOpportunitySalesStep inner join SalesProcessStep_Group on SalesProcessStep_Group.SalesProcessStepRowID = sdbsOpportunitySalesStep.SalesProcessStepRowID Where sdbsOpportunitySalesStep.clientRowID = @ClientRowID and sdbsOpportunitySalesStep.OpportunityRowID = @OpportunityRowID and sdbsOpportunitySalesStep.OpportunitySalesStepRowID = @OpportunitySalesStepRowID and sdbsOpportunitySalesStep.StatusRowID = 1001 This fragment generates the following warning. Can anyone tell me why Warning 1 TSD3006: The relationship from [Procedure] dbo.Federation_OpportunityDataProcessing cannot be resolved between the following possi ...Show All

• Visual Studio Team System How to avoid explicit interface member implementation

  Hi,David,thanks a lot for your help. now, i have a new problem to ask for help from you! my rule is : Avoid explicit interface member implementation,except that If a class implements two interfaces that contain a member with the same signature. and ,how can i check it. thank you. Method.ImplementedInterfaceMethods will return a collection of methods so if you want to know if a method implements more than one interface method, simply check if the method collection returned by Method.ImplementedInterfaceMethods has a count of 2 or more. -Todd King ...Show All

• Visual C++ LIBCMT.lib(crt0.obj) : error LNK2019: unresolved external symbol _main referenced in function ___tmainCRTStartup

  I am attempting to write a C++.NET 2005 DLL (or assembly if I am using the terminology correctly) that wraps a C++ 6 .lib file (I am guessing that it is from C++ v6 because it is a SDK supplied by a third party). C++ is not my native language, VB is, so I am trying to write this wrapper so that I can do the bulk of my coding in VB.NET. I have managed to get the C++.NET project down to 45 warnings (which seem to mostly be the linker complaining about duplicate function definitions) and really 1 linker error: LIBCMT.lib(crt0.obj) : error LNK2019: unresolved external symbol _main referenced in function ___tmainCRTStartup The Configuration Type for my project is Dynamic Library (.dll) and in an attempt to fix this based on other articles ...Show All

• SQL Server DecryptByPassPhrase not decrypting varchar columns after copying a database

  I have an encrypted column of data that is encrypted by a passphrase. The passphrase was encrypted by a symetric key in a key pair. The passphrase also is stored in a table. I can get the passphrase as needed to encrypt/decrypt the columns. I copied the production database to a new database for development. Subsequently I had to create a new symmetric/asymmetic key pair and recreated my passphrase with the new key pair. Now the passphrase will decrypt a text column but it will not decrypt two other columns which are of type varchar in the database. Here is an example: DECLARE @pss varchar ( 30 ) EXEC [dbo] . [uspPassPhraseGet] @pss OUTPUT SELECT DISTINCT contactid , uissueid , createdby , created_dt , CONVERT ( varchar ( max ...Show All

• Windows Forms Where are DialogKeys processed in Designer?

  I want to be able to move the controls around in the desgner by pressing the arrow keys but I can't find where the ProcessDialogKey is being fired. Is it in a service somewhere I don't know about Ken For example i'm using a custom designer for .Net 1.1 The next to lines do the work of creating a new designerRoot and a new designer view. rootDesigner = (IRootDesigner)host.GetDesigner(designedForm); designerView = (Control)rootDesigner.GetView(ViewTechnology.Default); That designerView is the Control where you do the design (the designer surface) and you should dock it to a form. So if you handle the events of this control you should be able to invoke the commands. ...Show All

• Visual C++ execut ignor

  dears before I asked about this : I want to execut another program ( exe file ) from my program ( cpp ) what is the statment , is there anything more I have to add it to my program ( cpp ) like include ---- please give me an example I tried 1- CreateProcess 2- ShellExecute the program ( cpp ) is working but the (exe file ) not running if this problem because I am using c++ builder ,where can i download visual c++ free pls help thanks Try Visual C++ Express Edition ...Show All

• Visual Studio Team System Getting WorkItems by Project Name from TfsWorkItemTracking database

  Hi all, I would like to retrieve the list of work items from TfsWorkItemTracking database because of some reason, The only why i'm able to find out is to get all the Areas from TreeNodes table and then get WorkItems based on Area but it involves recursively retrieval of Areas, is there any other path to it why i'm saying project name in the title coz i wanted to retrieve them by project, and which is now i know i can do it via top most area from TreeNodes as its same as the project name and u cant rename it as well :). regards faraz well agreed, this is the only fear i had as well, coz i explored workitemtracking database and it had lots of different things in it.. but yeah i'v updated all the versions &q ...Show All