Recent content by Guinea

Greetings, Does anyone know of a freeware tool to determine the table structure and relationships of an Oracle database? I can link tables through ODBC but am having trouble determing the table relationships from the table names. Can't afford to purchase some of the commercially availble...

Please disregards my last post- found that it is part of the OS. Thanks everyone for your help! Got acess to the db through MS Access :). Now I only have to track down the IT guy who created the db to get the table structures and relationships..... Thanks Again Guinea pigs make the world a...

Thanks for your help! So I was following the instructions in the link you supplied and could not find the Microsoft ODBC administrator under Oracle home> Configuration and Migration Tools path. Is this an Oracle supplied program or Microsoft program? How do I go about getting it? I don't...

Greetings, Basic question. I searched the forum but could not come up with what I need. How do I connect to a Oracle database from access? I tried setting up and ODBC connection but couldn't get it to work. On my desktop I have 1)Oracle and Access 2003 2)a TNSnames entry that others use...

Hi there, We have an Excel macro that analyzes excel data which is currently less than 50,000 rows. Are needs are increasing and need to analyze databases of 100,000 rows or more so we need to go to access. How can we use Access to store the data and export chunks say 25,000 to Excel and have...

Hi There, I want to create a loopback connection on my w2k machine runing 8i1.6 to practice using the DBA studio tools on the database running on the same box. I was told if I use host 127.0.0.1 I can do this. My Tsnames= # TNSNAMES.ORA Network Configuration File...

Thanks pbxman I went to the link but the ASPI updater is not compatible with Windows2000 according to Sony. I hate to spend more money to get Nero when I just bought this CD-RW. Do you think it might be that my y2k just needs to be repaired or a clean install? I was able to get the software...

Hi There, I just installed a sony CD-R/RW CRX215A1 in my Gateway PIII 450 mhz/ Windows 2000 pro machine. The machine booted fine. The machine runs fine and I can play audio CD's from the CD-R/RW. When I try to run the CD-R/RW burner software (B's recorder GOld5.09) I get a blue screen and...

i There, I just installed a sony CD-R/RW CRX215A1 in my Gateway PIII 450 mhz/ Windows 2000 pro machine. The machine booted fine. The machine runs fine and I can play audio CD's from the CD-R/RW. When I try to run the CD-R/RW burner software (B's recorder GOld5.09) I get a blue screen and the...

Thanks Berton, So I do I need the SCSI/Raid drivers to run my hard drive or floppy? There is a separate driver to run the adaptec SCSI converter PCI card. In device manager I could uninstall one of the SCSI/RAID drivers (the one that is the same as 2' IDE) but do not have the option for the...

hi there, I am having trouble running some CD-R/RW software (B's Recorder Gold5) and get the message: "Stop:0x000000D1 (0x000000DB, 0x00000012, 0x00000000, 0xEB4571787) Driver_IRQL_not_les_or_equal" I assume it is a IRQ problem: IRQ Assignment 14 Primary IDE Channel 14 SCSI/RAID...

Hi there, I just installed a CD-R/RW into my Gateway PIII/450 mHZ computer. Windows 2000 PRO service pack 3 Config- CD-ROM -Slave for secondary IDE CD-R/RW-Master for secondary IDE scsi adapter in one PCI slot Ethernet card in another Printer hookedup to the parallel port one floppy- Slave for...

Hi CARP, Thanks for your response. I am still a little confused why I am getting this error. The schema scott is the default demo scott/tiger and I am loged on as system/manager. I can run the query in an SQL statement but not as a stored procedure? I should have select priveleges if I can...

Hi Everyone, I need to create a stored procedure that summarizes info in a table. I want to specify the schema that the table resides in. I tried this code create or replace procedure analyze_dept AS v_dept_record dept%ROWTYPE; BEGIN SELECT * INTO v_dept_record from Scott.dept; END; /...

Yes, that was part of the problem. I also needed to declare the records returned from the cursors. Thanks so much for your help!!!! '___' Hopefully soon I will have enough experience to contribute to the forum too. Below is the code that did compile without errors. CREATE OR REPLACE...