Search results for query: *

dhookum, Yes, that's exactly what I was trying to do. Your way is much more succinct. I've implemented and tested it and it looks good. Thank you!

PHV, I'd keep a null value in [Serial Number] and leave the rest of the record as is. dhookum, I ended up doing this, but without using a min. tblHardware is sorted ascending on incrementing HardwareID, so the record with the lowest HardwareID value wins and gets to keep the [Serial Number]...

Hey everyone. Complicated reason why we're wanting this, so I won't go there... I leave it at there are Hardware servers with some VMs on them, each therefore having the same Serial Number. Basically, I have a field (Serial Number) that contains some duplicate values. I want to delete the...

I just accomplished this yesterday in a table called tblHardware by temporarily using a table called tblHardwareNoDups. In Access VBA I did an insert into a new table, thereby defining it's column to match the original. Cleared that table and added a primary key to the field I wanted to...

In case anyone is interested in the solution: https://community.oracle.com/thread/3549566

Questions: 1. When does utlpwdmg.sql run? (Other than when a DBA manually runs it) - When a user changes his own PWD? - What about when a DBA changes a users's PWD? - When a user with a profile assigned a password verify function signs in? - Other times? 2. Can you put...

Well, I skipped right to step 9 and ran the following command: @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catalog.sql I can now run the SQL select statement I was initially trying on dba_users. Only the OUTLN, SYS, and SYSTEM users are present. Should I be good to go or do you suggest...

I think I'm on to the root of the problem (thanks to yelworcm!). I initially created the 'oracle10' database using the DBCA, launched by the Oracle Universal Installer during install. Not knowing what I was doing, I later issued the CREATE DATABASE command. I'm fairly sure I just used "CREATE...

Thanks, LK, Is is possible I'm not using the correct db or something? I'm used to MySQL and the USE DATABASE command, but am learning that's not the way Oracle works. What are the startup steps I should take on a newly installed DB on Oracle Linux 5 to make sure my db is started correctly, I...

Hi, all, I've done some searching but haven't found anything that helps, only people getting the same error on tables they've just created. I've just installed 10g on Oracle Linux 5, and I'm trying to get off the ground. Although I can see dba_users exists in Enterprise Manager, I can't query...

I've browsed related threads and found nothing of help. Could someone please suggest a way to import a large, fairly complex XML file to MySQL? By large I mean about 19000 lines, and by complex I mean nesting about 15-20 levels deep. I'd prefer this solution not cost me money, if possible...

Update: I've tried uninstalling the 'Sony Picture Utility' software that came with the camcorder and reinstalling from the disk that came with it in an effort to rule out any automatic software updates. I've decided not to update the bios as the camcorder was working with this version of the...

Well, the funny thing is that after lunch the Device Manager no longer showed a Code 10, and said the device was working properly, but when I tried to capture video it didn't recognize that the camera was plugged in. I may try the linux disk to see if it is Vista's problem. I will probably...

Hello, I have a problem that is giving me a headache. A few days ago my firewire was working beautifully. After no known upgrades or system changes, it suddenly quit working. My camcorder screen says 'DV In' when I plug it in, but my computer will not recognize it. So here's some info and what...

Have to be online to access the site, which I can't do without a working network adapter :) I may pull it out and put in it the "old" XP machine, but that probably wouldn't help because it'd see that I have the 32 bit drivers I need for XP. I guess I could go buy one of the adapters that's...

I sure have seen that link, linney. A few of the members there have had luck getting their adapters to work. Unfortunately they're using a WMP54G V4 with a Ralink 2500 chipset, whereas I have a WMP54G V2 with a Broadcom 4300 chipset.

It's a PCI adapter, not a router.

Has anyone had any luck getting a Linksys WMP54G v2 with the Broadcom Chipset working on Vista 64bit? I found drivers that say they should work and I've heard testimonials of others online saying they got theirs working but I keep getting a 'code 10 - device cannot start' error. Any help?

The cost aspect really isn't an issue. We have other DBs running on Oracle 9i, and have servers already setup. This DB was built with a small targeted scope of users and because of Access' RAD abilities and small user base was built on Access. It's grown and we want to migrate it using...

After doing some research on the subject, it appears that the major performance gains that Oracle provides will only be realized after ensuring that the Microsoft Jet DB engine doesn't handle any of the data requests. There is a great Oracle paper (chapter 5) on the subject at...