h1's Q&A profile

• SQL Server Pbm Migrating Access 2003 Database to Sql 2005Express Edition

  I tried various ways to migrate an access 2003 database with 1 table to sql Express 2005 Edition without success, I can only find the resulted sql database in Sql Server Express Edition 2005 without data. Please advise if any help. This article might help: http://support.microsoft.com/kb/237980 Buck Woody ...Show All

• .NET Development Searching Database for results

  Hi everyone i needed a little help with my coding what i wanted to do is allow my users to search a table in the database for links that are stored there for a user searches for a ringtone by a artist and the search returns any results with that value to the sure to be able to download the ringtone. I am using ODBC as well all help is appreciated ok thanks alot ahmedilyas  got everything working fine one thing Say if one of the cells have a link to a file how do i make the link in the cell a hyperlink. So that when that cell is click it will take them to the link that is in that cell.   ...Show All

• Smart Device Development BYTE and WCHAR types

  Hi! My code reads data from file on pocket pc emlator into the &buffer variable. If buffer type is set as BYTE buffer[1000] everything works ok, but if as TCHAR buffer then I get nothing filled in to the buffer from file, exept some strange symbol. I need &buffer to be TCHAR type, is there any way to convert it from BYTE or why is it nor working for me I did save file as unicode, and as ansi, it is all the same. However there are functions wctob and btowc, that you can use for conversion. Refer to http://msdn2.microsoft.com/en-us/library/634ca0c2(vs.80).aspx I hope it helps. ...Show All

• Visual Studio Express Editions Numbered List in an rtb

  Hi. Im using .selectionbullet to determine if my rich text box selected text has a bullet on. Is there a way to do this for, say a numbered list ...Show All

• SQL Server Fragmented databases and database backup

  Hi, If a database file size grows and shrinks it becomes fragmented. When creating a backup of a database and to restore it on another SQL Server, does it increase the fragmentation on that server How can I keep database files defragmented Does SQL Server have tools for that or should Windows defragmentation tools be used /M I think you are confusing data file fragmentation with disk fragmentation. They are two separate issues although they both affect performance of SQL Server. If you backup your database and restore to a different server, it will not have any disk fragmentation if there is enough contiguous space to hold all of the data. Otherwise, it is at the mercy of the new disk drive. ...Show All

• Visual Studio Team System KB919156 fails on proxy server when not installed in the default location

  Just a message to those of you who (like me) installed the TFS Proxy server in a custom location (other than C:\Program Files\...). When attempting to upgrade to SP1 and run the initial patch (KB919156), the setup will fail with a message that there is a problem with the Windows Installer package. To correct this issue, I had to reinstall my proxy server in the default location on c:\. I left the cache data directory on d:\ in a custom location as I had before. This was able to get me pass the error related to KB919156 and complete the install. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Constant Buffers and Effects Framework

  Here's my interpretation of how constant buffers work using the Effects framework: I set up various constant buffers in my HLSL code based on frequency of update. I access and set the constant values using the ID3D10EffectVariable interface. When I use an effect, the effects system determines if the values are 'dirty' within a constant buffer and updates them, but only when necessary. Questions: 1. Can leave all of the constant buffer handling to the effects system I don't need to call SetConstantBuffer for my values to be committed to the hardware 2. Why would I ever use Get/SetConstantBuffer in the ID3D10EffectConstant interface 3. If a variable is shared across multiple effects (and could exist in several different cbuff ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How much of a 3D engine will be included in the XNA Framework?

  In the DX samples there are the samples framework. Will that be built upon or will there be a separate 3D engine included or downloadable - What I am looking for is some kind of scene graph - Lighting and materials - Shader loader, constant setter etc. I am guessing since Torque are releasing their engine for this we will not see a full featured engine included but will there be an embryo that is more than the DX sample framework Regards Joachim Shawn Hargreaves wrote: We don't have an out-of-the-box packaging system for version 1, but would appreciate feedback if this is something you would find useful in future. To roll your own, you'd need to do two things. Write a build task ...Show All

• SQL Server The attribute key cannot be found

  I am using SQL Server 2005. My Data Source View and its Query is below: ============================ FactVehicle: SELECT KeyDateTime, UnitId, FuelCode FROM TestsVehicle DimFuelCode: SELECT FuelCode, FuelName FROM DimFuelCode DataSource View Data: =============== FactVehicle: (SELECT distinct FuelCode FROM TestsVehicle – This query result is below) FuelCode G NN E NG PP F C M D P PG B N ============================================ Note: I don’t want to do Analysis on G, NN, E, NG, PP, F, C Fuel Code ============================================ DimFuelCode (SELECT FuelCode, FuelName FROM DimFuelCode - This query result is below) FuelCode Fuel Name X XYZ PG PG P P N N M M D ...Show All

• SQL Server Got Microsoft OLE DB Provider for ODBC Drivers error '80004005' when running Stored Procedures

  when i am running a Stored Procedures, system always returns me error message below and Stored Procedures stops. please help Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver] Received an unrecognized datatype 0 from TDS data stream sometime it returns error messge like, TDS Buffer Length Too Large or Unknown token received from SQL Server or Protocol error in TDS stream or Bad token from SQL Server: Datastream processing out of sync. or Invalid cursor state or TDS Buffer Link Too Large or Function sequence error Many thanks, Please help, appreciated Thanks Peter: it's SQL Server 2000 sp4, this problem happens on the OLEDB provider ...Show All

