Recent content by Stuartp

Thanks for your suggestion. To be honest Query Analyser hadn't occurred to me! I didn't say in the original post but I wasn't using an insert statement. I was using rs.addnew and rs.update in the code. I rewrite this to send an insert statement instead and that appears to be working...

Hi I have an SQL 2000 database being used by a classic ASP web site. I have a simple form on a page collecting data which has happily been entering data into the database for years. All of a sudden I am getting timeout messages on the web site even though nothing has been altered in the code...

Hi Send a link to this folder doesn't work on my Outlook either. The way I have always done this is to set up the sharing as you have done via the right click > sharing menu, and then on the other user's computer go Files > Open > Other User's Folder. That always works. I'm not sure though...

Excellent! This works fine. However it would seem that the MS bulletin has an error, as it states that this problem is corrected in ISA service pack 1. However we have service pack 2 and still had the problem. Still SP2 + the registry editor worked. It might just be worth mentioning hat...

We are using ISA Server 2000 to filter access to the Internet. By using Site and Content Rules in conjunction with Destination Sets we can control which users have access to the web, and can restrict most people to specific sites that we define. If a user tries to visit a non authorised site...

We use the Exchange Messenger facility under Exchange 2000. Until recently all was well, then a few days ago the contact lists stopped updating. Users are not notified when new users sign in and if a user goes away this is not reflected on all the other lists. The only way to update the list...

Think I may have solved the problem. Our ADSL router allowed access control over Telnet. I have disabled this and the port scan test now reports that port 23 is closed. So it must have been the router it was looking at and not the ISA Server.

Hi. Yes I have tried running the test also from a machine behind ISA Server and it still reports that Telnet port 23 is open.

I have just run the Shields Up (www.grc.com) test on our SBS2000 Server with ISA Server installed to see what ports were open. It reports that only port 23 Telnet is open. I've tried all sorts but cannot get this port to close. Packet Filtering is enabled. There are no web or server...

We backup through Veritas backup exec, although this particular database is not used now, it was set up as an experiment a couple of years ago. I have run the command in query analyser and it has worked a treat - I now have half of the server C drive free!! Many thanks for you help.# Stuart

The transaction log for one of our SQL Server databases is 4GB and I need to reduce it. I've used the MS knowledge base and it says to run code "DBCC SHRINKFILE(pubs_log, 2), replacing this with my own log file name and size. But it does not say HOW to run this, where to go to do it. Is this...

Hi. Thanks for the reply. I did check the recycle bin. I also tried, after I posted, using the Windows advanced find to see what had been modified in the last month. Turns out there is an sql database log amended a couple of days ago that is over 4GB. That would explain it! Now I just have...

The C drive on our Windows 2000 server has suddenly become full (i.e. about 7mb free). Not long ago there was over 200MB free. I have checked all the obvious things like temporary files, internet files, windows update files etc but they are already empty. None of the users store files on this...

Have found the answer to the problem. It was a coding error, it ought to say .formatType = crEFTPortableDocFormat For some reason Crystal reports this as a .dll issue.

I have written a program in VB6 which uses Crystal Reports 8.5 to export a report to a PDF. All works fine on my machine. I have installed on a Windows XP machine and the export function will not work. All I get is "Missing or out-of-date dll" I used the Package and Deployment Wizard and...