Hummer's Q&A profile

• SQL Server Writing MDF to SQL Database

  Hi, I've been searching the internet for hours and the code i'm finding is just not what i'm wanting to do. Heres the story, I have a database file "MyDatabaseFile.mdf" I am making a form when you click a button I want it to create the "MyDatabaseFile.mdf" in MS SQL Server. Is this possible if so how I it something like "CREATE DATABASE MYNAME ". I jsut want the MDF file i dont want the log file inserting or anything. Is there any tools out there that anybody can recommend that will help me with T-SQL   Cheers, Rob There are several ways, you can fire a sql statement using a sqlcommand against SQL Server, or use the SMO / DMO classes (preferable the SMO classes, as they are written in .NET) to create a datab ...Show All

• SQL Server Importing Access table into SQL Server 2005 Express table and adding one field

  Hi all, Hopefully I am posting this question in the correct forum. I am still learning about SQL 2005. Here is my issue. I have an access db that I archive weekly into and SQL server table. I have used the dst wizard to create an import job and initally that worked fine. field I have as the primary key in the access db cannot be the primary key in the sql table since I archive weekly and that primary key field will be imported several time over. I overcame this initally by not having a primary key in the sql table. This table is strictly for reference. However, now I need to setup a unique field for each of the records in the sql table. What I have done so far is create a recordID field in the sql table that is an int and set as yes to ...Show All

• Windows Forms How to navigate between muliple screens?

  Hi, I am trying to create an winforms (v2.0) application and I need to use multiple screens. I am not sure how to create multiple screens that become visible/invisible when users click different menu items on the menu strip. 1)Should I use form inheritance for this How do I embed one form in another I can only get it to pop up a new form. I need to embed one for in another... 2) Should I use a panel to group the screen controls on and then make the panel visible and invisible depending on what menu item the user selects None of the above things have worked for me. Thanks David Hi David, I think I'm missing something - does every form need to be shown within your main application form Or can they be sepa ...Show All

• Visual Studio Tools for Office Excel: The customization does not have the required permissions to execute

  getting this error: The customization does not have the required permissions to execute. ************** Exception Text ************** System.Security.SecurityException: The customization does not have the required permissions to execute. at Microsoft.VisualStudio.Tools.Applications.Runtime.AppDomainManagerInternal.HandleOnlineOffline(Exception e, String basePath, String filePath) at Does Temporary Internet Files qualify as a Trusted Zone I ask because users often open the XLS file from outlook by double-clicking the attachment. in that case it opens them from the IE Cache. Is there a way to check what are the security restrictions on that The user workstation has this type of security policy change run. It enables me to open ...Show All

