Thomas Cunningham's Q&A profile

• SQL Server SQL Server 2005 Log Shipping Query

  Hi, I have setup Log Shipping with SQL Server 2005 for my company's PRD database. Everything works fine till 6:30 AM of the next morning. At 6:30 AM the Log Shipping job fails with the error (*** Error: BACKUP LOG cannot be performed because there is no current database backup). Does this mean that I have to configure the job for doing full database backup daily in morning followed by Log Shipping process. Please clarify. I am using the Transaction Log Shipping tool in SQL Management Studio to configure Log Shipping. I did not find an option to backup the full database daily in there. The Log shipping process backs up the full database only once in the beginning. Also why the jobs fails exactly at 6:30AM daily. Any particul ...Show All

• SQL Server Dts Package foreach loop container and Excel connection manager

  How can I use a foreach loop container with an Excel connection manager. It is virtually impossible to configure the ConectionString property through expressions builder. Everything works fine with a Flat File connection manager but when it comes to Excel, I get the following error message: Error 1 Validation error. Extract Four: Extract Four [1]: The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. Tarification.dtsx 0 0 Please ! Heeeelp ! tel me how I can loop through Excel files ! Rafael, I have now used the expression builder to configure the FilePath property .... and this results in both: A ConnectionString prope ...Show All

• Visual Studio IVsHierarchy item path

  Hello All, Could any of you please explain to me how to get the path of an IVsHierarchy item I am traversing through a solution and I want to get the path of some files within the solution. I need to use IVsHierarchy because some of the projects are unmanaged (Database project). Any information you can provide would be great. Thanks. Do a QueryInterface on the hierarchy in order to get a pointer to the IVsProject interface and then call the following method: HRESULT IVsProject:: GetMkDocument ( [in] VSITEMID itemid, [out] BSTR *pbstrMkDocument ); Thanks, Ole ...Show All

