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 TouchToneTommy 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: *

  1. jbradleyharris

    ADO connection string for Excel

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

    "Expected procedure not variable" error when trying to call a procedure from a database lo

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

    Finding records that fall with a date range of eachother

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

    Bulk-edit the ACL of all databases on a server?

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

    Return to the top of a Do loop?

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

    Optimization job fails with 9002 after tran log fills up drive

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

    Assign particular drives to jobs or groups?

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

    Change default new window location

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

Part and Inventory Search

Back
Top