...treat. Many thanks for all your help.
Simon
Final code:
'Update local files & settings to redirect Business Objects 6.5 to the new repository
'*** Create new System DSN required (BORep) ***
Dim oWshShell
Const cRegKey1 = "HKLM\Software\ODBC\ODBC.INI\BORep\"
Const cRegKey2 =...
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...
...= Nothing
2 - BAT file to delete and copy Bus Obj files:
REM Update local files to redirect Business Objects to the new repository
REM ** rename the old LSI files **
rename "%userprofile%\Application Data\Business Objects\Business Objects 6.0\lsi\*.lsi" *.old
REM ** copy the new shared...
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...
...into Query Analyzer. I then run the code from a local database.
This is in the following format for each table/field combo:
IF EXISTS (SELECT * FROM [remoteserver].[dbname].dbo.[sysobjects] WHERE [name] = (N'tablename'))
INSERT INTO SomeLocalTable (SomeField) SELECT [AnyField] AS...
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.