Recent content by SHardy

Ok, I got to the bottom of that one. BAT files & VBScripts have opposing ideas about when yuo do or don't need a "\" in a path. The following is my final code, and it works a treat. Many thanks for all your help. Simon Final code: 'Update local files & settings to redirect Business Objects...

Hi, Thanks for the help. It's now recognising the path correctly. However, it does not seem to be using the wild card for the delete (*.lsi). The files are not being deleted. It is overwriting over one of them with the file copy, but the others are still there. Have I used the correct method...

OK, thanks for this. I have made an attempt at scripting the whole thing in VBScript. However, I get a runtime error as follows: Line: 19 Char: 1 Error: File not found Code: 800A0035 Source: Microsoft VBScript runtime error I am assuming that this is because I cannot use the %USERPROFILE%...

Hi, I am in the process of setting up a new Business Objects repository, as a replacement for the existing one. This needs to be rolled out to all of our Business Objects users as transparently, and as smoothly, as possible. I started writing a script to update all the necessary files on each...

It's OK. I have it now. %USERPROFILE% returns (for me) "C:\Documents and Settings\Shardy". I will now simply incorporate this into my script.

Hi, We have recently migrated from NT domain to Active Directory. At the same time everyone's network user IDs have changed. For example: - my old login = SHardy - my new login = BRO_SHA Now, windows appears to have remembered the association of my old ID. So (for example) instead of...

Row height 409 points" "Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar." Just over 2,000 characters hardly makes a dent. However, as I said in my last post, I was a bit hasty in assuming that the cell length was the cause...

Do not know the full details. I will have to check with the Ops people (I am just a developer, and a newbie at that!). However, I believe that they will be setting up a new domain. It is part of a process to fit in with our parent company. This affecting ALL naming conventions so that they...

OK, ignore this post. There IS still a problem, but it seems impossible to pinpoint it. It is not down to text length. I tried performing a SUBSTR on the field in question. Gradually changing the parameters. Eventually, with SUNSTR(1,1314) I got no error from the saved Excel file. However...

Hi, One of our users has been having trouble saving a Business Objects 6.5 report to Excel. When refreshing and saving the report, the following is returned when trying to open the Excel file: "Microsoft Office Excel File Repair Log Errors were detected in file 'C:\ReportName.xls' The...

We are shortly going to be migrating from NT domain to Active Directory. We are running Windows Server 2003 & SQL Server 2000. Most of our SQL Server applications are using Windows authentication/ passthrough. However, I believe that we may use some SQL authentication (at a sys admin level)...

The SELECT * FROM [remoteserver].[dbname].dbo.[sysobjects] WHERE [name] = (N'tablename') does NOT return any rows. Therefore the IF EXISTS should return FALSE and skip the INSERT INTO. I have also tried adding BEGIN/END and I have tried using OPENQUERY. Neither made any difference. If I run...

What would be the expected effect of adding?: AND xtype = 'U' I'm guessing that this simply limits the IF EXIST clause to return TRUE for user tables. This made no difference to me. A user table could still exist in the TEST sysyem and not in the LIVE system. Also, permissions are definitely...

Hi, I was trying to perform a one of task to gather information from LOADS of tables from two different SQL Server 2000 DBs. They are both similar, but one is the backend of a LIVE system, the other is the backend of a TEST system. As such, there are likely to be several structural differences...

I think I am going to give up on this as a bad card. It would appear that they made this card with two different chipsets - VIA & ALi. From what I have found it sounds like all the VIA ones worked fine with no problems. However, it also sounds like all the ALi cards have had the same probblem...