kaimerachin's Q&A profile
SQL Server sqlxml error
I have a number of apps which use SQLXML 4.0 Bulk Load. But, in a new program I am getting an error when I attempt to execute the following statement. SQLXMLBULKLOADLib. SQLXMLBulkLoad4Class bulkLoadObject = new SQLXMLBULKLOADLib. SQLXMLBulkLoad4Class (); The error is "Unable to cast COM object of type 'SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class' to interface type 'SQLXMLBULKLOADLib.ISQLXMLBulkLoad4'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{88465BA7-AEEE-49A1-9499-4416287A0160}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE))." The same statement executes fine in other apps on th ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Game and GameComponent Feedback
We've been combing the forums and the Connect database for bugs, feedback and suggestions around the application model. We still have a small amount of time to consider any other feedback you may have. So this is the thread that you post your latest likes or dislikes with Game, GameComponent, services, etc. Please scan the other threads before posting here, I'd like to just gather things that haven't already been discussed or reported elsewhere. Thanks! I believe that patterns of standard applications can be reused in games applications, but I believe that all standard patterns is not good or useful to make games, I believe that a handling of the nodes based exclusively on events can have a bad performance. I believe that ...Show All
Visual C++ Import Native C++ dll in Managed Project
I have some code which needs to be native that I am trying to include in a managed c++ project via a pluggin. It can't be added to references. The syntax for loading it manually, [DllImport("ArmWrp.dll")], is fine, but the functions cannot be found. Here is the simple pluggin, it is compiled with the unicode setting: // ArmWrp.cpp : Defines the entry point for the DLL application. // #include "stdafx.h" #ifdef _MANAGED #pragma managed(push, off) #endif BOOL APIENTRY DllMain( HMODULE hModule, DWORD ul_reason_for_call, &nb ...Show All
SQL Server Can't connect to local instance
Hi, SQL Server 2005 Developer edition Windows XP Pro This is a new install on this laptop. Trying to connect to the Database Engine using management studio using either TCP/IP or named pipes but getting errors regarding the server refusing connection. I've Googled these errors and as far as I can see I made all the adjustments that I need to. TCP/IP An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061) Named Pipes An erro ...Show All
SQL Server Import data using excel file!
I import data to my Database(SQL Server 2000). I use excel file to import, some file is ok, but wiht some file, some data cell in these is lost. What do I do now I believe DTS using Jet OLEDB provider to do the import and, I believe you could specify connection string for it. If ys, then you need to IMEX=1 property to the connection string. It will force Jet to treat all the values a strings and you should be able to see all the values. Whta happens is the Jet is using several first rows to identify type of the columns. If specific column contains mixed types text with numbers ot dates), then some values will be lost. Your connection string will look like "Provider=Microsoft.Jet.OLEDB.4.0;&q ...Show All
SQL Server Full-Text Crawl Error in logs
Hello I get tons of errors of this type. Are the error-code (x14b) documented I've checked a couple of rows but don't find what could be wrong. I'm running sql 2005 with sp1, noise-word files are empty, index has many columns which are in different languages. Thanks for any support Extract from log 2006-12-20 22:52:51.53 spid20s Error '0xc000014b' occurred during full-text index population for table or indexed view '[shab001].[dbo].[TSH_SHABDATA]' (table or indexed view ID '917578307', database ID '5'), full-text key value 0x00000000001E7E42. Attempt will be made to reindex it. 2006-12-20 22:52:51.53 spid20s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Programme\Microsoft SQL Server\MS ...Show All
Windows Forms getting error when running install for windows service
I'm writing a C# windows service and I created an installer using Visual Studio 2005. But when I run the installer it gives me the following error message: "Unable to get installer types in the C:\service.exe assembly. Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information." I added all the Dlls the service uses to the Primary Output in the setup and they are all contained within the same directory as the service. Any ideas The thing about the GAC is that assemblies aren't installed there until after the custom actions that install the service is run, so if your assembly with the installer class referes to a dependent assembly in the GAC it ...Show All
Visual Studio Express Editions radio button on top of a panel control
I have several panel controls on a form and each one contains a radio button. Once the radio button is selected that panels background image is changed. My problem is that, when the radio button is selected the next panel also changes its background. I do not know what is going on. help me! here is the code i am using private void radioButton1_CheckedChanged( object sender, EventArgs e) { panel1.BackgroundImage = Bitmap .FromFile( "c:\\mine\\images\\x.bmp" ); radioButton1.Visible = false ; } private void radioButton2_CheckedChanged( object sender, EventArgs e) { panel2.BackgroundImage = Bitmap .FromFile( "c:\\mine\\images\\x.bmp" ); radioButton2.Visible = false ; ...Show All
Visual C++ COM DLL, regsvr32 and manifest - blech!
I have a COM DLL that relies on MSVCR80.dll and when I try to register it with regsvr32.exe I get a "loadlibrary failed -2147220473" error. If I create a regsvr32.exe.manifest file and place it with regsvr32.exe, then it works. There has to be a better solution though. I can't count on target PCs having regsvr32.exe.manifest installed (and I'd rather not install it if possible). OK tjhat's a different manifest issue. Only the manifest for the EXE can set the requestedExecutionLevel. This can't be done at the DLL AFAIK. Here's a manifest for this: < xml version = " 1.0 " encoding = " UTF-8 " standalone = " yes " > < assembly xmlns = " ...Show All
SQL Server sp_xml_preparedocument VS nodes()
I am considering converting a stored proc which uses sp_xml_preparedocument to a select using the node() syntax. I made two sql scripts, one of each method with identical input xml and ran a query plan on each of them. To my surprise, the Sp_xml_preparedocument seemed to produce the better query plan. The Estimated subtree cost for sp_xml... was 3.36433 for 10000 rows and the estimated subtree cost for nodes() was 421.126 for 60 rows. Am I missing something or is sp_xml_preparedocument still the best method to shred an xml document sp_xml code: DECLARE @idoc INT , @trans_id int , @after_doc xml , @record_type int , @sm_session_id nvarchar ( 50 ), @trigger_start_time datetime , @user_id int , @fo ...Show All
Visual Basic Problem populating a Listview
Hello, I'm trying to populate a listview with records from an access datatable. I've the following code: Private Sub preencherListView() Dim lstItem As New ListViewItem lstFamilias.Items.Clear() lstFamilias.BeginUpdate() With Me .lstFamilias .GridLines = True .MultiSelect = False .FullRowSelect = True .View = View.Details .HideSelection = False .Columns.Add( "Familia" , 100, HorizontalAlignment.Left) .Columns.Add( "Tempo" , 70, HorizontalAlignment.Center) End With conexao() sSQL = "SELECT * FROM [TempoTotalFamiliaQuery]" da = New OleDb.OleDbDataAdapter(sSQL, con) da.Fill(ds, "TempoTotalFamiliaQuery" ) For i As I ...Show All
Smart Device Development Deploying Multiple cab files at once
I have developed my application and created the .cab file for this application. I followed the tutorial on creating an MSI file and custominstaller and this works fine. My problem comes from the fact that my application must also install .NET framework 2.0 and the SQLMobile .Cab file. I am wanting to package all of these together and be able to deploy them at one time from a users PC. I am not wanting to make the user click on each cab file to execute them. Can anyone point me in the direction of a good tutorial to accomplish this, or give me a good idea on how to do it. Thanks for any help I tried this a couple of times and it did absolutely nothing. as long as there is only one, it works fine. ...Show All
SQL Server Attach database
I have a database on a server and want to put it my local laptop that also has sql express. I attached the db, I see it in Management Studio but it does not show up in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data so my app is not working correctely. How do I get the db to show up in the MSSWL\Data folder. I'm a bit confused. Need some more info here, when are you getting this error If you can't find the server, you are not able to connect as you suggest. A few other questions: What is the name of your instance Have you confirmed that it's running in SQL Configuration Manager Are you able to connect from the local computer (i.e. where Sql Express is installed.) Thanks for the addit ...Show All
Visual Studio Express Editions express editions free books and tutorials
Anyone can please help me where to find free books and online tutorials about microsoft's express editions. Answers will be of great help to me. Thanks. C# Learning Center Visual Basic Learning Center Learn C# Express , Resources for learning C# Express Learn Visual Basic Express , Resources for learning Visual Basic Express HTH ...Show All
Visual Studio 2008 (Pre-release) Item Selection Area
Hi! I have Listbox and TreeView both have items that contains controls (textblocks and images). And i want to make selection of the whole item when user clicks on it. However selection occurs only when user click on some child control of the item but not when it clicks on "empty places" of the item (e.g. spacings between elements). How can i fix this Thank you I ran into something like this before. If an element's Background/Fill is 'Transparent' then it is not visible to hit tests. In that situation, clicking on it will not trigger the control's mouse handling logic to result in an item being selected. Try setting the background color of the control and/or item container and it should pick up t ...Show All
