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

  • Users: ptmcs
  • Content: Threads
  • Order by date
  1. ptmcs

    Date passed in as parameter - how to add 1 day to this date?

    hi, a little bit of an odd one, if anyone has a neat idea. We have a script which runs overnight using current date, in the case of failure we may need to rerun it and force the date to be a specific one. For example, we may force a date like 20071231 Within the script, the date is used in...
  2. ptmcs

    How to schedule a DTS Package (from SQL2000) in SQL2005?

    Hi, We have a DTS package from SQL2000 which needs to be run on a SQL2005 server (64-bit). We will move the DTS package to 2005(SSIS), but for now simply want to run and schedule as a 2000 DTS Package. I have managed to load in the DTS package into the new SQL2005 server from my local PC...
  3. ptmcs

    awk substr adds extra spaces

    hi, The following awk works 'mostly ok', except extra spaces are added by awk. Does anybody know how to stop it from doing that? cat $filein | awk '{print \ "|", substr($0,15, 2 ), \ "|", substr($0,72, 4 ), \ "|", substr($0,230, 80), \ "|", substr($0,856, 7 ) \ }'>fileout...
    • ptmcs
    • Thread
    • Replies: 2
    • Forum: AWK
  4. ptmcs

    Unix Script (aix) - how to send SMS message.

    Hi, Has anybody send SMS messages from a UNIX script? What components do you need to facilitate this functionality? Many Thanks
  5. ptmcs

    Anyone integrated Microsoft Visual Studio 2003(C++) with Oracle PRO C?

    Hi all, From investigation I have found that Oracle's PRO C precompiler can be integrated within the Visual C++ enviroment - at least with visual C++ version 6.0 We have Visual Studio 2003 with 7.1 of Visual C++ and it appears not to like PRO C. If anybody has managed to integrate PRO C with...
  6. ptmcs

    Any good Oracle Book recomendations.....

    I have a forthcoming role which will give me an opportunity to use Oracle for the first time in anger. Anyone suggest any good books along the lines of: Good Oracle Quick Reference... A good DBA book (i'm familiar with DBA'ing Sybase) A good PL/SQL book etc etc... any suggestions...
  7. ptmcs

    ASP connection strings help for Oracle 10g XE and Sybase 12.5 wanted!

    Hi, Firstly, apologies if this seems a dumb question - I've looked around the web and seem to get a lot of conflicting information and get swamped with information about ASP.NET which is not what i am using. I am just starting out with ASP. I have a basic script which I can connect to an...
  8. ptmcs

    Sybase and VB.Net

    Hi Folks, The whole world of linking Sybase to VB.Net seems a complete mess. Does anybody know of a good website / guide for setting up a link from VB.Net to Sybase ?
  9. ptmcs

    Nortel Contivity VPN Client fails to install on XP Pro

    hi.... Contivity VPN Client fails to install on XP Pro have disabled IPSEC as advised on a POST but it still fails to install. Machine is brand new clean, except wireless network drivers and bt broadband any ideas anyaone ?
  10. ptmcs

    Contivity VPN Client fails to install on XP Pro

    hi Contivity VPN Client fails to install on XP Pro have disabled IPSEC as advised on a POST but it still fails to install. Machine is brand new clean, except wireless network drivers and bt broadband any ideas anyaone ?
  11. ptmcs

    Replication Question

    Hi, We currently have 3 servers whereby tables are replicated across all 3. I know the name of a table on 2 of the servers, I know the source of the data is from the 3rd server - but i don't know the name of the table. Is there a way i can tell? I don't have access to replication server...
  12. ptmcs

    Debugging tips

    Hi All, Has anyone got any great hints/tips for debugging stored procs/triggers. I'm getting 'fed up!!' of adding print statements / writing off to temporary tables etc... Tried DBartisan 7 with 'step through/watch' etc etc (proper debugging stuff!) but that spends most of its time...
  13. ptmcs

    MS SQL Profiler equivalent

    In Microsoft SQL Server - there is a great tool called the 'Profiler' which allows you to do great stuff like SQL traces from Applications etc etc.... I have never seen such a tool available for Sybase, the only way I have done it in the past was by turning 'auditing' on and fudging it that...
  14. ptmcs

    Error Handling with a trigger

    Hi, I'm looking for any ideas on a scenario I have with a trigger... We have a 3rd party application which we cannot access any code - I have written a trigger which generates some dynamic SQL, which is executed later, based on data inserted to a particular table - seems a reasonably safe way...
  15. ptmcs

    How to get columnname of an index from sysindexes

    Hi, I have a bit of SQL whereby I have a list of tables, from that I can get the 'id' of each table from sysobjects. Using the 'id' and 'indid' of 1 - I can derive the name of the primary key - however, I am not sure then which table to interrogate to get the name of the actual column the...
  16. ptmcs

    quickest way to load textfile into a textbox

    Whats the quickest way to load text into a textbox in vb5? DOn't want to use RichTextBox Many thanks
  17. ptmcs

    Force UpperCase in Textbox (vb5 pro)

    hi, First of all apologies, I am returning to VB after a break of several years! I have a textbox which I would like to force all characters entered to be uppercase. Is there a simple easy way to do this?
  18. ptmcs

    How to use - sp_fkeys

    hi, does anybody know how to use sp_fkeys ? I have a table that definitely has foreign keys (can examine them in enterprise manager/table design) but can't work out the syntax for sp_fkeys to simply list all foreign keys the table has... Yes I know it should be easy!!! and the online...
  19. ptmcs

    Help with a Trigger!

    Hello all, We have an application (ambercat - helpdesk software) whereby an action can be added to a request which results in the following sql: begin transaction insert into Actions update requests commit What I want to do is add a trigger to the Actions table which will do up...

Part and Inventory Search

Back
Top