Search results for query: *

Dilettante, you hit the nail on the head. I had tried putting double quotes around the extended properties but that generated a syntax error (expected end of statement) and it never occurred to me to that I needed to double up on the double quotes. I find your example with the single quotes more...

I am having a problem using ADO open an Excel spreadsheet. If I add the extended property parameter "HDR=NO" I get an "Error Number:-2147467259, Could not find installable ISAM." message. If I leave it off the connection succeeds but I lose the first row because there is no header row in the...

We receive a number of similar but slightly different files from our vendors that need to be massaged into a common format for transmission to yet another vendor for processing. My predecessor wrote a new VB6 program each time a new input file format was encountered, with the expected...

George and John, Thank you both very much for the help. Stars to you both :) Brad

I built a query against a SQL server to pull information about accounts that have multiple records in 2008. Now I need to isolate the accounts where those multiple records fall within five days of eachother. I'm no database programmer. I think I should be able to do something with DateAdd to...

Over the years that we have been using Domino many databases and mail files have been created with varying amounts of attention paid to making sure that all the proper entities are in the ACLs (LocalDomainServers, Administrators, etc.). I'm trying to correct that. I know that I can select all...

Thanks to both of you for your replies. Calculating all the file names and testing them, rejecting the names that don't exist is perfect.

I am trying to automate processing files from a list, created by another program, of pertinent files in a directory full of mainly irrellavant files. My program has a main loop that does the actual work. This is inside a loop that reads each file name from the list and passes it in to the main...

I chose option #1. The tran logs are backed up multiple times throughout the day so in that sense they are always backed up before the optimization job runs and clearly it wasn't helping. The optimization job completed successfully last night. I've set the recovery model back to Full. Now...

The recovery mode is Full. Other jobs that are set up for this database are an integrity check, which runs before the optimization, a database backup that runs after the optimization, and a series of tran log backups set to run every 3 hours from 7:00 AM to 11:00 PM.

I have an optimization job on a SQL 2000 server on Windows Server 2003 that continually fails with the message: [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 9002: [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'wfcdb' is full. Back up the transaction log for the...

We are using Arcserve 12.5 and just replaced our 60 slot, 4 drive AIT-3 library with a 4 drive, 44 slot LTO4 library. Is there any way that I can either assign jobs to particular drives or associate particular drives with slot groups? I would like to minimize tape use by keeping the jobs from...

I just rethought the problem. Please forget about the red herring of dual monitors. My real question is if I can change the screen coordinates that Windows opens new windows at. Any help on this would be hugely appreciated. Picture a corporate food chain with me as the littlest fish :)

I am putting together an interactive video customer assistance kiosk system. I'm using two monitors. One is customer-facing where the customer can see a webcam image of the remote support technician and the other, where the remotely located tech can open manuals, documents, and so on out of the...

I too had this problem. It turned out that one of the needed runtime files, PG32CONV.DLL, was being installed in the application directory. It needs to be in the system directory, C:\Windows or C:\Winnt\System32 as the case may be. You'll have to set this when you build your installation...