Search results for query: *

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}'`

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

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

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

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

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

Thanks! that's done the trick...

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

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

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

looks great, thanks guys.....

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

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"

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

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

Hi - have tried that site without success - hence it would be great to have a clear working example from someone who has succesfully connected.

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

Yes, setting up a link from VB.Net to Sybase, I'd love a simple example program if possible!

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 ?

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