• Visual C++ GetProcAddress doesnt find the function in my dll

  Hi all! I've just started dealing with dll-s for two days, but I got stucked and dont see how to move on..so to make my first steps, with some searching I created a Test.dll with a function fnTest() in it. Exactly it's prototype in the header file looks like the following: __declspec(dllexport) int fnTest(void); If I'm using implicit linking it's ok. The trouble is on when I try to link it explicitly. HINSTANCE Testdll; Testdll = LoadLibrary("Test.dll"); They are still good, it finds the Test.dll, but the GetProcAddress returns with NULL, although it should work..(The dll is correct, it worked while linking implicitly): fnTestptr importaltfnTest; importaltfnTest = (fnTestptr)GetProcAddress(Testdll,"fnTes ...Show All

• SQL Server SQL EXpress ADV. Services Full Text Search

  I have seenfound several posts about Full text Search and looked at the BOL but havn't found a simple how-to. If anyone could point me to or post instructions on configuring Full Text Search in SQL Express W/ Adv Services it would be great. So far I have completed the following: Created my database using SQL Expr w/ Adv Services. Database is monted in a SQL server instance not a user instance. In SMSE under database>properties>files checked the box "Use full-text indexing". What now. I have seen posts referncing using the template explorer in SMSE and the Full Text Index templates. I see four templates in my template explorer related to FTS . Create Full-text Catalog Create Full-text Index Start Full Population Stop Popul ...Show All

• Visual Studio Team System Where are log files stored when running a load test

  Hi all, I want to know where the log files are stored when we run a loadtest , as this is important for knowing test data. thanks in advance sridhar ...Show All

• SQL Server How to create a DTS package in 2005

  I am 100% new to SQL. I have used Access for ever. I need to know how to take a Access 2003 database and covert it over to SQL 2005. I have no idea how to complete this. I was told to do a DTS package but I do not see any options for this. Any help would be great! Thank you hi,      DTS is now known as SSIS pacakage      you can create a new database in sql management studio      after creating a new database. you can right click the database      and then  click on task. then clcik import data.       choose microsoft access as a data source.     &nb ...Show All

• Gadgets Sidebar gadget and IE interaction

  I'm having this problem between the sidebar gadget and IE: For example when I log in on YouTube with IE it reminds me logged in but when I try to access YouTube from my sidebar gadget I'm not logged in any more. But if I debug the gadget on the IE it works. Does anyone know why is this happening and how to solve Simplified, what I want to do is log in on IE and use this "login" on my sidebar gadget. Is this possible Andy thanks for the answer. I'm login on IE and then I send a GET request from the gadget, but I debug a little more and found that the problem occurs not only in the sidebar but in IE7 on Windows Vista too. The weird thing is that it works fine when I test it on IE7 on Windows XP, ...Show All

• Visual Studio Tools for Office how to add text in excel file using vb.net

  can anyone tell me that how i can add text in Excel file using vb.net. i am trying to using the following method. Dim folder As DirectoryInfo Dim file As FileInfo Dim i As Integer = 1 folder = New DirectoryInfo(path) For Each file In folder.GetFiles() ObjWSheet.Range("A1").Value = file.Name.ToString() = "my text" i += 1 Next This forum isn't exactly the right place to ask questions about Office automation, but I can, I hope, give you a quick tip to get you going. In the future, you should post such questions in http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.office.developer.automation&lang=en&cr=US When trying to automate Office ...Show All

• .NET Development Garbage Collector disposes wrong object?

  Application had been running for months without changes and without errors. Shortly after installing the June 2006 Microsoft patch, began receiving reports that application would display the message "Failed to load resource from resource file" and crash. Since then, I have been able to replicate the errors on 6 separate, differently configured systems. CONFIGURATION: Pentium III 800 MHz, 128 MB RAM, Windows 2000 SP4, .NET 1.4322 Pentium III 800 MHz, 256 MB RAM, Windows 2000 SP4, .NET 1.4322, Visual Studio 2003 Pentium III 700 MHz, 512 MB RAM, Windows 2000 SP4, .NET 1.4322 Pentium 4M 1.6 GHz, 1.0 GB RAM, Windows XP Pro SP2, .NET 1.4322, Office 2003 Pentium 4M 1.7 GHz, 1.0 GB RAM, Windows XP Pro SP2, .NET 1.4322, Office 2003 ...Show All

• Visual Studio Packages for Express Editions

  I have built the BasicPackage sample and it works great in Visual Studio both with the Experimental hive and full.  I exported the registry keys and tested it both ways and it works great. I then updated the .reg files  and altered them to write out to VCSExpress. VCSExpress is failing to load these giving the infamous "Package Load Failure" message. - I know the dll is registered correctly (it didn't move between the tests) - I know the registry entires are valid (only the base key I write to changed) - I ran "vscexpress.exe /setup" but it returns immediately, unlike devenv.exe - I ran "vscexpress.exe /log" yet it appears to do nothing, unlike devenv.exe   I understand that most of the extensiblity ...Show All

• Windows Forms MSI installer issue (Soz if this is the wrong place)

  I have VS 2005 SP1 for vista beta. I don't have experience making MSI files, so sorry. I can't find the option int he menus/property pages to change the name on the setup file. As in the setup is named "Setup1" and installs to the application folder DefaultCompanyName\. Where are these settings I really tried to look everywhere I could think of. Cheers. hehe yeah. I was working at about 3:30/4am and I wasn't quite thinking straight at the time. Plus I have the vista version of 2005 and the properties box wasn't showing properly. I found it, but thank you anyway for answering my question. ...Show All

• Visual Studio Team System Where are the virtual server images?

  This is the site I go to http://msdn.microsoft.com/vstudio/products/trial/ this is what is says. Visual Studio 2005 Virtual Images <- this links to http://msdn.microsoft.com/subscriptions/ MSDN Subscribers have access to a series of Virtual Images containing a fully functional installation of Windows Server 2003, SQL Server 2005, Visual Studio 2005 Team Suite, and Visual Studio 2005 Team Foundation Server. These Virtual Images are a benefit of your MSDN subscription and are available for download from the MSDN Subscriber download area. If you're not an MSDN Subscriber yet, learn more in our MSDN information center. Ok im a subscriber at premium level (corporate) and there is nothing there. Even w ...Show All

• Visual Studio Express Editions Sorting listView

  I am trying to sort a listview by it first colume, in number order. At the moment it is sorting to some extent, but it groups 1, 11, 12.... together. How can I make it just sort in number order Public Shared Sub AddtoListView( ByVal Num As String ) Dim CurrentHand As New ListViewItem(Num, 0) 'Hand CurrentHand.SubItems.Add(PreviousStake) 'Stake CurrentHand.SubItems.Add( "" ) 'Bet Type CurrentHand.SubItems.Add(PreviousPlayer) 'selection CurrentHand.SubItems.Add( "" ) 'Bet Refrence CurrentHand.SubItems.Add(Lasthandwonorloss) 'Result CurrentHand.SubItems.Add( "" ) 'Profit / Loss CurrentHand.SubItems.Add(PreviousRunningLoss) 'Running Loss C ...Show All