• .NET Development IoCompletion handle

  Hi. I'm not sure this is a right topic for that section. I have a problem with growing number of IOCompletion Threads. In our producion environment we have from time to time ExecutionEngineException. I was trying to understand what is going on and started from analysing DUMP file. I found that there are more than 1000 thread doing IOCompletion operation: 103 76 528 084fe878 880b220 Enabled 00000000:00000000 0014d518 0 MTA (Threadpool Completion Port) the stack of the each of them is: 0:044> ~103e k ChildEBP RetAddr 0e4af0f8 7c90e31b ntdll!KiFastSystemCallRet 0e4af0fc 7c80a746 ntdll!ZwRemoveIoCompletion+0xc 0e4af128 79f2f30a KERNEL32!GetQueuedCompletionStatus+0x29 0e4af194 79ecb00b mscorwks!ThreadpoolMgr::CompletionPo ...Show All

• Software Development for Windows Vista Error when attached to AppVerifier (Test Case 31)

  Hi, I have attached my application to the AppVerifier to run test 31. I run WinDbg and then choose to open my executable (File -> Open Executable) I am getting the following error in WinDbg: ModLoad: 6ba30000 6ba4a000 ApplicationUpdate.dll ModLoad: 068c0000 068da000 ApplicationUpdate.dll ModLoad: 6ba30000 6ba4a000 C:\Program Files\Fascia\ApplicationUpdate.dll ModLoad: 0bb50000 0bc98000 image0bb50000 ModLoad: 0bca0000 0bde8000 image0bca0000 ModLoad: 0bb50000 0bc98000 C:\Program Files\Fascia\SharpLibrary.dll ModLoad: 0bff0000 0c640000 image0bff0000 ModLoad: 0c640000 0cc90000 image0c640000 ModLoad: 0cc90000 0d2e0000 C:\Program Files\Fascia\KeSignature.dll ModLoad: 74510000 746ba000 C:\Windows\WinSxS\x86_microsoft.windows.gd ...Show All

• Windows Forms Sorting in DataGridView

  Hi : I have a DataBound DataGridView, one of the columns is a datagridviewcomboboxcolumn linked to another bindingsource. I want to sort by that column but based on the display value, not on the id value. I've been searching a way to do this, I havent been able to find it. I cant imagine that this is not possible. Could someone point me in the right direction. Thanks in advance Leonardo Actually the issue is when we click on column header of datagridviewcomboboxcolumn in that case it sorts the column by the underlying value i.e ID. That means sort is being done on the basis of Value member. I would like to know if there is any way out to sort DataGridViewComboboxColumn on the basis of it ...Show All

• .NET Development XUpdate using C# help

  Dear All, I couldn't find any way to update XML doument using XUpdate returned. Please advice if the .NET framework contains any namespaces or classes to work with XUpdate documents If XUpdate refers to http://xmldb-org.sourceforge.net/xupdate/ then I don't think the .NET framework has support for that. .NET has support for XSLT and XPath 1.0 however. ...Show All

• Visual C++ [C++] Implicit linking...

  Is there any way in C++ to specify a custom path to implicitly link a dll I don't want to stay under the Windows Os dll path search. I would like to specify a path in my source or through the linker/compiler. You could always go with a combination of LoadLibrary and GetProcAddress, that would leave you in control of the whole procedure. Otherwise, the searched locations will depend on how the target system is configured (see http://windowssdk.msdn.microsoft.com/en-us/library/ms682586.aspx ). What you could do, is have a dummy application launch your real application, and feed it with custom environment variables to alter the default locations. ...Show All