Search results for query: *

Hi, I am currently in the process of migrating our database server (which is Windows Server 2003 32-Bit, SQL2005) over to a VM environment which will be Windows 2008 R2 64-Bit, SQL 2005 64 Bit. One of the issues I am currently facing is that I am having difficulty with the database integration...

Hi, I am having problems with trying to understand how I can inherit private properties in subclasses. For example if I have the following : function MyClass() { var myprop1 = 1; // Private to MyClass var myprop2 = 2; // Private to MyClass this.mymethod1 = function () { return(1)...

Hi All, I'm fairly new to C#.NET and I have a question regarding when (and if) I should be releasing used objects in .NET. Below is a method that I have created that gets used in a CLR Assembly in SQL2005. Its a simple method that uses OLEDB to fire an SQL statement at a Visual FoxPro database...

Hi All, I am trying to do an overnight copy of some SQL2005 data into VFP7 tables. I have tried using SSIS but I am having no joy. I am using an OLE DB Destination to get the data into VFP but I keep getting the following error: [Insert Records [273]] Error: An OLE DB error has occurred...

Hi All, Our marketing department are investigating using some USB devices as marketing collateral. These "things" are basically a piece of folded card with product info on and inside is a USB key which you can pull out and plug into your PC or laptop. The USB key then launches a website which...

I work for an SME with about 70 employees. 30 of these employees have the facilities to work remotely and we currently supply and pay for their broadband connections, 9 of them use their own connections. This is double the number we were supplying four years ago and it is now becoming a support...

Hi, I have a written a C# assembly that I call from an SQL Server 2005 stored procedure. I have sucessfully added the assembly to SQL2005 and the code is working fine, however I am using a configuration file and it does not seem to pick up the changes I have made to the config file. I compiled...

Hi, I am trying to find out if I can prevent users from changing appointments that get created in Outlook from our CRM system. What I was looking to do is to write a plug-in using VSTO that would be installed onto our users PC's. The plug-in would fire an event when an appointment gets...

Hi All, I have an interesting/wierd problem with a DLL that was written using VFP7. In a nutshell the DLL I have written queries a VFP database and returns the results as an ADO recordset. This DLL is then used in a classic ASP page to display the results returned to our CRM system. Now all...

Hi, I am using Outlook Redemption to create a classic asp page that will create an appointment in someones Outlook calendar. I am getting the following error when running the code: Server object error 'ASP 0177 : 80040605' Server.CreateObject Failed /vCal/TestVCal.asp, line 123 80040605 The...

Hi All, We have recently upgraded our crystal reports and crystal report viewer to XI. I have a form class that contains the crystal viewer control. The form WindowType property is set to modeless. Whenever I run a report, I can switch to other windows, but for some reason can't use the...

Hi All, We have recently upgraded our crystal reports from using 8.5 and VFP ODBC connection to using XI and VFPOLEDB driver. We are using Visual Foxpro 7 SP1. Since the upgrade some reports run incredibly slower. I did some further investigation and it appears that it only occurs on reports...

Hi All, Is there a function that will return the decimal portion of a number in SQL Server? e.g. passing 123.45 would return 45 If there is what is it called, or do I have do something manual, like converting to a string and grabbing all chars after the decimal place? Thanks Chris

I have a view which has the following fields: SiteID, CompanyID, SiteAddress1, SiteAddress2 , SiteAddress3 ===== ========= ===== ========== ========== ========== 76724 , 1202 ,Devonshire Square , 3- 11 Devonshire Square, London 79007 ,1000 , A house, Somewhere, London 76724 ...

Hi, I am trying to create a stacked bar chart that will show the value of products sold YTD, compared to the target value of the products for the year. The data is laid out as below: Actual (£) Target (£) Actual %age sold Product1 3420000 3420000...

Hi, Our VFP7 database has been working fine for years. Yesterday I was doing some working using the admin function of our database (to allocate reports to users) and when I click on a tab on a form it generated the following error: "There is not enough memory to complete this operation." Now...

Hi All, I have a person in my team that has indicated an interest in web development. He currently does IT Support and crystal reports development. We are a small IT team of 4, and I could do with a person that has web development skills, to write some small web front ends (data entry) for...

Hi, The head of our dept has asked me whether we should allow our employees to have access to Facebook/YouTube/Myspace so that they can find out information about our customers / prospective customers. I personally think this is a bad idea as I believe these apps are productivity killers and...

Hi, I have written a class based on the session object that is used to access VFP and SQL Server data (using SPT). It works very well except when I want to access a results cursor returned from a SELECT statement. I need to get access to the datasession of the object in order to view the...

Hi, I am new to CR Server and am having problem with the installation. I am logged on as Administrator, but during the install I get the following errors when it is starting the services: error 1920. service 'event server' failed to start error 1920. service 'crystal reports job server' failed...