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!

  • Congratulations strongm 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. ISUTri

    Oracle 11i System Profile Question - Probably Simple

    I'm looking for what I think is a System Profile Option within Oracle Financials that will allow me to open Concurrent Program Define at the same time as Concurrent Program Executables so that I can copy and paste from one to the other. I can do this in our Dev. Environment but we recently...
  2. ISUTri

    Help with sed command

    That was it! The command line from feherke helped me get it working. I needed to put the s's that they highlighted in their code example along with that - in front of the last e. Thanks everyone!
  3. ISUTri

    Help with sed command

    I'm sorry I uploaded the wrong error message. With the information above it's not the -e error it's the following one. sed: -e expression #5, char 2: Unknown command: `<' The -e occurs if I comment out the -e's in the middle of the script. This is my code and I'm getting the unknown command...
  4. ISUTri

    Help with sed command

    Thanks for the tip. Now I'm getting a new error! Here's my revised code. sed -e 's/<SITEID>/Server\\\\FolderA\\\\FolderB\\\\/g' \ -e "s~<USERID>~$ftp_user~g" \ -e "s~<PASSWD>~$ftp_user_pass~g" \ -e "s~<INFILE>~$input_filename~g" \ -e "~<FILEDIR>~Lease~g" \ e "/<OUTFILE>/$new_file/g" <...
  5. ISUTri

    Help with sed command

    I am a newbie to Unix and sed so although I saw some posts that were similar to what I'm having problems with I couldn't get the suggestions to work with my problem. I am modifying a previously built .prog that has a sed command in it that builds an ftp command when the .prog is ran. My...
  6. ISUTri

    Payables Open Interface Problem

    I am using PLSQL to call the Payables Open Interface Program. Everything runs rather smoothly except for the fact that the Payables Import will only import 15 records at a time. After that it gives me the errors The account created with overlay is invalid and Invalid distribution account The...
  7. ISUTri

    Optionally Enclosed '&quot;' does not work for some reason

    Thanks for your responses I found a fix to my solution. I added "TERMINATED BY WHITESPACE" after the last column. I've posted my final control file below. OPTIONS (SKIP = 1) LOAD DATA INFILE '/VendorRepository/vendor/test.csv' REPLACE INTO TABLE xxhh_ap_suppliers_stg FIELDS TERMINATED BY ','...
  8. ISUTri

    Optionally Enclosed '&quot;' does not work for some reason

    Thanks for the responses. It looks like there is some dummy data added on to each of my SSN's. So it's nothing to do with what i thought (The Optionally enclosed). I'm guessing these are carriage return values. When I increase the destination field length to 10 it runs fine. I've been...
  9. ISUTri

    Optionally Enclosed '&quot;' does not work for some reason

    Hi, I am very new to Oracle and SQL Loader, this is actually my first sqlldr program that I have written. What I am wondering is why this does not work when it appears to work for everyone that I have found on the web. My Control File is below OPTIONS (SKIP = 1) LOAD DATA INFILE...
  10. ISUTri

    MS Access 2007 unbound subform comes up blank

    Hi, we recently converted to Access 2007 and I am having trouble with one of my forms. I currently have a form where you enter search criteria in and hit "Search" the form builds a query and then uses an unbound form to display the query results. However, when I login as a user this form is...
  11. ISUTri

    Compact Database in Access 2007 receives 3251 Error

    I forgot to paste my Replication Code. I am using Access 2007 with a Access 2003 MDB. Set db = DBEngine(0).OpenDatabase("C:\Snapshot\LocalReplica.mdb") strSyncTargetDB = "\\server\ServerReplica.mdb" db.Synchronize strSyncTargetDB, dbRepImpExpChanges db.Close My references are still...
  12. ISUTri

    Compact Database in Access 2007 receives 3251 Error

    sorry for the long wait between responses but here it goes. 1) This is a split database. There is a front end and a back end. The users have laptops that have a front end on their laptop along with a backend. As they work the data gets populated in their backend. When they get to a hotspot...
  13. ISUTri

    Compact Database in Access 2007 receives 3251 Error

    We are currently converting from Access 2003 to Access 2007. I have an Access app that is going to be very difficult to convert. This App is used by people that are out in the field and are a long distance from where our Access Databases are. So that is why we have Replication set up. So...
  14. ISUTri

    Access 2003: requested type library or wizard is not a vba project

    Thanks for the reply, but the interesting part is the MDE that I created in Access 2000 is the only part that doesn't work. If I load the Access 2000 mdb with 2003 it works fine. If I convert the app to 2003 and create an mde both work fine. The references looked ok to me too. The ones that...
  15. ISUTri

    Access 2003: requested type library or wizard is not a vba project

    I created an MDE with Access 2000 but when I try to use this mde on a PC with access 2003 I get the following error: requested type library or wizard is not a vba project I have other MDE's that I have made with Access 2000 that work fine with 2003. And the MDE that errors will work if I...
  16. ISUTri

    RunTime Error when trying to send out Auto Email Via Lotus Notes

    One of our users is getting the following error when she tries to send out Auto Emails. This error comes up at the part of code "domSession.Initialize ("")", we use Lotus Notes 6.5.4. The Auto Email works on other pc's including mine. Her actual error is as follows: Microsoft Visual C++...
  17. ISUTri

    How do I write from Excel to Access?

    I got Access to write to Excel. I had to set up the path to my workgroup file: SystemDBPath = "\\path\master.mdw" AccessEngine.SystemDB = SystemDBPath Now my question is this: How can I grab the login name used to login to the LAN of the PC? I know this can be done in access VBA but...
  18. ISUTri

    How do I write from Excel to Access?

    Thanks for the tip. The error is: Cannot start your application. The workgroup information file is missing or opened exclusively by another user. Did I mention that we have security on our access databases where you have to login with a username and password to get to the data? If not how...
  19. ISUTri

    How do I write from Excel to Access?

    ...to do what I need but I could never get it to write to my access db. Any help would be greatly appreciated! Below is the code i've used: '' *************************************************************************** '' Purpose : Access Log File : Record process activity '' Written ...

Part and Inventory Search

Back
Top