bunkscene's Q&A profile

• SQL Server Accessing the Current Transaction in BOL (April 05')

  Here is the text I do not believe is correct or at the least misleading... "If you want to terminate the external transaction from within your stored procedure or function. In this case, you call the Transaction.Current.Rollback method. " You cannot terminate transactions declared in TSQL in SQLCLR routines. Derek- Thank you for pointing out this. We will work to update this BOL article! It is possible to terminate transactions declared within TSQL within SQLCLR routines, but it is recommended to manipulate them through the use of System.Transactions.TransactionScope. For example, this would rollback the current transaction: using(TransactionScope transactionScope = new Transacti ...Show All

• Windows Forms Binding comboboxes to related tables !

  Dear friends... There are 3 tables in my database which 2 of them are related as parent and child. And here are the columns: Parent Table: ParentCode int(PK), ParentName nvarchar(256) Child Table: ChildCode int(PK), ChildName nvarchar(256), ParentCode int(FK) 3rd Table(MyTable): SerialNumber int(PK), Name nvarchar(256), Parent int, Child int These 3 tables are loaded into a dataset with the specified relation named 'ParentChild'.I want to store SelectedValue of comboboxes into the 'MyTable'. Two comboboxes are placed on my form with following bindings: comboBoxParent.DataSource = dataSet; comboBoxParent.DisplayMember = "Parent.ParentName"; comboBoxParent.ValueMember = "Parent.ParentCode"; comboBoxParent.DataBin ...Show All

• Visual C# Problem with Registry reading..

  I am using Windows Vista now and developing a Registry code in C# but i was surprised why when i use this code to SetValue: RegistryKey ping_registry_key = Registry.LocalMachine.OpenSubKey("SOFTWARE\\Jassim\\ping-to-ip", true); ping_registry_key.SetValue("ip_address", txtIPAddress.Text); it saves the data under this key: HKEY_CLASSES_ROOT\VirtualStore\MACHINE\SOFTWARE\Jassim\ping-to-ip instead of: HKEY_LOCAL_MACHINE\SOFTWARE\Jassim\ping-to-ip The message I'm replying to is about as close as I found to being relevant to my question. The referenced page in the MSDN library is .NET centric and this question is specific to an application I'm responsible for which is not based on .NET. I've been unable to locate a similar p ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How long does it take to make a game?

  i'm answering my own question here. For people new to game development: longer than you think! i was just cruising around a forum where some folks were daydreaming about what they'd create with XNA GSE, and giggled a little when i read "Grand Theft Auto" and "FPS": http://forums.gametrailers.com/showthread.php t=32477 The Independant Game Festival has a great site if you want to check out the cream of the indie crop. It's especially valuable because it records how long each game took to complete: http://www.igf.com/02finalists.html You might check out some screenshots and think "three years But that game looks like ***!" Yes, my friends. Yes. :) Start small. Build complexity from simplicity ...Show All

• Visual Studio 2008 (Pre-release) IIS hosting does not automatically start service on call, need to manually hit the server

  I have a few wcf services, hosted by IIS. When my client application does a call, it will result in an exception because the service is unavailable. I have to manually load one of the .svc's to get it to work. After that, client calls work as expected. Is there some way to change this behavior os: xp sp2 iis: 5.1 .net framework 3.0 rc1 The web.config is indeed in the same directory where the *.svc files are. I gather from your responses that the behaviour is indeed not expected In other words, you client will have no problems making a call to you service just after an iisreset has been issued ...Show All

• SQL Server Freeze Pane functionality during Export to Excel

  Hi All, I have created a Report using Sql Server 2005 Reporting Services. When I export the report to excel, I want to freeze the pane of the headers in the exported excel. Any pointers on how to achieve this will greatly help me. Thanks, S Suresh Geoff, Thank you so much for your link. Looks like it is for sql sever reporting service 2005. We are using 2003 but I tried anyway. I used the way change the setting through adding render section in xml code but got error. The question I have is where should I put the render section in the xml code Below is the code, please help me out. Thank you very much for your help! <Report xmlns="http://schemas.microsoft.com/sqlserver/repor ...Show All

• SQL Server foreign characters are not being imported into the table correctly

  hello everyone, i have few fields that contain foreign characters with diacritic marks which are not getting imported correctly. below is the import format: - File type: ASCII - Row delimiter: carriage return and line feed {CR/LF} - Column delimiter: Tab - Text qualifier: None Please advice. Here is the errors i'm getting: - Executing (Error) Messages Error 0xc02020a1: Data Flow Task: Data conversion failed. The data conversion for column "Country_str_local_long_name" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". (SQL Server Import and Export Wizard) Error 0xc020902a: Data Flow Task: The "output column ...Show All

• SQL Server SQL Management Studio from desktop PC connecting but no acccess to service functions

  I have a new and virtually full installation of SQL 2005 Developer with SP1 installed (named instance), on a Windows 2003 standard server, which also has a default instance of SQL 2000 SP4 installed. I have the browser service running also enabled TCP/IP for remote connections via configuration manager. All services are currently using LocalSystem. From the server I can use Management studio to connect and manage the services i.e. I can right click, start stop etc.. From a desktop on the LAN I can connect just fine, but I cannot see the service states, nor can I manage them from the right click context menu. There are no firewall issues here, just a hub separating the server from desktop. What am I missing ...Show All

• Windows Live Developer Forums Bug using window.external.Users and IE7

  Hi, I've been working on a Messenger activity and keep running into a problem with Live Messenger and IE7. For instance, if I create a web page and include this script in the body: <script type="text/javascript"> if (window.external.users.inviter === window.external.users.me) { document.write("I am the Inviter."); } else { document.write("I am not the Inviter."); } </script> On a machine running IE6 it works as expected on IE7 I get an error "Library not registered" Any help is greatly appreciated. This is a HUGE problem! Thanks. My computer sucks.... I reinstalled Messenger and the error went away. Now there's a new problem ...Show All

• SQL Server Msg 102, Level 15, State 1, Procedure dni_invoices_get, Line 37

  Hello, I am using SQL express as a backend for my websites and my accounting software. When installing my new app I run the install.sql file and all is good untill the end. the following error occurs. Can someone direct me where to look to fix this please Msg 102, Level 15, State 1, Procedure dni_invoices_get, Line 37 Incorrect syntax near '.'. Thanks eveningjazz Hi, you will have to post the procedure text to enable us to help you. Appearantly there is a syntax error within your procedure text. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Microsoft ISV Community Center Forums MS Office document and image writer print driver

  Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. Hello, I have the opposite problem. I have users who have had the icon for the Office Document Image Writer deleted under Printers and Faxes. You mention above that it is easy to reinstall the virtual printer. Could you point me to the directions for reinstallation pleas ...Show All

• Smart Device Development ANN:PopupMenu beta

  We're starting a beta process for the PopupMenu component. Please see the link for more information: http://blog.opennetcf.org/ayakhnin/PermaLink.aspx guid=40f523df-4430-4195-97a9-269d1487ee39 -- Alex Yakhnin, Device Application Developer MVP http://blog.opennetcf.org/ayakhnin ...Show All

• Visual C++ help!!

  hi i really need help on this bcz some how i find it hard and im clueless ** write a program that prompts the user to input a positive integer. it should the output a message indicating whether the number is a prime number. plzzzzzzzzzzzzzzzzzzzz help me asap Most people on this forum are unwilling to do your course work for you. What they are willing to do is to help you answer specific questions you have about some code. If you don't understand the question I suggest talking to who ever is giving the course. He or she should be able to explain in greater detail what is expected. ...Show All

• Visual Studio VSS Strategy

  Hi, I would like to request for some advise. I need to maintain source code in the following environment: development testing production Is there any best practise/well defined strategy that I can learn from ie, should these 3 environments exist with 1 database within the VSS or as 3 separate databases Currently, I am using VSS 6.0 Thank you Danny. You should create them as branches from the start. That is, create just one project called $/Development. Branch it to $/Testing, then branch that to $/Production. When it's time to promote code, use the Merge Branches feature. If you can find Doug Neumann's presentation from TechEd 2005 (google is failing me at the moment), yo ...Show All

• Visual Studio 2008 (Pre-release) XBAP and default browser

  Hi, I got the following problem since I uninstalled the February CTP and installed the May CTP instead: When I press Ctrl-F5 in Visual Studio for a XBAP application, Firefox is started instead of IE. Since Firefox doesn't understand XBAP, I cannot run or debug the application as easily as before. I know how to change the default browser for a HTML application, but I didn't find such a setting for XBAP applications. Any hint welcomed! Greetings, Laurent WPF hosting code does not launch IE, it opens WPF content with the registered handler for HTML. The easiest way to make a given browser the default HTML handler is to launch that browser yourself. If it isn't the default HTML handler, the browser will ask you if you want to make it ...Show All