Recent content by ToeJamNEarl

The oracle version on both server and client are the same 92i

Hey Guys, It's me again. I have been trying to figure out why one computer out of four that I've tried my application return an oracle error ora-06502. The error occurs when the program gets to the Execute command of the stored procedure. Can someone list me possibilities of why this would...

Try making the provider OraOleDB.Oracle

I just tested my software (old working version with ORAOLEDB) on another test machine, and it ran fine. I think there is something wrong with the computer itself that has been giving me problems. Is there anyway to check it a component is corrupted? Maybe the ADO component in charge of...

I find that last statement funny, because MS states their driver is superior. http://support.microsoft.com/default.aspx?scid=kb;en-us;229757

the set objRS = datcmd1.execute is used to have the stored procedure pass down a table of information from teh stored procedure to populate the recordset used. with the OraOLEDB provider and one other test machine, with prmNumofClients I can see it's value by doing prmNumOfclients.Value...

datCmd1.CommandType = adCmdStoredProc datCmd1.CommandTimeout = 16000 'Long timeout datCmd1.CommandText = "app_stat.Shipping_Tracker.Get_Statistics" The result set contains 2 fields a description and a count. the other parameters that are either IN OUT or just OUT get filled with the...

Yes, I used parameters objects. I have simulated your adoCMD.parameters.append line by adding: datCmd1.parameters.append prmX Where X is the parameter object created.

Hey Guys, I have tried it your way for creating parameters and I get the same error message: -2147217900 ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to '<PROCEDURE NAME>' ORA-06550: line 1, column 7: PL/SQL: statement ignored Microsoft OLE DB Provider...

Quick question, do input output paramters work well with the MSDAORA provider?

Hey Guys, I am trying to call a stored procedure with ADO command object as well as connection. I have the stored procedure return a reference cursor, and the way I call my stored procedure is: set objRS = datCMD1.execute The application gives me an error saying wrong type or number of...

Thanks Zemp, but I have figured out how I want to approach my problem and it was simpler than I had anticipated.

Hey guys, I have in a VB application two text boxes that the user can enter a range that they would want to query off of the server. The user can have the option of inputing as much of the range information they know when creating their ranges. I am wondering is there anyway I can use LIKE...

JJames you'll also be getting a star when I get home from work, due to the alertbeforeoverwriting = false and displayalerts = false. Those two lines helped me get rid of my insanity when Excel tried to overwrite a file. I originally was going to go with the template file and I was until a...

Casper, Thanks a bunch. I'll give you a star when I get home (company settings forbid javascript). I figured it out before checking your reply and I was at that same site. hmckillop: you'll get a star as well because you took the time to code out an example which was helpful. Thanks guys...