helper's Q&A profile

• SQL Server 64bit problem?

  I run SQL Server 2005 on a Windows 2003 64-bit server. I have created a package where I run an execute t-sql statement task. In the t-sql I have the following: select * from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="c:\test.mdb";User ID=Admin;Password=').pubs.dbo.data and I get the following error: The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered. There is only 32-bit version of Jet provider. You access it on 64-bit machine, if you run SSIS packages in 32-bit mode (using 32-bit dtexec from Program Files (x86) or setting appropriate option in project), a ...Show All

• SQL Server SQL Server 2000 and SQL Server 2005 on the same computer

  Hello. Is it a possibility to install two different instances on the same computer, one from SQL Server 2000 and another from SQL Server 2005 I've installed first SQL Server 2000 and I didn't want to upgrade it to SQL Server 2005. I don't want to upgrade SQL Server 2000 to 2005, because I'm working at two applications who uses different instances. Is there possible to appear conflicts between SQL Server 2000 and 2005 on the same computer ...Show All

• Windows Forms Online Application Problem

  Hi, I have a win form application which deploys a COM DLL on the client machine, registers it and calls a function from it. The COM DLL was in my bin folder of the application and i had added a reference to it to generate the interop dll. Then i had copied the COM DLL to the corresponding version folder in the virtual directory where i had publised the application. Then I added these files to the manifest using the mage tool and signed it. Signed and updated the deployment manifest also. All this works fine when my installation type is "The application is available offline also". Now I tried it for application availa ...Show All

• SQL Server Lookup - full caching vs partial caching vs no caching

  I needed to do lookup on tables with approx 1 million records (how else do I know if record already exists ). Full caching: SSIS caches all million records (consuming around 1 GB RAM) and cripples my lowly system with only 1GB physical RAM. This works for now, but the lookup tables will keep on growing. This means that full pre-caching may not scale for this scenario. Partial caching and No caching: I don't really know how SSIS works in these modes. I can make my guesses but it will be great if someone can explain those. The behavior that I see when I use partial cache of varying sizes or when I use no cache at ...Show All

• Visual Studio 2008 (Pre-release) Annoying behaviour in .csproj

  I have read somewhere that in the lasts CTPs it matters the order of MSBuild elements. Now because of that I have a problem when I rebuild some solutions, the <ApplicationExtension>.xbap</ApplicationExtension> element is put after this one <StartArguments>-debug "$(MSBuildProjectDirectory)\bin\$(Configuration)\$(AssemblyName)$(ApplicationExtension)"</StartArguments> Because of that VS throws an error (can't find a file) and I have to manually cut and paste the extension element before the start arguments. Are you facing this issue when porting projects created for a past CTP of WinFX If so, wh ...Show All

• Visual Studio Team System VsipHelper.GetTfsServer()

  The VsipHelper class was public in Beta 3, now it is internal. Code I wrote depended upon this type to get the currently-active server in the IDE via the GetTfsServer method. What is the best way to handle this in the RC You will need to get a TeamFoundationServerExt object. You do this by asking the DTE for it. So with a DTE object you would do something like this: ... using Microsoft.TeamFoundation.Client; // you will need to reference these two assemblies using Microsoft.VisualStudio.TeamFoundation; // <--- this one will be in the VS PrivateAssemblies directory ... TeamFoundationServer GetT ...Show All

• SQL Server Can't run dts package job

  I setup a job which call a dts package (I try to call it from file system and from SSIS Package Store with the same result) and it doesn't run. If you take a look from the SQL Server Agent you could see this --->> 2012-06-17 09:01:02 - ! [LOG] Step 1 of job 'prueba' (0x85B4D5E843DB3145A6A1A6A0A43D04F3) cannot be run because the DTS subsystem failed to load. The job has been suspended Any ideas Yes I can login to the box with Domain admin, then onto the Database engine with the SA id and password. I run the sqlagent job as a 'SQL Server Intergration Services package' and it fails with the 'faile ...Show All

• Visual Basic Controls Flickering when drawed on the form

  Hello there :) This was a Problem in Visual Basic 2003 when having a Form with about 150 Controls the form simply consists of panels and those panels have Labels and controls beside hem the form itself has a background picture ,,, the Panels also have backimages the Problem is when the form is shown the controls are being drawn really slow ... (the form is 1024*768) that wasn't a Problem at all back in VB6 anyway I saw that Visual Basic 2005 has a New Future called DoubleBuffered but it isn't doing any difference at all ... what are your Suggestions :) Thank you very much in Advance ! NGen.exe will create a n ...Show All

