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 SkipVought 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
  • Order by date
  1. ptmcs

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

    little bit nasty, but utilised oracle: sqlplus -s ${USERID} <<eof>tmpwk select 'Xx;'||to_char(to_date('${enforceDate}','YYYYMMDD')+1,'DD/MM/YY') from dual; exit eof dateStampInterface=`cat tmpwk|grep 'Xx'|awk 'FS=";" {print $2}'`
  2. ptmcs

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

    Sorry guys, I'm not sure you understood what was required. It's not the date relative to today - it's a date relative to a date passed in as a parameter to the script... but don't worry now, a quick one line call to the database solves the issue... never mind..
  3. ptmcs

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

    Right, finally had a bit of time to revisit this. Thanks for the ideas - have found a working solution. Had installed the DTS support for 2005 (as above), DTS package loaded up ok into the DTS Designer in the Management/Legacy section of 2005 Management Studio. Scheduling was done by -...
  4. 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...
  5. ptmcs

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

    We've already downloaded the backwards compatibility packages and tested the DTS package on a client machine. We will eventually move it to SSIS - but as stated - for now we just want to simply tranfer the DTS package from 2000 to 2005 - not change it - and just run it and schedule it. If...
  6. 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...
  7. ptmcs

    awk substr adds extra spaces

    Thanks! that's done the trick...
  8. 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...
  9. 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
  10. 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...
  11. ptmcs

    Any good Oracle Book recomendations.....

    looks great, thanks guys.....
  12. 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...
  13. ptmcs

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

    Here was the answer in the end.... seems to work ok. With objConnection .ConnectionString = "Provider=MSDAORA.1;Password=DVD;User ID=DVD;Data Source=XE;Persist Security Info=True"
  14. ptmcs

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

    Still need help on the Oracle XE connection though! This works ok for Oracle 9 but not for Oracle XE: <% Dim objConnection Dim objRecordset Set objConnection = Server.CreateObject("ADODB.Connection") With objConnection .ConnectionString = "Provider=MSDAORA.1;Password=cmtest2;User...
  15. ptmcs

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

    On further investigation, looks like its 12.5 ASE database - but Sybase open Client is 11. So solution for Sybase was (after setting up ODBS entry): <% Dim objConnection Dim objRecordset Set objConnection = Server.CreateObject("ADODB.Connection") With objConnection .ConnectionString =...
  16. ptmcs

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

    Hi - have tried that site without success - hence it would be great to have a clear working example from someone who has succesfully connected.
  17. 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...
  18. ptmcs

    Sybase and VB.Net

    Yes, setting up a link from VB.Net to Sybase, I'd love a simple example program if possible!
  19. 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 ?
  20. ptmcs

    Nortel Contivity VPN Client & BT Voyager 2091 Router

    Hi, I recently had very similar problem. I had a 'brand new laptop' with Windows XP. Got BT Broadband and wireless router - installed fine.... access no problem.. Then tried to install Contivity VPN client and it would not install at all.... kept failing ... tried allsorts of things , some on...

Part and Inventory Search

Back
Top