accessing a password-protected hd
Did you try creating him as a user on your computer with that particular password and then logging in as him? The problem is that the encryption is done with a certificate that was on the original computer. If the drive you have also contains the system drive, check out the following from MSDN to [...]
View Answer
| October 24, 2006 8:58 PM
Application security, Biometrics, Database, Digital certificates, Encryption, Exchange, Identity & Access Management, Instant Messaging, Microsoft Windows, provisioning, Secure Coding, Security, Security tokens, Single sign-on, Software
Did you try creating him as a user on your computer with that particular password and then logging in as him? The problem is that the encryption is done with a certificate that was on the original computer. If the drive you have also contains the system drive, check out the following from MSDN to [...]
View Answer
| October 24, 2006 8:58 PM
Application security, Biometrics, Database, Digital certificates, Encryption, Exchange, Identity & Access Management, Instant Messaging, Microsoft Windows, provisioning, Secure Coding, Security, Security tokens, Single sign-on, Software
accessing password protected hd
I’ve had luck accessing data by using Knoppix. It boots and runs from the CD. Try going to the following link for more details. http://searchwincomputing.techtarget.com/tip/0,289483,sid68_gci1207497,00.html?bucket=ETA Good luck. Let us know how it turns out.
View Answer
| October 24, 2006 8:57 PM
Application security, Biometrics, Database, Digital certificates, Encryption, Exchange, Identity & Access Management, Instant Messaging, Microsoft Windows, provisioning, Secure Coding, Security, Security tokens, Single sign-on, Software
I’ve had luck accessing data by using Knoppix. It boots and runs from the CD. Try going to the following link for more details. http://searchwincomputing.techtarget.com/tip/0,289483,sid68_gci1207497,00.html?bucket=ETA Good luck. Let us know how it turns out.
View Answer
| October 24, 2006 8:57 PM
Application security, Biometrics, Database, Digital certificates, Encryption, Exchange, Identity & Access Management, Instant Messaging, Microsoft Windows, provisioning, Secure Coding, Security, Security tokens, Single sign-on, Software
Tools for DDS to DDL migration
You should not have to migrate your DDS to DDL or create special indexes. When running your SQL the system will look for similar LF’s or create an index on the fly using your where and order by statements. You can do SQL statements from the iSeries to get data off other platforms and should [...]
View Answer
| October 24, 2006 4:21 PM
Application development, Database, DB2, DB2 Universal Database, Oracle
You should not have to migrate your DDS to DDL or create special indexes. When running your SQL the system will look for similar LF’s or create an index on the fly using your where and order by statements. You can do SQL statements from the iSeries to get data off other platforms and should [...]
View Answer
| October 24, 2006 4:21 PM
Application development, Database, DB2, DB2 Universal Database, Oracle
Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g
If you can, start up the old 8i database and see if the application connects to it. That way you’ll at least know if something is still looking for the old one or if the error is caused by a misconfiguration with the new one.
View Answer
| October 24, 2006 3:14 PM
Architecture/Design, Backup & recovery, Data/Application Integration, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, SQL, Tech support, Windows
If you can, start up the old 8i database and see if the application connects to it. That way you’ll at least know if something is still looking for the old one or if the error is caused by a misconfiguration with the new one.
View Answer
| October 24, 2006 3:14 PM
Architecture/Design, Backup & recovery, Data/Application Integration, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, SQL, Tech support, Windows
VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition
I’m in the process of migrating to VB.Net from VB 6 and I’ve seen this functionality in the Express Ddition. From what I can tell the Express Edition is the same as the Pro Edition of VS 2005 without all the other tools of VS. Good luck.
View Answer
| October 24, 2006 8:13 AM
7 and earlier, Access, ASP.NET, Database, DataCenter, DB2, Desktops, Development, Lifecycle development, Management, Microsoft Office, Microsoft Windows, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle Database Versions, OS, Patch management, Programming Languages, Security, Servers, SQL, SQL Server, Visual Basic, Windows
I’m in the process of migrating to VB.Net from VB 6 and I’ve seen this functionality in the Express Ddition. From what I can tell the Express Edition is the same as the Pro Edition of VS 2005 without all the other tools of VS. Good luck.
View Answer
| October 24, 2006 8:13 AM
7 and earlier, Access, ASP.NET, Database, DataCenter, DB2, Desktops, Development, Lifecycle development, Management, Microsoft Office, Microsoft Windows, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle Database Versions, OS, Patch management, Programming Languages, Security, Servers, SQL, SQL Server, Visual Basic, Windows
Dos attack
Wanz hello, The first message means a public IP address (could be from any one of various registries) is trying to send a packet to a private IP address in your organization, in port 25 (SMTP). This does not necessarily indicate a DOS attack, and if the firewall is blocking the packet then it’s OK. [...]
View Answer
| October 22, 2006 4:20 AM
Access control, Application security, backdoors, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Wanz hello, The first message means a public IP address (could be from any one of various registries) is trying to send a packet to a private IP address in your organization, in port 25 (SMTP). This does not necessarily indicate a DOS attack, and if the firewall is blocking the packet then it’s OK. [...]
View Answer
| October 22, 2006 4:20 AM
Access control, Application security, backdoors, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Connect:Direct CDSND command
Hi Our organization is also using Connect Direct for file transfer from our AS400 to other servers. And as far as I have experienced using this application, you cannot set it up to send files as tab delimited. You will have to add tabs to your file before sending it and also, the other server [...]
View Answer
| October 21, 2006 3:12 AM
Application development, AS/400, CLP, DB2 Universal Database, PC/Windows Connectivity
Hi Our organization is also using Connect Direct for file transfer from our AS400 to other servers. And as far as I have experienced using this application, you cannot set it up to send files as tab delimited. You will have to add tabs to your file before sending it and also, the other server [...]
View Answer
| October 21, 2006 3:12 AM
Application development, AS/400, CLP, DB2 Universal Database, PC/Windows Connectivity
R2
I’m assuming your referring to Windows Server Longhorn, the next generation of server after Win2k3 Server. The answer is yes, it is compatible.
View Answer
| October 21, 2006 1:33 AM
Application security, Backup & recovery, Billing and customer care, Billing Support Systems, BlackBerry, Cabling, Database, DataCenter, DB2, Desktops, Development, Encryption, Exchange, Handheld, Hardware, Hewlett-Packard Application Server, Instant Messaging, Linux, Management, Microprocessors, Microsoft Windows, Networking, NIC, Oracle, OS, Palm OS, Power management, Printers, Remote management, Routers, Secure Coding, Security, Servers, Software, SQL Server, Storage, Tech support, Veritas, Windows Mobile, Wireless
I’m assuming your referring to Windows Server Longhorn, the next generation of server after Win2k3 Server. The answer is yes, it is compatible.
View Answer
| October 21, 2006 1:33 AM
Application security, Backup & recovery, Billing and customer care, Billing Support Systems, BlackBerry, Cabling, Database, DataCenter, DB2, Desktops, Development, Encryption, Exchange, Handheld, Hardware, Hewlett-Packard Application Server, Instant Messaging, Linux, Management, Microprocessors, Microsoft Windows, Networking, NIC, Oracle, OS, Palm OS, Power management, Printers, Remote management, Routers, Secure Coding, Security, Servers, Software, SQL Server, Storage, Tech support, Veritas, Windows Mobile, Wireless
dynamic visual basic form based on access database table
Have you looked at the listview control. it has many different styles that probably would fit the bill. it certainly would make programming it a lot easier.
View Answer
| October 18, 2006 4:07 PM
Access, Database, DB2, Development, Oracle, VBA, Visual Basic
Have you looked at the listview control. it has many different styles that probably would fit the bill. it certainly would make programming it a lot easier.
View Answer
| October 18, 2006 4:07 PM
Access, Database, DB2, Development, Oracle, VBA, Visual Basic
Alternate Collating Sequence
The problem is that ALTSEQ only changes the order in which records are returned. It will not make ‘A’ = ‘a’. To do that you need the TRNTBL keyword to force one or more fileds on all records (in that logical only) to be returned as upper or lower case. There is a system supplied [...]
View Answer
| October 10, 2006 7:56 AM
AS/400, DB2 Universal Database, RPG
The problem is that ALTSEQ only changes the order in which records are returned. It will not make ‘A’ = ‘a’. To do that you need the TRNTBL keyword to force one or more fileds on all records (in that logical only) to be returned as upper or lower case. There is a system supplied [...]
View Answer
| October 10, 2006 7:56 AM
AS/400, DB2 Universal Database, RPG
SQL update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.
Try the following: UPDATE table SET field = substr(FIELD,1,3)|| replace(substr(FIELD,4,2),'15','08')|| substr(FIELD,6,4);
View Answer
| April 19, 2013 12:07 PM
Data/Application Integration, Database, DB2, Oracle, Oracle 9i, Oracle administration, Oracle Business Applications, SQL
Try the following: UPDATE table SET field = substr(FIELD,1,3)|| replace(substr(FIELD,4,2),'15','08')|| substr(FIELD,6,4);
View Answer
| April 19, 2013 12:07 PM
Data/Application Integration, Database, DB2, Oracle, Oracle 9i, Oracle administration, Oracle Business Applications, SQL
Simple but not so
something like this: select * from table1 where Productkey not in (select productKey from Table2)
View Answer
| October 5, 2006 9:57 AM
Database, DB2, Development, Oracle, SQL, Web development tools
something like this: select * from table1 where Productkey not in (select productKey from Table2)
View Answer
| October 5, 2006 9:57 AM
Database, DB2, Development, Oracle, SQL, Web development tools
Running Syantec Antivirus on a Windows Domain Controller
As with any management software (F-Secure, Diskeeper, Etc.) you should be able to install it to a workstation or go virtual and run it on a virtual server.
View Answer
| October 5, 2006 3:09 AM
Access control, Application security, backdoors, Biometrics, Browsers, configuration, Current threats, Database, Desktops, Development, Digital certificates, Encryption, Exchange, filtering, Hacking, human factors, Identity & Access Management, Instant Messaging, Management, Microsoft Windows, Networking, OS, patching, PEN testing, Platform Security, provisioning, Secure Coding, Security, Security tokens, Servers, Single sign-on, Spyware, SQL Server, SSL/TLS, Trojans, Viruses, vulnerability management, Web security, worms
As with any management software (F-Secure, Diskeeper, Etc.) you should be able to install it to a workstation or go virtual and run it on a virtual server.
View Answer
| October 5, 2006 3:09 AM
Access control, Application security, backdoors, Biometrics, Browsers, configuration, Current threats, Database, Desktops, Development, Digital certificates, Encryption, Exchange, filtering, Hacking, human factors, Identity & Access Management, Instant Messaging, Management, Microsoft Windows, Networking, OS, patching, PEN testing, Platform Security, provisioning, Secure Coding, Security, Security tokens, Servers, Single sign-on, Spyware, SQL Server, SSL/TLS, Trojans, Viruses, vulnerability management, Web security, worms
The server with this database is no longer responding
Sounds like a Notes problem. Bump Notes by ending the domino server and restarting. It’s a hassle – but it could be the swiftest way to get things back on track. (Ala Microsoft answer)
View Answer
| September 29, 2006 11:33 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DB2 Universal Database, Lotus Domino, Printing, RPG, RPGLE, Security
Sounds like a Notes problem. Bump Notes by ending the domino server and restarting. It’s a hassle – but it could be the swiftest way to get things back on track. (Ala Microsoft answer)
View Answer
| September 29, 2006 11:33 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DB2 Universal Database, Lotus Domino, Printing, RPG, RPGLE, Security
MS Access database
If your end users have MS Access installed on their machines, then you could just have them link to the MDE file on the server via a windows shortcut. This method even supports having multiple users at a time.
View Answer
| May 9, 2013 11:39 AM
Microsoft Access, Microsoft Access database
If your end users have MS Access installed on their machines, then you could just have them link to the MDE file on the server via a windows shortcut. This method even supports having multiple users at a time.
View Answer
| May 9, 2013 11:39 AM
Microsoft Access, Microsoft Access database
error in connection between oracle8i&developer2000
You can definitely install Oracle8i Enterprise and Developer 2000 on the same machine. However, your tnsnames.ora file must contain the information necessary for Developer 2000 to connect with your database. With Oracle Developer 2000 on a PC there is usually a “SQL NET” program you can use to set this up automatically. Have you found [...]
View Answer
| September 18, 2006 12:27 PM
Architecture/Design, Availability, Backup & recovery, Database, DB2, Desktops, Interoperability, Management, Microsoft Windows, Oracle, Oracle 8i, Oracle administration, OS, Performance/Tuning, Servers, Software, SQL, SQL Server
You can definitely install Oracle8i Enterprise and Developer 2000 on the same machine. However, your tnsnames.ora file must contain the information necessary for Developer 2000 to connect with your database. With Oracle Developer 2000 on a PC there is usually a “SQL NET” program you can use to set this up automatically. Have you found [...]
View Answer
| September 18, 2006 12:27 PM
Architecture/Design, Availability, Backup & recovery, Database, DB2, Desktops, Interoperability, Management, Microsoft Windows, Oracle, Oracle 8i, Oracle administration, OS, Performance/Tuning, Servers, Software, SQL, SQL Server
career advice
Check out training in the ERP Industry Solution, IS-OIL.. Figure out if thats what you want to get yourself into.. g/l
View Answer
| September 18, 2006 7:53 AM
Basis, Career development, Certifications, CRM, Database, DB2, MySAP, Oracle, RPGLE, SAP, SAP careers, SQL, Training
Check out training in the ERP Industry Solution, IS-OIL.. Figure out if thats what you want to get yourself into.. g/l
View Answer
| September 18, 2006 7:53 AM
Basis, Career development, Certifications, CRM, Database, DB2, MySAP, Oracle, RPGLE, SAP, SAP careers, SQL, Training
CLOB and VARCHAR2
I would suggest you pose this question on the asktom site. Tom Kyte would be an excellent resource (from Oracle) to address this question. He was at the PHLOUG meeting last night and shared some excellent tips on 10g R1 & 2 of the database. http://asktom.oracle.com
View Answer
| September 14, 2006 6:43 AM
Database, DB2, Oracle
I would suggest you pose this question on the asktom site. Tom Kyte would be an excellent resource (from Oracle) to address this question. He was at the PHLOUG meeting last night and shared some excellent tips on 10g R1 & 2 of the database. http://asktom.oracle.com
View Answer
| September 14, 2006 6:43 AM
Database, DB2, Oracle
Installing Oracle 9i on Windows XP
You probably have a previous installation of Oracle that has not been removed, or a partial installation that you have to manually remove. backup your system, Make sure that Oracle is uninstalled, manually delete all directories created for Oracle, edit the environment variables to remove Oracle entries, edit the system registry to remove all Oracle [...]
View Answer
| September 13, 2006 10:45 AM
Database, DB2, Oracle
You probably have a previous installation of Oracle that has not been removed, or a partial installation that you have to manually remove. backup your system, Make sure that Oracle is uninstalled, manually delete all directories created for Oracle, edit the environment variables to remove Oracle entries, edit the system registry to remove all Oracle [...]
View Answer
| September 13, 2006 10:45 AM
Database, DB2, Oracle
Changing Server Name Where ORACLE is Loaded
Good morning, Sam. Well, it may not be quite that straight forward. Part will depend on the version of Oracle you’re using, which type(s) of SQL authentication, which platform you’re on, which modules you may have implemented (Apps, RAC, etc.) and lastly, your backup solution. (I’m probably missing some, but this is all I can [...]
View Answer
| September 13, 2006 8:52 AM
Database, DB2, Oracle
Good morning, Sam. Well, it may not be quite that straight forward. Part will depend on the version of Oracle you’re using, which type(s) of SQL authentication, which platform you’re on, which modules you may have implemented (Apps, RAC, etc.) and lastly, your backup solution. (I’m probably missing some, but this is all I can [...]
View Answer
| September 13, 2006 8:52 AM
Database, DB2, Oracle
