Eric Lohse's Q&A profile

• SQL Server Log Files getting TOOO big with Nightly Restore Database, Need help.

  Hi, I have a website that displays customer data inside an SQL (Version 8) database. Everynight I download the latest version of their back office database (another SQL database) and restore it as a temp DB. Then I selectively copy the tables I want, overwriting last nights version of the data. My problem is that my log file grows really big and really fast. I am using the DTS copy data feature to copy the tables between databases. I have tried the limit database option, but it just compalins that there isn't enough space to do the job. I would appreciate any help anyone could offer. Please help! Michael Use simple recover ...Show All

• Visual Studio Team System How to use actual Test (Unit, Web, Load) to profile my application?

  Hi, is there any way to use my existing VSTS Tests to profile my application (in order not to exercise the application manually) Thanks a lot. LucasC If you can launch your test on Command line, you can use our command line tools (VSPerfcmd for performance data collection, VSPerfReport for performance data analysis) to achieve automation. ...Show All

• Visual Basic Microsoft Visual Basic 2005 Express - New Project dialog is empty!?

  Look at this screenshot: http://hjem.get2net.dk/dondata/Empty.gif I have allready tried to Repair the installation, and allso completely uninstalled VB and the installed it again, but the dialog is still empty. What is happening here Comon! Am i really the first person i the world to experience this I still haven't solved the problem and I'm still standing here with an ampty dialog. ...Show All

• Visual Studio Team System Customization of MSF Agile?

  Has anyone been able to successfully customize the Process Guidance templates, incorporating attributes of your own software development lifecycle into MSF Agile This is become a critical problem for us, as we are trying to initiate a project using TFS, and would like to have the Process Guidance portal reflect how we really do things. I am looking for help from someone that has been able to either 1) modify the individual XML files (e.g. Roles.XML) or 2) modify the ProcessGuidance.XML file. I have had only mixed success in being able to add items like Tracks. And, some of my generated pages end up looking a "little different&q ...Show All

• .NET Development SOA code example

  Does anyone know of a good link with downloadable example code that discusses SOA and web services.  I've read several articles about wrapping messages within XML, but no code downloads. Thanks, Jake Hi Jake, The following example is quite a good resource to get started on SOA: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnvsent/html/FoodMovers0.asp frame=true Regards, Vikram ...Show All

• Visual Studio Tools for Office VBA for Powerpoint

  Hi, I have been asked to modify a powerpoint presentation so that from a series of jpg files, one appears on the screen and then after a specific time period disappears and is replaced by another; this being a continuous loop on one slide only - like a photo tour. I have the following code, but need to get it up and running. Any suggestions: Sub ImportABunch() Dim strTemp As String Dim strFileSpec As String Dim oSld As Slide Dim oPic As Shape strFileSpec = C:\PFS Pictures\beach party *.PNG 'Ex. on a PC: C:\My Pictures\Flowers\*.PNG strTemp = Dir(strFileSpec) Do While strTemp <> Set oSld = ActivePresentation.Slides. Add ppLa ...Show All

• SQL Server Collapsing Three Rows Into One with T-SQL Challange?

  Hello, I am wondering if someone has any good ideas how I could concatenate values in column 7:30- 9:50 so that I would have one row and a value: MTTHFW.  Or even if it is possible having this in logical days of a week order : MTWTHF. Thanks a lot for any help! Building       Time                               Room #    7:30- 9:50 Engeneering 7:30:00 AM - 9:50:00 AM   201         ...Show All

• Visual Studio push method

  I am trying to use crystal reports to generate a report from a dataset in visual C# 2005. Can someone tell me what I have to do to use the "push method" Sorry about the ignorance. ...Show All

• Smart Device Development NETCFSetupv2.exe

  I am having trouble installing NETCFSetupv2,exe to update a treo 700w to the .netcf 2.0. As the install is taking place, I get the error Application Manager can't install this application to your device due to an invalid setup file. I am not even sure if I need this installed on the new treo 700w I am only installing becuase I have tried to run an application I just wrote with MSVS 2005 and I get the error that this program needs a newer version of the .netcf Any help is appreciated Thanks Jon Stroh I dont know about the mobile device however please let me remind you that some mobile devices, including PPC devices, do no ...Show All

• Visual Studio 2008 (Pre-release) Timeout for wrong username or password

  Hi, In the example : WindowsCommunicationFoundation\TechnologySamples\Basic\Binding\WS\MessageSecurity\Username\CS For correct username and password all work fine, but if I inform a wrong username or password I receive a timeout exception. Why not "Security Exception" "The Http method invocation to http://localhost/servicemodelsamples/service.svc has exceeded the configured operation timeout." Thanks, Alexnaldo Santos Hi Alexnaldo, Thanks for reporting this problem, we fixed this bug in recent bits, I am not able to repro this problem with recent build -Thank yo ...Show All

• SQL Server question on AqcuireConnection

  Hi, I created a function that supposedly checks a connection manager if a connection can be established. When I was testing the code, I found out that the following code always returns "Successful" for flat files and SMTP connection even if the flat file does not even exist or there are no connection parameters for SMTP. Can you tell me what to use to check if a connection can be established for all types of connection managers Here is the function that I created which does not seem to work as I expected: Public Function connect(ByVal connMgr As Object) As String Dim connected As String Try Dts.Connection ...Show All

• .NET Development access data from a Deleted DataRow

  Hi! I have a DataRow marked as deleted. How can I get the data behind the row I tried to use Table.Select with several parameters but didn't succeed. I always get a System.Data.DeletedRowInaccessibleException when I try to do something like: pkID=myRow["pkID"] or in VB syntax... pkID=myRow("pkID") Is this working for you, change the indexex according to your desire DataGridViewRow r = this.dataGridView1.Rows[0]; MessageBox.Show(r.Cells[1].Value.ToString()); ...Show All

• SQL Server Where are the tools and documentation?

  Where are the tools and documentation I have sqlserver installed in beta2.  I've never before used sqlserver, only microsoft access. I see nothing that I would expect from sqlserver.  No graphical tools, like access, to help me design tables , queries and stored procedures.  No books online.  No tools to covert my access database to sqlserver. In programs start menu, there is only configuration manager, which tells a novice nothing, and one other tool that's even more obscure. I have the separate iso of the april ctp.  I'm told that's the version consistent with beta2.  Is that correct   Does it have al ...Show All

• Visual C# CallBack from a WIN 32 C++ dll

  Hello Everyone, My application is written under C#, but for some of the low level stuff I have to use C++ dll's and one of the dll require password before I can make some function call or if user entered wrong should ask again..... How can I implement something along those lines.... At first I can send the pasword, but if the password is wrong what is the way to get the password....If you want I can even post my procedure which asks for password..... Any help, suggestion highly appreciated... Thanks, Harsimrat I was thinking about this, can you outline exactly how you would like it to work ...Show All

• .NET Development ...encountered a type that derives from a generic class and is not marked as [ClassInterface(ClassInterfaceType.None)]

  I am getting this compiler warning in my project and it doesn't seem to make sense.  What am I doing wrong "Type library exporter warning processing 'B, myAssembly'. Warning: Type library exporter encountered a type that derives from a generic class and is not marked as [ClassInterface(ClassInterfaceType.None)]. Class interfaces cannot be exposed for such types. Consider marking the type with [ClassInterface(ClassInterfaceType.None)] and exposing an explicit interface as the default interface to COM using the ComDefaultInterface attribute." Well, class B derives from a generic class, List<C>... but it *IS* marked as [Cla ...Show All