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...
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...
Oh, also is there a difference between a BIOS update and updated chipset drivers?
I visited the M/B manufacturers webset and all I could find was new BIOS. Which incidentally was an Award BIOS rather than AMIBIOS!?!
Not sure if I'm keen on flashing the BIOS. Although if it was almost certain...
Okay...
I removed the PCI USB 2.0 card.
Restarted PC & un-installed the related USB drivers (both 1.1 & 2.0).
Shut down & re-installed PCI card into a different slot.
Re-started PC.
XP then auto detected & installed card, USB1.1 controllers & Standard EHCI controller.
Still when I plug in card...
Have tried that. Infact there's two different setups for host controller and I have tried each. There's also an enhanced controller setup, and I have tried using that. Nothing.
Also, reading the guide that came with it, it actually just says to install SP1 and use the MS EHCI drivers.
I'm stumped!
Hi,
I am having problems with a USB 2.0 Card installed in XP machine. Technical details as follows:
O/S: XP Home SP1 (build 2600)
Motherboard: MSI MS-6558 1.0 (SiS Chipset)
Onboard USB 1.1 Controller: SiS 7001 PCI to USB Open Host Controller
PCI USB 2.0 Card/Controller: ALi PCI to USB Open...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.