DeveloperJTM's Q&A profile

• .NET Development OleDbCommand.ExecuteNonQuery "Insert Into Select From"

  Hello, I am working with OleDb to perform a bulk insert from a temporary table to permanent database table, both of which belong to the same database. I am wanting to use "INSERT INTO <permanent_table> SELECT * FROM <temp_table>". The query I run in MS Access to perform this bulk load does process correctly, but not in code using OleDb. After properly setting up my OleDbConnection object, opening it, and properly ...Show All

• Visual C# socket exception

  ok made a very very good class server it can handle to 3879 clients but when it reach 3880 it throwes an exception like that says that it cant perform operation on a system socket because the socket`s quenque is full The ThreadPool only has 25 Threads, so it they are all used, no other async process can be started with that pool. I have writen a server application that can handle 10.000+ connected clients at the time without any problems. ...Show All

• SQL Server The Query Could not be processed. The data provider didn't supply any other error information (SSAS 2005, SharePoint, OWC 11)

  Hi, I have 2 cubes processed and deployed successfully on a 2003 server (SSAS 2005) . (I do get an attribute key error but I am turning it off using Custom Error Configuration). I am connecting to the cubes using OWC 11 pivot table viewer and OWC 11 Chart Viewer. These are deployed on a SharePoint Server Portal, which is hosted on the same server. As long as I view the sharepoint pages on the same server, the charts and tables display fine. W ...Show All

• Visual Basic How can i use lpParameters in Shellexecute()?

  Hello guys i am trying to write a program that executes a shell program like oracle Export, as you know for that kind of programs parameters is important, for example i have to do it with userid and Password also i want to change a password for example when a user typed my programs name in cmd and add userid and password and db_name, i want to change that password and send it to oracle i tried with shellexecute() but i couldnt use lpPa ...Show All

• Visual Basic mscomm vb6 --> vs2005

  I have a very simple vb6 program I want to convert to VS2005.  MSComm is nolonger available and I don't understand how to receive data without the mscomm_OnComm() event. Please advise.  Also, can this be implemented so that the code is exposed to MSAccess 2000   Ultimately I need to communicate to a piece of Lab equipment connected to the serial port using a production application written in MSAccess. Thanks *VB6 Code* Dim ...Show All

• Visual Studio Express Editions Strings won't initialise

  My program has been working for weeks. Today, two things happened: 1. The .sln solution won't open into VB.NET Express, so I had to re-associate the .sln extension with the program. 2. The program will not initialise strings to an empty string. For example: Private mystring as string Msgbox(mystring) This throws an error, saying the string is not initialised. But it works when I change it to: Private mystri ...Show All

• SQL Server creating an adjacency list from a parent - child table

  Hello, Using a parent child table with an additional column, I'd like to be able to build an adjacency list with a stored procedure. The additional column would contain the path ( a list of nodes ) from that member to the root node, e.g. root / grand parent / parent / child Does anyone know how to right a stored procedure that can do this Thank you, Rod What's a parent-child table   ...Show All

• Visual C# How to Refer a C# dll over the Network into a VB6 Application

  Hi , I am using a dll created by a C# project in my VB 6.0 Application. I am refering the dll from the Project-> Refrences from the VB 6.0 IDE the dll which i am using is now in the local system say " C:\Project\MyInterface " can any one help in refering this dll from another machine over the network. Thanks and Regards, Suraj you have to register assembly as COM object on local mach ...Show All

• Visual Studio UIPAB

  Dear,  Keith mentions on his weblog http://blogs.msdn.com/keith_short/default.aspx that the UIPAB can be used with a recipe. I have been using UIPAB in practice. The UIPAB, however, is rather difficult to explain to novice user. Do you think that a recipe might ease the UIPAB pain for novice users Does there exist a (demo) UIPAB recipe somewhere Do you think that there exists some interest in 'open sourcing' a recipe for UIPAB If this is ...Show All

• Software Development for Windows Vista Vista SDK Feb CTP installation issues on Win2k3 SP1

  I have been trying to install the Windows SDK on my virtual machine containing Windows Server 2003 Enterprise Edition with Service Pack 1. This has been causing me a lot of problems. I downloaded the full image and mounted the drive using the MS Virtual CD control tool. The install starts OK but gets to a point and fails on the setup. I followed the steps on this blog concerning known issues https://blogs.msdn.com/jsacks/archive/2006/03/16/55310 ...Show All

• Visual Studio How to display "ADD Webreference Dialog Box" programmitically

  Hi, Can anybody please tell me how to display "ADD Webreference Dialog Box". We are trying to dislay it using "AddWebReferenceDlg" of Interface "IVSAddWebReferenceDlg" but Dialog box is not coming up. Can anybody please let me know if their is another method to display the dialog box. Thanx in advance. Regards Kiran Hi Kiran, I'm afraid this forum ...Show All

• Visual Studio Express Editions error building application...

  Hi, I'm trying to build a simple winsock application and it is failing. I did a typical install. I'm pointing include to PSDK/include. I removed all framework references from project dirs. Still showing this ambiguity error. help. ------------------------- Compiling... c:\program files\microsoft platform sdk\include\servprov.h(93) : error C2872: 'IServiceProvider' : ambiguous symbol could be 'c:\program files\microsoft platform ...Show All

• Visual Studio Team System GUI Test Automation

  I am new to automation testing , I have been given a GUI and asked to automate the controls on it . I dont have any web interaction to my GUI, it just has some tabs, graphs, buttons, menu options, controls. How can I automate the whole GUI , so that when I create at testapp with a button onit to launch the GUI, then the key strokes on the GUI are recorded and the whole process is automated. Hell ...Show All

• SQL Server DtsConnection -- Consuming DTS DataReader In Code w/ Parameters

  I am trying to pass a parameter into the DtsCommand object, but always get the error "a requested parameter does not exist in the package".  I have a variable defined at the top scope named EmailPromotion so I tried the following command.Parameters.Add(new DtsDataParameter("User::EmailPromotion", 1)); and command.Parameters.Add(new DtsDataParameter("EmailPromotion", 1)); no luck either way It seems for th ...Show All

• Visual C# Making the page back to the same position...

  How can I make the web page comeback to the same position on a postback Like I have a dropdown at the end of the page, and when I change the selected value it calls a function, after that it come back to the top of the page, and not to the end.. Thanks Set the page's SmartNavigation attrbiute to true <%@Page SmartNavigation="true" %> ...Show All