Search results for query: *

Before you have a go at me... I inherited this procedure from my predecessor. I agree it needs re-compiling big time but with the amount that it does this is by no means a small process. My general question is if anybody has come across issues running a SQL Server 7 compiled procedure from...

Thanks for everybody's post as they did help. I was planning on doing a format so I did this on Sunday. Initially I had the same problems but on the Router there is a 'Registration' button and this didn't seem to make any difference at first. So I disabled the Local Area Connection and tried...

Without going into to much detail I am wondering if anybody has come across any issues running Stored Procedures compiled in SQL Server 7 via another PC which has SQL Server 2000 tools. The database being used is a SQL Server 7 database by the way. I have a problem that when running a procedure...

Unfortunatley I am now at work and cannot test your theory. I see your point, but the support at Speedtouch told me before that I have to input this WEP Key. This is standard encryption, I can't see where I can disable this ? Also manually inputting an IP address didn't work as I was still...

Disabling the LAN connection didn't do anything ? I'm at the same point as before.

Ok now I follow... there is no encryption setup. The only username and password specified is for my Tiscali broadband access. I will disable the LAN connection and see what happens. I also have a connection for 1394 Net Adapter, shall I disable this as well ?

I know that's my problem but I really don't know how to resolve it as I've tried everything to my knowledge. When you say disable encryption, like what ? Do you mean the WEP key ? Please explain. I have tried entering an accepted IP address e.g. 10.0.0.3 and the gateway of 10.0.0.138 but still...

Operating System: Windows XP SP1 Modem: SpeedTouch 570 Problem: The wireless PC card I have purchased for my laptop will not register with my router (Speedtouch 570). I have removed all software, drivers and hardware and have re-installed. I have even formatted my hard disk but still cannot...

Ok, I thought it would be best if I post a final conclusion to this... In order for this function to work IE needs to be > v4. The standard in NT Terminal Services 4 is 4. I logged a Support Call with Microsoft to fix this and they provided me instructions and that I had to install Active...

The problem is that getting an updated version of this dll is not so easy. I have found that IE5 does not upgrade shell32.dll. Only IE4 with the"active desktop update" updates shell32.dll to either version 4.71 (IE4.0) or 4.72 (IE4.01). Win98 comes with version 4.72. Win2K will ship with...

I don't think I can upgrade it ?? Looking at the info stated here http://msdn.microsoft.com/library/default.asp?url=/library/en-us/shellcc/platform/shell/programmersguide/versions.asp Note 3: Version 5.80 of Comctl32.dll and version 5.0 of Shlwapi.dll are distributed with Internet Explorer 5...

OK I have version 4.00 how do I go about getting a version greater than 4.71. I shouldn't copy the dll from my XP machine should I ?

I have found out more information in regards to this.... It seems to be failing on the syntax CreateObject("Shell.Application"). And it is only happening on NT, the problem does not occur on XP. Is anybody familiar with this ?

That link doesn't work... This looks like the post that will help me http://support.microsoft.com/default.aspx?scid=kb;EN-US;247979 And I have now managed to re-produce the issue on the NT server, I unregistered the scrrun.dll and I now get the error when my app attempts to open the folder...

We have installed a VB application on separate machine and registered the associated dll's and ocx's but for some reason when running an export from within the app we get this 'ActiveX component can't create object error no 429'. There are a number of posts but nothing has worked so far. 1) I...

In my application I have a Data Entry grid which consists of 4 checkboxes, when tabbing through these checkboxes it automatically checks these. I don't want this to happen, I only want these to be checked if they are left-clicked on by the mouse. I have been trying to capture for this but am...

In regards to Indexes, how could I tell ? And if it was lost would it have been re-created automatically by SQL Server ? The reason I ask the second question is that the job went back to normal after.

I have a job setup on SQL Server which basically runs a very big stored procedure. This normally takes 2-3 mins to complete but over a certain period it was taking 20 minutes. I have two backups of data (one when the procedure was only taking 2-3 mins, the other where it was taking 20 mins). I...

Ok I see your point, I'm investigating a job which normally takes 2 mins to run (hence the schedule is every 5 mins). Why it has taken 9 mins on my local environment I do not know... don't worry about this as it's not the point of the issue. (I shouldn't have mentioned it as I can see your...

I have come across something very strange and is not helping with my investigation of an issue. I have a stored procedure and when I run it via an exec statement from Query Analyzer it takes 18 mins to complete. I restored the database to how it was before this procedure was run but this time...