Loading CSV files into Oracle tables
There are 6 ways to do it: 1. There is a software, called Oraxel (or something like that) which connect Excel tables with oracle (and vise versa) 2. You could export your Excel tables into Access and link Access – Oracle tables through ODBC 3. You could do such export with OEM (Oracle Enterprize Manager) [...]
View Answer
| April 19, 2013 4:13 PM
Corporate Financial Applications, Database Management Systems, ERP, Financials, Human resource applications, Informix, iReceivables, Microsoft Access, Oracle, Payables, Procurement, Projects
There are 6 ways to do it: 1. There is a software, called Oraxel (or something like that) which connect Excel tables with oracle (and vise versa) 2. You could export your Excel tables into Access and link Access – Oracle tables through ODBC 3. You could do such export with OEM (Oracle Enterprize Manager) [...]
View Answer
| April 19, 2013 4:13 PM
Corporate Financial Applications, Database Management Systems, ERP, Financials, Human resource applications, Informix, iReceivables, Microsoft Access, Oracle, Payables, Procurement, Projects
How to check the loop in Cisco switch
I think you are talking about forwarding loops seeming they can cause all sorts of wacky behavior in various Cisco switches. You will find basic troubleshooting and testing information below and you can also find more information on dealing with it at this Cisco URL: Forwarding loops vary greatly both in their origin (cause) and [...]
View Answer
| April 19, 2013 1:51 PM
Cisco switches, Network administration, Network loop, Switches
I think you are talking about forwarding loops seeming they can cause all sorts of wacky behavior in various Cisco switches. You will find basic troubleshooting and testing information below and you can also find more information on dealing with it at this Cisco URL: Forwarding loops vary greatly both in their origin (cause) and [...]
View Answer
| April 19, 2013 1:51 PM
Cisco switches, Network administration, Network loop, Switches
Fatal NI connect error 12170 – Oracle alert log
You didn’t provide enough details. It is probably a connection timeout due to network problems or delays. Take a look at this guide (look for ORA-12170): Troubleshooting Oracle Net Services.
View Answer
| April 19, 2013 2:30 PM
Oracle alerts, Oracle Error Codes, Oracle errors, Oracle Log File
You didn’t provide enough details. It is probably a connection timeout due to network problems or delays. Take a look at this guide (look for ORA-12170): Troubleshooting Oracle Net Services.
View Answer
| April 19, 2013 2:30 PM
Oracle alerts, Oracle Error Codes, Oracle errors, Oracle Log File
Extract List of users from a Domain Windows Server 2003 Domain Controller
You can use Control Panel’s Administrator Tool called Active Directory Users and Computers to export your users with their email address information. To export the list, you must highlight the Users container in the right pane, and right-mouse click to select Export List… as shown below. (Note the changed column headings that are displayed matches [...]
View Answer
| April 19, 2013 2:39 PM
Domain, Domain Controller, Windows Server 2003, Windows Server 2003 Domain Controller
You can use Control Panel’s Administrator Tool called Active Directory Users and Computers to export your users with their email address information. To export the list, you must highlight the Users container in the right pane, and right-mouse click to select Export List… as shown below. (Note the changed column headings that are displayed matches [...]
View Answer
| April 19, 2013 2:39 PM
Domain, Domain Controller, Windows Server 2003, Windows Server 2003 Domain Controller
Delete all tables in SQL Server database?
Sql Server has an option of navigating to all tables using stored procedure sp_MSforeachtable For e.g the following command will drop all the tables in the database: exec sp_MSforeachtable 'DROP TABLE ?' The below command will clear all the tables: exec sp_MSforeachtable 'DELETE FROM ?' So by using the procedure sp_MSforeachtable you can navigate to [...]
View Answer
| April 19, 2013 4:15 AM
DELETE statement, SQL Database, SQL Server, SQL Server database, SQL tables
Sql Server has an option of navigating to all tables using stored procedure sp_MSforeachtable For e.g the following command will drop all the tables in the database: exec sp_MSforeachtable 'DROP TABLE ?' The below command will clear all the tables: exec sp_MSforeachtable 'DELETE FROM ?' So by using the procedure sp_MSforeachtable you can navigate to [...]
View Answer
| April 19, 2013 4:15 AM
DELETE statement, SQL Database, SQL Server, SQL Server database, SQL tables
Why does Excel keep crashing?
I would recommend copying the worksheet tabs to a new workbook. Save it under a different name and see if the problem continues. If it does, then try to do one tab at a time and isolate which sheet is causing the problem. =========== Your MS Office application particularly MS Excel has probably encountered corrupted [...]
View Answer
| April 19, 2013 8:47 AM
excel, excel 97, Excel error messages, Windows XP
I would recommend copying the worksheet tabs to a new workbook. Save it under a different name and see if the problem continues. If it does, then try to do one tab at a time and isolate which sheet is causing the problem. =========== Your MS Office application particularly MS Excel has probably encountered corrupted [...]
View Answer
| April 19, 2013 8:47 AM
excel, excel 97, Excel error messages, Windows XP
Viewing a Lotus Notes archive with other email program
Yes, you can. If I am not misunderstanding, you want to view Lotus mails in outlook! Here are the steps: 1. Open Outlook > Select Tools > E-mail Accounts 2. Click Add new e-mail account > Click Additional Server Types from E-mail Accounts” 3. Click Microsoft Office Outlook Connector for IBM Lotus ….from the pane [...]
View Answer
| April 19, 2013 4:48 AM
Lotus Notes archiving, Lotus Notes backup, Lotus Notes email archiving, Outlook, Outlook archive
Yes, you can. If I am not misunderstanding, you want to view Lotus mails in outlook! Here are the steps: 1. Open Outlook > Select Tools > E-mail Accounts 2. Click Add new e-mail account > Click Additional Server Types from E-mail Accounts” 3. Click Microsoft Office Outlook Connector for IBM Lotus ….from the pane [...]
View Answer
| April 19, 2013 4:48 AM
Lotus Notes archiving, Lotus Notes backup, Lotus Notes email archiving, Outlook, Outlook archive
Windows Server 2003 forgotten password
Hi, If you have some other account enabled for your PC then login using that account. 1-> Type “cmd” in Run dialogue box, it opens the command prompt. 2-> Type “<b>net user</b>” & you will get all the user accounts available something like following- User accounts for \My-PC ———————————————————– admin ASPNET Guest HelpAssistant SUPPORT_388945a0 The [...]
View Answer
| April 19, 2013 7:23 PM
Administrator password, Forgotten password, Password, Windows Server 2003, Windows Server 2003 administration, Windows Server 2003 security
Hi, If you have some other account enabled for your PC then login using that account. 1-> Type “cmd” in Run dialogue box, it opens the command prompt. 2-> Type “<b>net user</b>” & you will get all the user accounts available something like following- User accounts for \My-PC ———————————————————– admin ASPNET Guest HelpAssistant SUPPORT_388945a0 The [...]
View Answer
| April 19, 2013 7:23 PM
Administrator password, Forgotten password, Password, Windows Server 2003, Windows Server 2003 administration, Windows Server 2003 security
How to run Oracle 10g forms on browser
Are you trying to run your form from Forms Builder? Have you started the OC4J? Is there some error message? You might find this tutorial for Oracle10g Forms / Reports useful.
View Answer
| April 19, 2013 12:46 AM
Oracle 10g, Oracle Forms, Oracle Forms 10g
Are you trying to run your form from Forms Builder? Have you started the OC4J? Is there some error message? You might find this tutorial for Oracle10g Forms / Reports useful.
View Answer
| April 19, 2013 12:46 AM
Oracle 10g, Oracle Forms, Oracle Forms 10g
Backups failing due to volume shadow copy
The hotfixes actually didn’t make a difference. I tried to run manual shadow copies during the day when I knew nothing could be causing a conflict. This still failed so I thought maybe the shadow copies are failing because of disk space (even though just under 1 GB was free) I checked and the shadow [...]
View Answer
| April 19, 2013 3:53 PM
Backup & recovery, Volume Shadow Copy, Windows Server 2003, Windows Server backup
The hotfixes actually didn’t make a difference. I tried to run manual shadow copies during the day when I knew nothing could be causing a conflict. This still failed so I thought maybe the shadow copies are failing because of disk space (even though just under 1 GB was free) I checked and the shadow [...]
View Answer
| April 19, 2013 3:53 PM
Backup & recovery, Volume Shadow Copy, Windows Server 2003, Windows Server backup
How to include mulitple emails as a Lotus Notes email attachment
Can you select the email – put a check mark next to them – and then select ‘forward’? This will open a new memo with the selected email included. Not sure exactly you can send as attachments…but some work around to forward required mails.. 1.From the mailbox select the mails you want to forward to(using [...]
View Answer
| April 19, 2013 4:28 AM
Lotus Notes, Lotus Notes email, Lotus Notes email attachments
Can you select the email – put a check mark next to them – and then select ‘forward’? This will open a new memo with the selected email included. Not sure exactly you can send as attachments…but some work around to forward required mails.. 1.From the mailbox select the mails you want to forward to(using [...]
View Answer
| April 19, 2013 4:28 AM
Lotus Notes, Lotus Notes email, Lotus Notes email attachments
Multiple DHCP Scopes for multiple VLANS
I may be mistaken, but my understanding was the proxy, (whether it is a router running iphelper or a windows DHCP proxy), provides the network it wants the IP for in the request. The main DHCP server responds with an IP from the appropriate scope. As long as the DHCP proxy knows the subnet the [...]
View Answer
| April 19, 2013 4:58 PM
Active Directory, Desktops, DHCP, DNS, Management, Microsoft Windows, Network protocols, Networking, Networking services, OS, Security, Servers, SQL Server
I may be mistaken, but my understanding was the proxy, (whether it is a router running iphelper or a windows DHCP proxy), provides the network it wants the IP for in the request. The main DHCP server responds with an IP from the appropriate scope. As long as the DHCP proxy knows the subnet the [...]
View Answer
| April 19, 2013 4:58 PM
Active Directory, Desktops, DHCP, DNS, Management, Microsoft Windows, Network protocols, Networking, Networking services, OS, Security, Servers, SQL Server
Capture a photo through webcam with Visual Basic 6
Here is an example on how to capture video, image should be even easier. Take a look at this question/answer for sample code. Feel free to ask if you have any questions.
View Answer
| April 19, 2013 1:17 PM
VB 6, Video capture, Visual Basic, Visual Basic 6, Webcam
Here is an example on how to capture video, image should be even easier. Take a look at this question/answer for sample code. Feel free to ask if you have any questions.
View Answer
| April 19, 2013 1:17 PM
VB 6, Video capture, Visual Basic, Visual Basic 6, Webcam
Connect to Internet via VMware
Hi, Try to use a NAT network in the guest machine, this way you will use the same network in guest and virtual machines. If you want to use another ip address in the guest machine, then create a bridged network between the host and guest machines. Refer to this guide for more information. Hope [...]
View Answer
| April 19, 2013 1:47 AM
Virtual OS, VMware
Hi, Try to use a NAT network in the guest machine, this way you will use the same network in guest and virtual machines. If you want to use another ip address in the guest machine, then create a bridged network between the host and guest machines. Refer to this guide for more information. Hope [...]
View Answer
| April 19, 2013 1:47 AM
Virtual OS, VMware
Lotus Notes email rules (send full copy to) not working
Hii.. Open configuration document an navigate to Router/SMTP -> Restriction and Control -> Delivery Control and please be confirm that “user rules mail forwarding” is Enabled or not. Cheers, Asim Ahmed Lotus Admin
View Answer
| April 19, 2013 5:34 AM
Lotus Notes, Lotus Notes mailbox, Lotus Notes Rules, Lotus Notes Troubleshooting
Hii.. Open configuration document an navigate to Router/SMTP -> Restriction and Control -> Delivery Control and please be confirm that “user rules mail forwarding” is Enabled or not. Cheers, Asim Ahmed Lotus Admin
View Answer
| April 19, 2013 5:34 AM
Lotus Notes, Lotus Notes mailbox, Lotus Notes Rules, Lotus Notes Troubleshooting
Syncing shared Outlook calendars on an iPhone
Give it a try. This might help: http://www.stevieg.org/2010/11/shared-exchange-calendars-on-ios-devices/ Good Luck.
View Answer
| April 19, 2013 5:51 PM
iPhone Exchange
Give it a try. This might help: http://www.stevieg.org/2010/11/shared-exchange-calendars-on-ios-devices/ Good Luck.
View Answer
| April 19, 2013 5:51 PM
iPhone Exchange
Offline files not working Windows 7
Please try out this …. Click Start menu > Run > gpedit.msc In the Local Group Policy Editor click to expand the folder and you will get Local Computer PolicyComputer ConfigurationAdministrativeTemplatesNetworkOffline Files Allow or disallow use of offline files feature….: Enabled Prohibit user config….: Enabled Sync all offline files when logging on….: Enabled Sync all [...]
View Answer
| April 19, 2013 5:08 AM
Offline files, Windows 7, Windows 7 Administration, Windows 7 Professional, Windows File Server
Please try out this …. Click Start menu > Run > gpedit.msc In the Local Group Policy Editor click to expand the folder and you will get Local Computer PolicyComputer ConfigurationAdministrativeTemplatesNetworkOffline Files Allow or disallow use of offline files feature….: Enabled Prohibit user config….: Enabled Sync all offline files when logging on….: Enabled Sync all [...]
View Answer
| April 19, 2013 5:08 AM
Offline files, Windows 7, Windows 7 Administration, Windows 7 Professional, Windows File Server
Removing HDD passwords
HDD Unlock Wizard is a user-friendly application which allows you to easily remove HDD password. IDE and SATA hard disk drives are supported. Both User and Master password can be removed. Please note that while unlocking, HDD Unlock Wizard will erase and re-certify the drive, meaning to say all data in the disk is lost [...]
View Answer
| April 19, 2013 9:14 PM
Hard drives, HDD, Seagate, Security
HDD Unlock Wizard is a user-friendly application which allows you to easily remove HDD password. IDE and SATA hard disk drives are supported. Both User and Master password can be removed. Please note that while unlocking, HDD Unlock Wizard will erase and re-certify the drive, meaning to say all data in the disk is lost [...]
View Answer
| April 19, 2013 9:14 PM
Hard drives, HDD, Seagate, Security
Hung at applying computer settings
Have you tried resetting the IP stack AND winsock with WinsockXPfix.exe? try that next. Here is a link: This could also be a NIC issue. Try going into device manager, delete the NIC. reboot, then reinstall the drivers. If that works then fine. If not, then try the winsockxpfix as stated above. Releasing and renewing [...]
View Answer
| April 19, 2013 3:52 AM
Boot, Login, Windows XP, XP Professional
Have you tried resetting the IP stack AND winsock with WinsockXPfix.exe? try that next. Here is a link: This could also be a NIC issue. Try going into device manager, delete the NIC. reboot, then reinstall the drivers. If that works then fine. If not, then try the winsockxpfix as stated above. Releasing and renewing [...]
View Answer
| April 19, 2013 3:52 AM
Boot, Login, Windows XP, XP Professional
How do you find the IP address of a switch in a LAN from a PC
Network switches don’t have IP addresses which normal network users would need to know. The IP address is only used to manage the network switch. Even if you had the IP address of the network switch you won’t have access to log onto the operating system of the network switch. Without knowing the IP address [...]
View Answer
| April 19, 2013 10:07 PM
IP addressing, LAN, Switches
Network switches don’t have IP addresses which normal network users would need to know. The IP address is only used to manage the network switch. Even if you had the IP address of the network switch you won’t have access to log onto the operating system of the network switch. Without knowing the IP address [...]
View Answer
| April 19, 2013 10:07 PM
IP addressing, LAN, Switches
