karnij7877's Q&A profile
SQL Server Error -2147024809 An error has occured on the computer running IIS
I am sync. for the first time (Merge Replication using SQL 2005 and Mobile) and this error keeps poping up on the emulator. I am tring out the tutorial. :) boss on my butt. Does anyone have any ideas or a solution to this...your help is WELL APPRECIATED ... Error code: -2147024809 zo The error codes from the runtime is as follows: Error Code: -2147024809 Message: An error has occured on the computer running IIS. Try restarting the IIS Server. (Tried several times) Minor Error: 28022 Source: Microsoft SQL Server 2005 Mobile Edition ...Show All
SQL Server Report Parameters creation via Code
Hi, I have a report that that needs to be filtered by StartDate, where StartDate is the first day in the week of a specific year. The values will be each week of the year (52 weeks = 52 Start Dates) and the range of years is between 2006 (current year) back to 2003. My questions is how to generate these values for the StartDate parameter. I don't want to define actual database tables to store these values, as it seems like something I should be able to easily generate via some code. After trying it out for while and searching the forum, I'm starting to think I will need to statically store these parameters. Can anyone offer any advice on how to solve this parameter value generation issue Thanks, - Jim ...Show All
SQL Server Stored procedure issue. a bridge too far for me
i have a query that i need to extend but just dont have the knowledge to do so, so hoping someone here could help me this is my current query:- SELECT ES.PatientID, DATEDIFF(day, EP.DateofBirth, GetDate())/365 AS Age, CASE EP.SexCode WHEN 'M' THEN 'MALE' ELSE 'FEMALE'END AS Gender, COUNT(H.HRDID)AS HRD, ES.FourRegularDrugs, isnull(ES.FourRegularDrugsNo,0) as NoOfDrugs, ES.ReadmissSixMonths, PCE.[Primary diagnosis] FROM tblStudyServices ES INNER JOIN tblPatient EP ON EP.PatientID = ES.PatientID INNER JOIN PAS.dbo.[PAS Patient Details] PP ON PP.[PAS key] = EP.PatientInternalNumber INNER JOIN PAS.dbo.[PAS Admission Details] [PAD] ON [PAD].[PAS key 1] = PP.[PAS key] INNER JOIN PAS.dbo.[PAS Consultant Episode] PCE ON PCE.[PAS key 1] = PA ...Show All
Visual Studio 2008 (Pre-release) How to add a gadget into sidebar
I have created a gadget of a running chart. I have installed vista on my machine and add that gadget into my side bar. It's running fine. But when I try torun this gadget on some other vista machine it's not working. It's displaying but you can't interact with it. I have done all the required setting. One more interesting thing is that when I access that machine remotely that gadget is working. What can be the problem. Any hint or link. Thanks, http://blogs.msdn.com/llobo/archive/2006/10/23/Vista-gadgets-using-WPF.aspx ...Show All
.NET Development Recursion in .NET
Hi, I have a tree and the bottom nodes have some value. I want each parent to have the sum of the value of each of their child. I want to know if I would see a gain in speed if I remove recursion and try to find a non recursive function to do the same job. CalcSum(top_nodes) Function CalcSum(ByVal nodes As NodeCollection) Dim n As Node Dim sum As Integer For Each n In Nodes &nb ...Show All
Windows Forms Problem referencing items in a different project in solution
I am creating an Outlook style application with email and contacts. I have my mainForm which is in its own project. The main form has a splitter. One on the left for the tree. And one on the right for a grid. In the Contacts project, my contacts tree is a user control, with a treeview added to it, and it has another user control with a grid added to it. In my main project, I add a reference to the contacts project. When my program starts up, it programatically adds my contactsTree control to the left side of the splitter, and my contactsGrid control to the right side of the splitter. And so on, for the email it adds the email controls etc. When a user chooses email, the email controls are set to Visible, and the rest of the controls are hi ...Show All
.NET Development Running/Debugging Web Service App causing unusual behaviours
I am at wits end trying to fix this problem. I have a small application that uses web services via a webservice.htc file that, at the time, was a pulling a an array of strings (~26,000 in length) back to the browser. Calling the asmx file worked correctly, but the browser was hanging. So I started to limit the length of the array to see when the browser started to lag, testing numerous times, to determine where to chop up the array in chunks. The last time I let the browser hang for several minutes and finally shut it down. I then rewrote the code and nothing functioned when I started to retest. I narrowed it down to the .htc file not initializing the proper objects, I don't get an error when it creates the service, but the web servi ...Show All
SQL Server Error trying to access the Report Manager
Hullo, When i try to access report manager i get the following error. Error The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help Get Online Help Bad Data. (Exception from HRESULT: 0x80090005) Could someone help me out Ronald Home Hi Ronald- Your report server cannot access it ...Show All
Visual Studio Express Editions Class Not Regsitered Error:
Hi All Wheni run the following code i am getting Class Not Registered Error. In have checked the registry , the JScript has an entry in the Registry. Please guide where am i making the mistake #include<ATLbase.h> #include<oleauto.h> #include "activscp.h" const GUID CLSID_JScript = {0xf414c260, 0x6ac0, 0x11cf, {0xb6, 0xd1, 0x00, 0xaa, 0x00, 0xbb, 0xbb, 0x58}}; const GUID CLSID_VBScript = {0xb54f3741, 0x5b07, 0x11cf, {0xa4, 0xb0, 0x00, 0xaa, 0x00, 0x4a, 0x55, 0xe8}}; int main() { USES_CONVERSION; CoInitialize(NULL); CLSID pclsid; LPCOLESTR progid = OLESTR("JScript"); HRESULT hr= CLSIDFromProgID(progid,&pclsid); CComPtr<IUnknown> pUnkOuter; CComPtr<IActiveScript> *pS; if(SUCCEEDED(h ...Show All
Windows Forms Programatically reading lines from multi-line textbox
Firstly, is this possible i.e. to read individualy lines of user text consecutively. If so, is there any way of knowing how many lines were originally written to the textbox via some index which I can find no reference to. It seems to me that you get either the whole blasted string or nothing. ...Show All
Internet Explorer Development IE7 and desktop icons
I just installed Internet Explorer 7 today, which I guess is a.k.a. Windows Live . All of my fancy customized shortcuts on the desktop disappeared and each got replaced by the same generic windows icon. Right-clicking & changing the icons in properties no longer works. Also, when I create an internet shortcut while browsing, that creates a shortcut with that same generic icon (not even an explorer logo). Now my desktop is just one forest of identical icons. Anyone know how I can fix this I've wasted all day without success. Yes... I did the same. Fortunately, the uninstaller is thorough, so everything returned to normal as soon as IE7 was gone. ...Show All
Windows Forms DrawToBitmap missing!
Hi I'm trying to use the DrawToBitmap function of a Panel to print it but it doesn't come up in the intellisense and it doesn't compile if I type it in manually. Anyone have any idea why Thanks in advance Pom. private : System::Void printDocument_PrintPage(System::Object * sender, System::Drawing::Printing::PrintPageEventArgs * e) { Graphics * g = e->Graphics; Bitmap * bp = new Bitmap( panel1->Width, panel1->Height ); panel1->DrawToBitmap( bp, this ->ClientRectangle ); } Thats it. Pretty straight forward so far. I get the following compiler error C2039: 'DrawToBitmap' : is not a member of 'System::Windows::Forms::Panel' ...Show All
Visual Studio ZipItem and ZipProject, Zip project contents at build time
I'm attempting to zip some contents of a project in order to create a Project Template (I've already created the template, I wish to rebuild it with each build). How can I use ZipItem and ZipProject, I cannot find documentation on their usage I've been looking at an IronPython example which generates Zip files using VSProject content with <Import Project="C:\Program Files\Visual Studio 2005 SDK\2006.07\VisualStudioIntegration\Tools\Build\Microsoft.VsSDK.targets" /> .... <ItemGroup> <ZipItem Include="Templates\ProjectItems\Entity\Entity.gmf" /> <ZipItem Include="Templates\ProjectItems\Entity\__TemplateIcon.ico" /> <ZipItem Include="Templates\ProjectItems\Entity\MyTempla ...Show All
SQL Server Need your advice
Hello guys! Just need your advice. Where can I get "advanced" information on RS I.e. not only how can I implement something "by right clicking", but something on queries, parameters passing, subreports. Something like "Reporting services inside" :). That's the first part of the post. One more question... I have next scenario: reports are deployed on RS. I need to display them in asp.net 1.0 pages. Currently I'm using IFrame - it works fine, but I have to pass some parameters (strings) to report, to display them there. I know one way how to implement it - in http querry string. But I don't like it - what if my parameters are too long for querry What if I don't wanna let users see some parameters Is there ...Show All
Visual Studio Express Editions Help Program will compile in Dev-c++ but not in VC++Express, simple class program.
#include <iostream> using namespace std; class myfirstclass { public: int number; void greeting(); }; void myfirstclass::greeting() { for(int i = 0; i<= number;i++) { cout<< "Hello World \n"; } } int main () { int keepRunning; myfirstclass myfirstobject; myfirstobject.number =3; myfirstobject.greeting(); cin >> keepRunning; return 0; } error i get 1>Linking... 1>classtest.obj : error LNK2028: unresolved token (0A000027) "public: virtual __thiscall std::logic_error::~logic_error(void)" ( 1logic_error@std@@$$FUAE@XZ) referenced in function "public: __thiscall std::invalid_argument::invalid_argument(class std::invalid_argument const &)" ( 0invalid_argument@std@@$ ...Show All