• Visual C++ unresolved external symbol __RTC_CheckEsp and others

  Hello, I am trying to complile and link a bunch of code which makes use of the setupapi.h and hdisdi.h, defined as "extern C". I need the Win DDK, which are correctly installed together with Visual C++ 2005 Express Edition. I am underlining those includes because they caused many link errors. Only after reading previous answers, I reduced their number but am not able to fix the last 3 :-( The linker errors I still get are: DisplayUSB.obj : error LNK2019: unresolved external symbol __RTC_CheckEsp referenced in function _main DisplayUSB.obj : error LNK2001: unresolved external symbol __RTC_Shutdown DisplayUSB.obj : error LNK2001: unresolved external symbol __RTC_InitBase .\Debug/DisplayUSB.exe : fatal err ...Show All

• Visual C++ Arrays of Strings

  Hi folks, I'm writing a .NET Winforms project in Managed C++ using Visual Studio 2003 and I'm wondering how I go about having multi-dimensional arrays for String objects I'm vaguely aware of the Array Class, but I'm not sure if this needs to be part of my solution. I've tried a few experiments using the classic C++ method of creating multidimensional arrays, but (of course) this does not work owing to the managed restrictions of the language. In any case, I just need a little direction here - do I need the Array class or is the syntax for this a bit different than what you might expect -Zero einaros wrote: array<String^, 2>^ myStringArray = gcnew array<String^, 2>(y,x); ...Show All

• Smart Device Development WSAGetLasError() = 120

  Hello everyone. I'm trying make my first program using bluetooth in Visual Studio 2005 for SmartDevices. Well, I'm following the example msdn http://msdn.microsoft.com/library/default.asp url=/library/en-us/wcecomm5/html/wce50concreatingconnectionusingwinsockextensions.asp, but when I run my application this show me a error a moment create socket, in other words, the function WSAGetLastError return a error, but the value es 120. I did reviewed, again, MSDN Library and I don't find any code error with this value. I show you a part my code: Headers: #include <windows.h> #include <winsock2.h> #include <bt_api.h> ... void CWhateverDlg::OnBnClickedButton2() { // TODO: Add your control notification handler code here WSADAT ...Show All

• SQL Server process analysis server objects from web via ASP.NET + C#

  Hi! We are running several Analysis Services Cubes on a Database Server (SQL 2005) machine. Another machine is our web server (IIS, ASPX) which displays cube content and allows drill down to several levels. Everything works fine and we are looking forward to optimizing the whole data management process. At the moment we try to develop DTS packeges (SQL 2005). Is it possible to initiate a cube processing (without DTS in the background) from eg an administration section in the web page TIA and kind regards from Vienna JohnnyR The control used in the browser is the Office Web Components 11.0 PivotTable control. You can use this control in your asp.net app by referencing this contr ...Show All

• SQL Server Cant get Reports Server page to work

  hi I have sql 2005 Standard on WinXP and i cant get http://localhost/ReportServer to work. I get the web page error Server Application Error The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more detail information. Please contact the server administrator for assistance. I have re-installed sql 2005, reinstalled IIS . I have run the aspnet_regiis -i and still nothing. Please someone, anyone , help. This seems more like an IIS issue. How about trying to recreate the default web site If you deploy an ASP.NET app on the default website, does it work If you reinstall SQL and IIS, make sure you install IIS before SQL. ...Show All

• Visual Studio Purchasing Visual Studio 6.0

  Visual Studio 6.0 is no longer available on my MSDN Universal subscription. Is there any way to get a legal copy of it via a MSDN subscription or being able purchase it separately Don't ask me why I need it... ;) you can also try ebay or other software vendors... you can also try software vendors ,microsoft site. ...Show All

• SQL Server check version of sql 2005

  how do i check whether i have installed 64 bit /32 bit sql server 2005... if i see Program files and Program files (x86) directory can i be sure... one more query..Is windows 2003 enterprise edition 64 bit Itanium based operating systems Thanks in advance Is there a mapping table available between @@version string and the SQL Server 2005 For example, SQL Server 2005 RTM x86 (32-bit) Enterprise Edition --> @@version= SQL Server 2005 RTM x64 (32-bit) Enterprise Edition --> @@version = SQL Server 2005 RTM IA64 (64-bit) Enterprise Edition -->@@version= SQL Server 2005 with SP1 (32-bit) --> @@version= etc, etc. I am particularly interested in the build num ...Show All

• Microsoft ISV Community Center Forums How to re-connect an Excel.Application variable to a disconnected Excel instance?

  Hi, Automating Excel is wonderfull. I program it quite offen and I quite enjoy it. I have a question: When a program with new a Excel.Application is broken and stopped, the created Excel instance will be deattached to any VBA variable. In this case, I need to be "End Process" manually in the window task manager. I do this more than 50 times in one day of programming. Without doing this, I once had found more than 20 Excel instances in the task manager. It is terrible. I tried following, the program broken at J=27 in my 1Gbyte RAM notebook. Dim J As Byte, mExcel(1 To 50) As Excel.Application For J = 1 To 50 Debug.Print J; Set mExcel(J) = New Excel.Application Next Stop My question is how can I scan all curre ...Show All

• Visual Basic combobox selecting value

  in my application on a form i have kept a combobox in which there are 50 items bounded to it my requirement is to display a tool tip when selecting different items in the combobox drop down list combo box selecting value Rajesh batchu, Try the following code: ' Search a control's ItemData property for the ' indicated ID. If found select the item. Public Sub SelectItemData( ByVal ctl As Control, ByVal Id As Integer ) Dim nCnt As Long If TypeName(ctl) = "ComboBox" Or TypeName(ctl) = _ "ListBox" Then For nCnt = 0 To ctl.ListCount - 1 If ctl.ItemData(nCnt) = Id Then ctl.ListIndex = nCnt ...Show All

• Visual Basic use radio button group to display a database field value

  I am working on a Forms project storing data in an Access Database, and for several fields I would like to use Radio Button Groups to have the user select from limited options. I can link the groups on the form to the fields in the database, but they appear blank when the record comes up instead of showing a checked state to indicate the value held in the field. I can put a text box on the form and use code to decide which radio button should be checked based on its value, and vice versa for which value to store for a new record, but is there an easier way Given so many other easy ways to do things with the program, i think I must be missing something. Thanks Thanks for the suggestion, and a Combo B ...Show All

• Visual Basic A background process to detect user activity / How to get VB.NET to use a C# class?

  Hello all, I have a multi-form application that is running fine, but now I would like to add code that would revert the application to its startup form if there is no user activity (mouse or keyboard). I have 27 forms in my application, and instead of going into each form indiviudually and adding a timer, I was wondering if there were a method to simply have a separate application (or hidden form in the same application) that would detect mouse and keyboard activity running in the background much like the method that your Windows screen saver uses to detect whether there is activity or not before showing the screen saver. I have looked into keyboard and mouse hooks but ran into a dead end; if I understand the documentation directl ...Show All

• Software Development for Windows Vista 16-bit Application Icons Missing

  Hi, I'm currently testing some of our 16-bit applications on the 32-bit Windows VISTA Business edition. One thing I've noticed is that the icons for the main executables do not display under VISTA. Instead, they display a default icon. Anyone know why this is Thanks in advance for any help. JK Got any more information about this issue yet I am making a 16-bit application compatible with Windows Vista and the icons issue is the last one we have. We have found three places where the icon isn't correctly displayed: the desktop shortcut, taskbar and application switch (alt+tab) display. The first two can be solved by assigning an icon to the desktop shortcut but the alt+tab menu appears to use the application ...Show All