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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by prigro

  1. prigro

    win2000 client - restricted access

    I think I've got it figured out. I had that user set up on the domain as part of groups "domain user" and "domain guest". When I removed him from the "domain guest" group the profile on the client stays. I assume that a domain guests profiles are automatically deleted.
  2. prigro

    win2000 client - restricted access

    Sorry, I guess I didn't give enough info. The machine logs on to a NT4 domain. On the domain the user is not an administrator.
  3. prigro

    win2000 client - restricted access

    I am trying to set up a windows 2000 client pc to have "restricted" access locally. The particular user has a habit of installing whatever he feels like and causing many issues on that pc. Most of my machines are set up as "administrator" locally which don't have the problem I'm experiencing...
  4. prigro

    Wrong time in ARCserve

    Sorry, forgot to mention the details: Brighstor Arcserve Backup r11.1 for linux w/service pack 1 RedHat Enterprise Linux AS version 3
  5. prigro

    Wrong time in ARCserve

    I first started noticing that my backups were starting an hour later each time they ran. When in the web based console, I observe the time in the java based window is an hour earlier than the operating system time. Actually, it is about 56 minutes different, not exactly one hour off. Very...
  6. prigro

    dbdefrag... where are you?

    I want to reduce the size of my database. I have setup pruning and a max database size. I need to run Dbdefrag to actually reduce the database, but cannot find the executable. It isn't in the path. Is it somewhere else? Do the database utilities get installed separately? I'm running...
  7. prigro

    reporting an Oracle LONG RAW text field (shows as BLOB in crystal)

    can anyone help me with the stored procedure syntax?
  8. prigro

    reporting an Oracle LONG RAW text field (shows as BLOB in crystal)

    I was using the Native connectivity within Crystal, but can use whatever it takes. I'm completely new to stored procedures. How would I go about creating the stored procedure... what would be the syntax?
  9. prigro

    reporting an Oracle LONG RAW text field (shows as BLOB in crystal)

    Unfortunately, the database is the back-end of a commercial ERP system for which I have no control. I too shook my head when I first came across this problem. Inserting the Sql Expression Substr(NOTATION.NOTE,1,1000) once again yielded the error: Error in compiling SQL Expression: Query...
  10. prigro

    reporting an Oracle LONG RAW text field (shows as BLOB in crystal)

    I'm using native oracle connectivity. The field I am trying to use (NOTE) is not in the list of fields available. Not sure why this would be the case. I then typed in the formula CAST(NOTATION.NOTE AS VARCHAR2(1000)), but the CAST did not turn blue indicating crystal doesn't recognize it...
  11. prigro

    reporting an Oracle LONG RAW text field (shows as BLOB in crystal)

    I would like to use crystal reports to report off a LONG RAW column in Oracle which contains text. Crystal Reports handles this datatype as a BLOB, therefore not displaying the text. I believe that a stored procedure can be used to solve this problem, unfortunately I don't know anything about...
  12. prigro

    Stored procedure to change datatype

    I would like to use crystal reports to report off a LONG RAW column in Oracle which contains text. Crystal Reports handles this datatype as a BLOB, therefore not displaying the text. I believe that a stored procedure can be used to solve this problem, unfortunately I don't know anything about...
  13. prigro

    Oracle 9i BLOB / LONG RAW data in report

    I am using CR 8.5 to report data from Oracle 9i. I have a column defined as LONG RAW and is populated with text data from an ERP system. When I use that column in Crystal, it shows it as BLOB datatype and the field is blank. How can I place the text data in a report?
  14. prigro

    Servers Updated to 10.0 and now disabled in SSC

    I have upgraded Symantec Antivirus Corporate edition from version 8 to 10. I uninstalled the old version before installing the new one. Now in Symantec System Center I see that the status of my servers is 'Disabled'. How do I enable them so I can set one as my primary server?
  15. prigro

    Arcserve database engine will not start

    I'm running AS2000 (V7.0). I located a directory which is called 'database' in the Arcserve directory which has almost 800 files in it. Do I need to gas those files and copy a fresh database there?

Part and Inventory Search

Back
Top