Search results for query: *

I am not catching the error when the FTP process fails in the following code. The CONET FTP object does not throw an exception. How can I code a boolean to catch the ftp failure? try { FTP objFTP = new CONET.FTPClass(); System.Object lngFTPConn = objFTP.FTPConnect(strHost,strUser,strPass)...

Thank you, you have helped immensely. I will take your advice and start using ADO,NET. I did find, after searching hidden files, that I have version 2.81.1117.0 MDAC on my PC. Thank you again!

Cassidy, Thanks again. First off we are using MSDAORA because we don't know any better. None of us have taken any .net classes and we are attempting to learn how to use it on our own, sharing with each other what we have learned. I'll read about OraOledb and attempt to use it in the app I'm...

Cassidy, Thanks for your help. What we are still wondering is why am I forced to use MSDAORA.1 as my provider instead of MSDAORA? We coded the same console app on three PC's. The other two programmers could connect to the database using provider=MSDAORA and if I used that I'd get an error...

I am in a group programming situation with two other programmers. Just received a new PC, WindowsXP pro sp2, installed Oracle 8i, C# & .Net to connect to Oracle databse. My connecton string is as follows: strConn = "Provider=MSDAORA.1;User ID=myID;Password=Mypwd;Data Source=address.of.server"...

Thank you, this is so much easier than I was trying to do.

I have a report that lists two types of numbers; actual and forecast. Let's say I'm printing the report during the month of March. I want Jan and Feb columns to show actual numbers and March through Dec to show forecast numbers. This report sums the columns based on job#. I have one query with...

Please explain to me what 'BOL' is and where I can find it. I'd like to look up hash joins that were discussed in a thread from 02/03/2004 which I have inserted below. Thank you >can you explain what is a hash join >jymm (Programmer) Feb 3, 2003 >BOL has a very nice explanation of HASH joins...

jad, While you were working on the inclusion of the date problem, I took your first solution and worked with it. This is what I came up with. I ordered the returned items by descending date and then numbered the rows. Out of the numbered rows, I select row #1. This will give me one line per...

jad, You're solution highlights a problem I didn't contemplate...What happens when more than 1 product sums to maximum quantity. If I wanted to include tr_date in the selection criteria and use the most recent tr_date to select between the multiple Max quantities, where would I insert it? Thank...

jad....close, but not quite there. If the top quantity = 200 and the customer has more than one product that totals to 200, then all products with total quantity of 200 are returned.

My problem is that my transaction table can contain 1 or more lines for the same product for a customer. I need to make a subquery that will, by customer, sum the quantity for like products and then extract the all of the information for the product with the largest quantity so it can be used...