Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: SHardy
  • Order by date
  1. SHardy

    How do I code this BAT into VBS?

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

    How do I code this BAT into VBS?

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

    How do I code this BAT into VBS?

    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%...
  4. SHardy

    How do I code this BAT into VBS?

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

    Acessing User Folders via Batch File

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

    Acessing User Folders via Batch File

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

    Bus Obj 6.5 - Saving to Excel - Long Cells

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

    SQL Server 2000 - Active Directory Migration

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

    Bus Obj 6.5 - Saving to Excel - Long Cells

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

    Bus Obj 6.5 - Saving to Excel - Long Cells

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

    SQL Server 2000 - Active Directory Migration

    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)...
  12. SHardy

    "IF EXISTS..." against remote database

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

    "IF EXISTS..." against remote database

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

    "IF EXISTS..." against remote database

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

    USB 2.0 Problems - XP Home SP1

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

    USB 2.0 Problems - XP Home SP1

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

    USB 2.0 Problems - XP Home SP1

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

    USB 2.0 Problems - XP Home SP1

    I have tried that. Although I did not do it in safe mode. Would this be necessary? Where could I find updated drivers for the motherboard?
  19. SHardy

    USB 2.0 Problems - XP Home SP1

    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!
  20. SHardy

    USB 2.0 Problems - XP Home SP1

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

Part and Inventory Search

Back
Top