Recent content by chriscboy

Thanks for your answer. I have looked into this but unfortunately didn't help as the test CLR Assembly I have created does not have external_access or unsafe permission set, and I am still getting the error.

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...

Thanks for your reply. In my original example how would I change it to make myprop1 and myprop2 protected properties?

Maybe I misused the word "private". What I am talking about is having a property of a parent class that can be seen within the subclasses but not be publicly available. In other laguages I have seen this such as Visual FoxPro (known as a protected property) and C# (using the protected access...

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 Olaf, Thanks for your reply. After further investigation I have found the issue. The records I was trying to insert into the VFP table, already existed as deleted records. I packed the VFP table, and now it is all working correctly.

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...

Thanks for your answers. I think I have given our Marketing Manager some food for thought!!

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...

Thanks for your answers. Fee You raise a good point about employees becoming disgruntled so I will have to tread carefully there. kmcferrin The employees are not 100% home based so we can take that approach. Issues with the broadband support was quite high for us but most issues where router...

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...

Right problem found. It turns out it was a permissions issue as when I was calling the DLL from the ASP page I was running under the IUSR account, whereas when I was calling the DLL from a VFP program/VBA Macro I would have been under my Admin account. Giving the IUSR account read rights to the...