• Visual C++ Visual Studio 2003 C++

  hi all. ok, heres my problem.. i have created a nice simple program that allows for the drawing of different shapes. i have a number of menus allready working when the user click the right mouse button. I have tried to add another menu, but when i did, i keep getting this error: error LNK2019: unresolved external symbol "void __cdecl shapemenu1(int)" ( shapemenu1@@YAXH@Z) referenced in function _main .\Debug/latesttest.exe : fatal error LNK1120: 1 unresolved externals The program compiles ok allright, but the above linker error remains. Thanks all in advance for helping me. Make sure you are linking to the library containni ...Show All

• Visual Studio Express Editions How to get and/or set IP address?

  Hey, I'm using VB Express 2005 and I'm trying to write a small program to configure remote network devices. In order to do the initial configuration, I need to get the IP address of the local hard-wired ethernet adapter, or set it. One way of doing this, I figured I could set the local hard-wired adapter to DHCP and connect it to the device. Windows would assign an automatic IP address, which I could simply obtain. I would much rather be able to assign a specific IP address, do what I need to, and the re-set the adapter to its previous settings. Finding the correct hard-wired adapter could be as simple and promting the user with a list of ...Show All

• Visual Studio Express Editions Newbie: Parse and Formatting?

  First post, complete MSDN forum and VB n00b so please bare with me if my posting content and structure is lacking. I've created a text box where the user should be   allowed to enter the following variations of XYZ coordinates: <1, 1, 1> OR 1, 1, 1 OR 1 1 1 The first XYZ variation is the one I want the user to input (copy/pasted straight from a proprietary tool) If, however, the user enters the other variations ("1, 1, 1" or "1 1 1"), the program should format it to the first variation (<1, 1, 1>). The second problem I need help with is once the user enter the XYZ, the program needs to pull th ...Show All

• Visual C# table o cant found

  hi,my code look like this: DataSet dsKisi = new DataSet(); //... //executing a sql query and fiiling dsKisi dataset //.. gridview1.datasource=dsKisi; i am using a sql query with "inner join" when i debug this, an error occured. "Cannot find table 0." i wrote same query in sql server and no error occured and queried well. Where is the problem thanks.. Without the details under the comment "executing a sql query and fiiling dsKisi dataset" we won't be able to help you much. ...Show All

• Visual Studio Error: "Project Factory is unable to create an instance of ......" when using VS2005 release

  Hi, I have opened a report project and developed reports (rdl) in VS2005 beta. Since VS2005 release is ready, I upgraded the beta version to the release version. However, when I open the report project in the release VS2005, it prompts the message: Project Factory is unable to create an instance of: Microsoft.ReportDesigner.Project.ReportProjectManager, Microsoft.ReportingServices.Designer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 and the project cannot be opened. Also, I try to create a new report project but also failed with the same message. Does anyone have similar experience Any solution o ...Show All

• Visual Basic VB EE 2005 Reading/writing text box content to a text file?

  Hi coders How do you capture the content of a text box filled in by the user to a text file, appending new content and opening that file into the text box each time the application opens and showing the last entry first Thanks in advance...newtWales You have everything you need in the System.IO namespace. And there are many tutorials avalible on this subject. All you have to do is search for them ;) ...Show All

• Visual Studio Express Editions Find the first empty MaskedTextBox...

  I've searched through the forum, and I haven't been able to locate any code that is similar that I could modify, or find a thread close to what I'm trying to do, so any suggestions would be appreciated. (I'll get a book when I can get some time off) I have a form with ten empty "MaskedTextBoxes". I would like to go through them starting from "MaskedTextBox1" through to MaskedTextBox10" in that order, find the first empty one, and place the value I've selected in "DateTimePicker1" into it. I'm new to VisualBasic 2005 Express Mike C. // I'm new to VisualBasic 200 ...Show All