Search results for query: *

Thanks for the replies. gmmastros - I'm not experiencing any performance problems as yet - the question was asked so as to avoid them in the future. crowley16 - I've run some tests and the results are identical so i'll go with the easiest route I think - the one with the least typing!!

I have quite a few SP's that need changing to accomodate exchange rate calculations. These SP's are run possibly 1000's of times each day so they need to be as fast as possible. Basically data comes from several shops up to the HQ and the data gets inserted. Now, 1 of those stores is in a...

I've got a program that makes extensive use of quite a few collections. When the form closes and goes back to the main form that called it, it's as though the program seems to hang for a period of time that has a relationship with the number of items that are in the collection (therefore it...

Hi Ron I think you've misunderstood what I want to do as you cannot use CreateObject to instantiate .NET assemblies. I've found a solution that works however: Dim a As String = My.Settings.AssemblyPath & "TestClass.dll" Dim b As String = "TestClass.ExternalProg" Dim MyAssembly As...

I've got an app written in VB.NET that creates a menu structure, with each menu item being a module in our application. We are in the process of converting the old VB6 stuff to .NET so there are a mixture of things going off! Basically, if it's a VB6.0 app I can do this: Dim a As Object a =...

I probably didn't make my self clear......I want a recordset containing multiple columns, not one column containing a comma seperated list.

Hi all, I have a table that is basically ID, ItemID, Alias There can be multiple rows for the same ItemID but the Alias will be different EG, ID ItemID Alias 1 1 Moose1 2 1 Moose2 3 1 Moose3 4 1 Moose4 5 2 Moose5 6...

Hi all! I've got a field in a SQL 2000 db that holds an integer value that is set from a VB front-end (a series of 11 checkboxes) so that the number is a binary representation of whether the boxes are checked or not. For example 11111111111 = all checked and a value in the DB of 8191 (decimal...

What i'm trying to do is improve on one of our competitiors software but my Web Service/Pocket PC experience is limited. This is the scenario: There is a Windows App that the user enters their SQL server connection settings into - this is written to the windows registry. There is a Pocket PC...

We need to move an Informix Database (Standard Engine) that currently resides on a box with HP-UX as the operating system to one with SCO Openserver 5.0.7. I dumped the database directory to a tape and then copied it onto the new machine but when I try to access it I get a "database not found...

We need to move an Informix Database (Standard Engine) that currently resides on a box with HP-UX as the operating system to one with SCO Openserver 5.0.7. I dumped the database directory to a tape and then copied it onto the new machine but when I try to access it I get a "database not found...

Hi everyone I've been programming for about 6 years, the first 4 in COBOL and the last 2 in VB 6.0. I think its about time I did something about learning all about this .NET stuff!! Eventually i'd like to take the MCAD exams but in the first instance can anyone recommend any books that I...

Not sure if this should be posted here on the unix/hp forums but i'll start here! Basically i've got a VPN tunnel established between 2 sites. I've got a Netgear FVS318 (hereafter called A)on one end and a ZyXEL Prestige 652H/HW-31 (hereafter called B) on the other. The tunnel is fine and the...

I found the files - they were created on server A when they should have been on Server B!! Not to worry! Clegg

cdlvj - Thanks for all your help. I've decided to to copy data from Server A onto Server B and then use the free space on Server A to restore the tape. When i've finished I can put it all back again. Not the ideal solution but I'm running out of time ;-) Clegg

One more thing! I left the script running and the last thing it said was cpio: cannot write dev/olddat: No space left on device (error 28) Does this mean its been writing back to the tape?? Clegg

cdlvj - This is what i'm using: cpio -icvBdum </dev/rct0 | rcmd oldbox "cpio -ocvBdum >/tmp/data.cpio" If i'm not logged in as root it seems to be going through the motions but there are lots of errors such as 'cannot get info about file or cpio:cannot link I've tried running the same...

cdlvj - Should the last bit (/temporary/file.cpio) be replace by something more meaningful or it that the exact syntax? Clegg

cdlvj - Yes the machines are connected via tcp. An additional problem is that there is no enough hard disk space on Server A to copy the image as suggested. Server B has a nice empty disk and the data backup I want to CPIO is too large for Server A!!!!! Any other suggestions? Clegg

Hi all I've got a problem! I need to get some data off of a tape via CPIO onto server B. Unfortuantely Server B's tape drive is broken but I have a working tape drive in Server A. How do I copy the contents of the tape onto Server B using the tape drive from Server A? TIA Clegg