unrecognized data base format
hi, i had an application written with visual basic 6.0 with ms access data base (dao connection). it was installed on server using ms windows 2000 advanced server.i have two users,one of them uses windows 2000 & ms office 2000,the second uses windows xp & ms office xp. some times when the users enter data,suddenly [...]
Answer Question
| June 16, 2012 3:27 PM
Microsoft Access, Visual Basic
hi, i had an application written with visual basic 6.0 with ms access data base (dao connection). it was installed on server using ms windows 2000 advanced server.i have two users,one of them uses windows 2000 & ms office 2000,the second uses windows xp & ms office xp. some times when the users enter data,suddenly [...]
Answer Question
| June 16, 2012 3:27 PM
Microsoft Access, Visual Basic
Microsoft Access: Append Query problem
I have a table with a surrogate key created by Autonumber. I have data (in a linked spreadsheet) which I wish to append to that table. I would like to have the new data appended with automatically generated keys, but I cannot find how to do it (without writing a specific macro). If I try [...]
Answer Question
| January 26, 2005 6:35 AM
Access, Microsoft Access
I have a table with a surrogate key created by Autonumber. I have data (in a linked spreadsheet) which I wish to append to that table. I would like to have the new data appended with automatically generated keys, but I cannot find how to do it (without writing a specific macro). If I try [...]
Answer Question
| January 26, 2005 6:35 AM
Access, Microsoft Access
Deleting journal receivers
HI, When I try to delete a journal receiver that hasn’t been saved, I get the “never fully saved” message even though I’m using DLTOPT(*IGNINQMSG) Does anyone have a piece of code that will get rid of receivers no matter what? E.G. not saved, remote, attached…… Thanks
Answer Question
| October 11, 2010 11:04 AM
Backup & recovery, Database Management Systems, DB2, DB2 administration, Hardware, i5, iSeries, OS/400, Performance/Tuning, Servers, tips and tricks, Tools
HI, When I try to delete a journal receiver that hasn’t been saved, I get the “never fully saved” message even though I’m using DLTOPT(*IGNINQMSG) Does anyone have a piece of code that will get rid of receivers no matter what? E.G. not saved, remote, attached…… Thanks
Answer Question
| October 11, 2010 11:04 AM
Backup & recovery, Database Management Systems, DB2, DB2 administration, Hardware, i5, iSeries, OS/400, Performance/Tuning, Servers, tips and tricks, Tools
Restricted access to win XP professional
I have a small WORKGROUP with windows 2000 server and 5 windows XP professional systems. All computers can read/write each other. Now I want to make one XP client secure/restric access, so that no other computer can access that except only other XP computer. How can I do that? Please advise. Thanks in advance!
Answer Question
| December 29, 2004 2:48 AM
Administration, Application security, Compliance, CRM, Database, DataCenter, Desktop management applications, DHCP, Disaster Recovery, DNS, Encryption, Exchange, Firewalls, Forensics, Help Desk, Implementation, Incident response, Information risk management, Instant Messaging, Intrusion management, Management, Network monitoring, Network security, Networking, Networking services, Physical security, Policies, Remote management, Remote users, Risk management, Secure Coding, Security, Security management, Security Program Management, Servers, System utilities, Tech support, Third-party services, VPN, Windows, Windows 2000 Server, Wireless
I have a small WORKGROUP with windows 2000 server and 5 windows XP professional systems. All computers can read/write each other. Now I want to make one XP client secure/restric access, so that no other computer can access that except only other XP computer. How can I do that? Please advise. Thanks in advance!
Answer Question
| December 29, 2004 2:48 AM
Administration, Application security, Compliance, CRM, Database, DataCenter, Desktop management applications, DHCP, Disaster Recovery, DNS, Encryption, Exchange, Firewalls, Forensics, Help Desk, Implementation, Incident response, Information risk management, Instant Messaging, Intrusion management, Management, Network monitoring, Network security, Networking, Networking services, Physical security, Policies, Remote management, Remote users, Risk management, Secure Coding, Security, Security management, Security Program Management, Servers, System utilities, Tech support, Third-party services, VPN, Windows, Windows 2000 Server, Wireless
Triggers
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks
Answer Question
| October 19, 2009 2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks
Answer Question
| October 19, 2009 2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
Triggers
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks
Answer Question
| December 27, 2004 2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks
Answer Question
| December 27, 2004 2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
vpn through s-box firewall of checkpoint
i’m try to create a vpn from the internet to my “small buisness server 2003″ that act as vpn server without any luck, if i try to connect to my server from the internal network it’s work just fine, iv’e mapped the correct ports according to the microsoft article that say to forward port 1723 [...]
Answer Question
| June 29, 2012 6:01 PM
Administration, Application security, Architecture/Design, Database, Documentation, Encryption, Exchange, Features/Functionality, Firewalls, Forensics, Help Desk, Implementation, Incident response, Installation, Instant Messaging, Intrusion management, IT architecture, Knowledge management applications, Network security, Planning, Secure Coding, Security, Security management, Security products, Service and support, Spam, VPN, Wireless
i’m try to create a vpn from the internet to my “small buisness server 2003″ that act as vpn server without any luck, if i try to connect to my server from the internal network it’s work just fine, iv’e mapped the correct ports according to the microsoft article that say to forward port 1723 [...]
Answer Question
| June 29, 2012 6:01 PM
Administration, Application security, Architecture/Design, Database, Documentation, Encryption, Exchange, Features/Functionality, Firewalls, Forensics, Help Desk, Implementation, Incident response, Installation, Instant Messaging, Intrusion management, IT architecture, Knowledge management applications, Network security, Planning, Secure Coding, Security, Security management, Security products, Service and support, Spam, VPN, Wireless
Microsoft: Active Directory Migration Tool (ADMT)
Hi, I want to migrate a couple of users, computers and groups from an Windows NT 4.0 Domain to Active Directory (Windows 2003 NATIVE MODE Domain). The migration is not for the entire NT Domain, is only a group of users and computers from this one. I had used ADMT on a single forest to [...]
Answer Question
| December 25, 2004 11:01 AM
Active Directory, Administration, Application management, Application software, Backup, Client management, Clustering/High availability, Database issues, DataCenter, DataManagement, DHCP, Disaster Recovery, DNS, Exchange, Exchange 2003, Exchange 5.5, Help Desk, Installation, LDAP, Lotus Domino, Maintenance, Microsoft Windows, Migration, Networking services, Outlook, Software testing, Software testing tools, Storage management, Tech support, Third-party services, Vendor support
Hi, I want to migrate a couple of users, computers and groups from an Windows NT 4.0 Domain to Active Directory (Windows 2003 NATIVE MODE Domain). The migration is not for the entire NT Domain, is only a group of users and computers from this one. I had used ADMT on a single forest to [...]
Answer Question
| December 25, 2004 11:01 AM
Active Directory, Administration, Application management, Application software, Backup, Client management, Clustering/High availability, Database issues, DataCenter, DataManagement, DHCP, Disaster Recovery, DNS, Exchange, Exchange 2003, Exchange 5.5, Help Desk, Installation, LDAP, Lotus Domino, Maintenance, Microsoft Windows, Migration, Networking services, Outlook, Software testing, Software testing tools, Storage management, Tech support, Third-party services, Vendor support
How to purge records from the database?
I am a newbie to database programming and have been given this project where data older than 7 days need to be removed from multiple tables that the application uses. I am thinking about creating a stored procedure to do that and schedule a job that will run this stored procedure everyday. Not sure if [...]
Answer Question
| December 21, 2004 4:42 PM
Database, DB2, Implementation, Oracle, SQL, SQL Server, T-SQL, Tech support
I am a newbie to database programming and have been given this project where data older than 7 days need to be removed from multiple tables that the application uses. I am thinking about creating a stored procedure to do that and schedule a job that will run this stored procedure everyday. Not sure if [...]
Answer Question
| December 21, 2004 4:42 PM
Database, DB2, Implementation, Oracle, SQL, SQL Server, T-SQL, Tech support
Stored Procedure Error
This is mu stored Procedure: CREATE PROCEDURE ADMINISTRATOR.DIMS_SP_PerformSearch ( vuserId integer, vsearchText varchar(500) , vfromID integer, voption integer ) ———————————————————————— – SQL Stored Procedure ———————————————————————— BEGIN IF (vsearchText != ”) THEN delete from DIMS_General_Search where userId = vuserId; end if; IF (voption = 0) THEN INSERT INTO DIMS_General_Search SELECT vuserId,DIMS_Scanned_Transaction.scanned_date , DIMS_Document_Type.document_type_name , DIMS_Document_type_Attributes.attribute_name,DIMS_Scanned_transaction_Detail.answer, DIMS_Scanned_Transaction.scanned_transaction_id [...]
Answer Question
| December 17, 2004 2:20 AM
Application software, Availability, DB2 Everyplace, Development, IBM, Instant Messaging, Java, Migration, Modeling, Normalization, Performance/Tuning, Servers, WebSphere Studio
This is mu stored Procedure: CREATE PROCEDURE ADMINISTRATOR.DIMS_SP_PerformSearch ( vuserId integer, vsearchText varchar(500) , vfromID integer, voption integer ) ———————————————————————— – SQL Stored Procedure ———————————————————————— BEGIN IF (vsearchText != ”) THEN delete from DIMS_General_Search where userId = vuserId; end if; IF (voption = 0) THEN INSERT INTO DIMS_General_Search SELECT vuserId,DIMS_Scanned_Transaction.scanned_date , DIMS_Document_Type.document_type_name , DIMS_Document_type_Attributes.attribute_name,DIMS_Scanned_transaction_Detail.answer, DIMS_Scanned_Transaction.scanned_transaction_id [...]
Answer Question
| December 17, 2004 2:20 AM
Application software, Availability, DB2 Everyplace, Development, IBM, Instant Messaging, Java, Migration, Modeling, Normalization, Performance/Tuning, Servers, WebSphere Studio
Monitor Internet Bandwidth
Good day, we are using windows2000 smallbusiness server in our organisation with Exchange,Dns and Isa server configured. 1. I want to monitor the internet usage by the users. 2. I want to take a report on monthly or daily basis how much mb/gb utilised By Each User. Thanks for u’r reply in advance.
Answer Question
| December 29, 2004 1:55 AM
Active Directory, Administration, Application management, Auditing, Availability, Backup, Backup & recovery, Bandwidth, Benchmarking, Bind, BroadVision, Business Objects, Call Centers, Clarify Inc., CLB, Client management, Clustering/High availability, Component Load Balancing, Content filtering, Corporate portal applications, Customer relationship management applications, Data analysis, Data center operations, Data mining/analysis, Data warehousing/Business intelligence, Database Management Systems, DataCenter, Datacenter Server, DB2 administration, Desktop security, Desktops, DHCP, Distributed File System, DNS, E-business, E-mail applications, ERP, Exchange, Exchange 2000, Exchange 2003, Exchange 5.5, Exchange Server ActiveSync, FAT and NTFS, Fault isolation, Firewalls, General Directories, Graphical User Interfaces, Handheld, Hardware, Help Desk, Information risk management, Integration/Connectivity, Intel servers, IT architecture, Knowledge management applications, Licensing, Lotus Domino, Mail protocols, Maintenance, Major Vendors, Microsoft Internet Information Server, Microsoft Windows, Monitoring, Netscape Mail, Network applications management, Network management software, Network monitoring, Network requirements, Network testing, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Operating systems, Outlook, PC/Windows Connectivity, Performance management, Performance/Tuning, Planning, Policies, POP3, Protocol analysis, Remote management, Reporting, ROI & cost justification, Routers, S/MIME, Security, Security management, Security products, Sendmail, Server consolidation, Server management, Server-based/Thin-client computing, Servers, Services, Software, Software distribution, Software Quality Assurance, Spam, Storage, System monitoring, System utilities, Tech support, Technical support, Third-party services, Vendor support, Virus protection, Web services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance, Windows on Intel, Windows Server 2003
Good day, we are using windows2000 smallbusiness server in our organisation with Exchange,Dns and Isa server configured. 1. I want to monitor the internet usage by the users. 2. I want to take a report on monthly or daily basis how much mb/gb utilised By Each User. Thanks for u’r reply in advance.
Answer Question
| December 29, 2004 1:55 AM
Active Directory, Administration, Application management, Auditing, Availability, Backup, Backup & recovery, Bandwidth, Benchmarking, Bind, BroadVision, Business Objects, Call Centers, Clarify Inc., CLB, Client management, Clustering/High availability, Component Load Balancing, Content filtering, Corporate portal applications, Customer relationship management applications, Data analysis, Data center operations, Data mining/analysis, Data warehousing/Business intelligence, Database Management Systems, DataCenter, Datacenter Server, DB2 administration, Desktop security, Desktops, DHCP, Distributed File System, DNS, E-business, E-mail applications, ERP, Exchange, Exchange 2000, Exchange 2003, Exchange 5.5, Exchange Server ActiveSync, FAT and NTFS, Fault isolation, Firewalls, General Directories, Graphical User Interfaces, Handheld, Hardware, Help Desk, Information risk management, Integration/Connectivity, Intel servers, IT architecture, Knowledge management applications, Licensing, Lotus Domino, Mail protocols, Maintenance, Major Vendors, Microsoft Internet Information Server, Microsoft Windows, Monitoring, Netscape Mail, Network applications management, Network management software, Network monitoring, Network requirements, Network testing, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Operating systems, Outlook, PC/Windows Connectivity, Performance management, Performance/Tuning, Planning, Policies, POP3, Protocol analysis, Remote management, Reporting, ROI & cost justification, Routers, S/MIME, Security, Security management, Security products, Sendmail, Server consolidation, Server management, Server-based/Thin-client computing, Servers, Services, Software, Software distribution, Software Quality Assurance, Spam, Storage, System monitoring, System utilities, Tech support, Technical support, Third-party services, Vendor support, Virus protection, Web services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance, Windows on Intel, Windows Server 2003
Database Project Definiton
A corporation has decided to move its production data off the OS 390 platform to a windows platform running the windows data center operating system. *There are 18 terabytes of data of mission critical data that needs to be available 24 hrs a day. *Because of the size of the customer database they need to [...]
Answer Question
| August 22, 2008 10:40 PM
Database architectures, Database design
A corporation has decided to move its production data off the OS 390 platform to a windows platform running the windows data center operating system. *There are 18 terabytes of data of mission critical data that needs to be available 24 hrs a day. *Because of the size of the customer database they need to [...]
Answer Question
| August 22, 2008 10:40 PM
Database architectures, Database design
Moving spool files from one AS400 to another
I’m having a problem retaining the spool file attributes when I tranfer spool files from one ISeries to another. I can use the SNDTCPSPLF and it retains most of the attributes but does not retain the user and date/time attributes of the original spool file. Any suggestions??
Answer Question
| November 26, 2009 5:47 AM
AS/400, Backup & recovery, DB2, DB2 administration, DB2 Implementation, Hardware, Installation/Upgrades, Migration, Tech support, UDB for iSeries/i5
I’m having a problem retaining the spool file attributes when I tranfer spool files from one ISeries to another. I can use the SNDTCPSPLF and it retains most of the attributes but does not retain the user and date/time attributes of the original spool file. Any suggestions??
Answer Question
| November 26, 2009 5:47 AM
AS/400, Backup & recovery, DB2, DB2 administration, DB2 Implementation, Hardware, Installation/Upgrades, Migration, Tech support, UDB for iSeries/i5
How do I check for changes in a database on insert / update?
Hi there, I have an interesting problem. I need to write a program that checks to see if data has been inserted or updated into a Microsoft access database or sql server database. The program needs to be compatible with both types of database, so using triggers is not possible as it wont work in [...]
Answer Question
| December 17, 2004 3:08 AM
Microsoft Access, SQL Server, VB.NET, Visual Basic
Hi there, I have an interesting problem. I need to write a program that checks to see if data has been inserted or updated into a Microsoft access database or sql server database. The program needs to be compatible with both types of database, so using triggers is not possible as it wont work in [...]
Answer Question
| December 17, 2004 3:08 AM
Microsoft Access, SQL Server, VB.NET, Visual Basic
DB2/400 SQL Sub Query Performance?
Here is the problem. Table INVEHH is a (Events header table) with about 500 records and INVEHD (Event Details) with about 22 million records. These tables are on a DB2/400 database. 1) Original Query that takes forever: select EVENT, INUMBR, ISTORE, EVHYY, EVHMM, EVHDD from INVEHD where EVENT in (Select EVENT from INVEHH where (EVHYY*10000 [...]
Answer Question
| October 20, 2009 8:40 AM
Data warehousing/Business intelligence, Database Management Systems, DB2, DB2 Universal Database, UDB for iSeries/i5
Here is the problem. Table INVEHH is a (Events header table) with about 500 records and INVEHD (Event Details) with about 22 million records. These tables are on a DB2/400 database. 1) Original Query that takes forever: select EVENT, INUMBR, ISTORE, EVHYY, EVHMM, EVHDD from INVEHD where EVENT in (Select EVENT from INVEHH where (EVHYY*10000 [...]
Answer Question
| October 20, 2009 8:40 AM
Data warehousing/Business intelligence, Database Management Systems, DB2, DB2 Universal Database, UDB for iSeries/i5
Oracle In Linux
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.
Answer Question
| June 15, 2010 1:41 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.
Answer Question
| June 15, 2010 1:41 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS
Starting isql*plus
Hi every one! I know that to start isql*plus in a browser, you are supposed to type something like: http://localhost:<port_number>/isqlplus Problem is, how do you determine the localhost and port number? Second, how can i use Enterprise manager to create reports about my tables in the Oracle database? Thanx.
Answer Question
| September 29, 2004 6:48 PM
Database issues, Database Management Systems, in use in organization, s, Total size of the database, Very Large Databases
Hi every one! I know that to start isql*plus in a browser, you are supposed to type something like: http://localhost:<port_number>/isqlplus Problem is, how do you determine the localhost and port number? Second, how can i use Enterprise manager to create reports about my tables in the Oracle database? Thanx.
Answer Question
| September 29, 2004 6:48 PM
Database issues, Database Management Systems, in use in organization, s, Total size of the database, Very Large Databases
oracle internet directory application developer’s guide — dbms_ldap_utl sample code doesn’t work
Hi, all I’m trying to set up Oracle Internet Directory Rel 9. I’m trying to use APIs provided in Application Developer’s Guide. I started by copying and trying to run the examples given in the guide. My procedure connects to LDAP, authenticates me, but won’t create a user. (Actually, it passes the create_user_heandle procedure, but [...]
Answer Question
| November 10, 2010 1:31 PM
Application security, Biometrics, Database, Development, Digital certificates, Encryption, Exchange, Identity & Access Management, Instant Messaging, Oracle, provisioning, Secure Coding, Security, Security tokens, Single sign-on, SQL
Hi, all I’m trying to set up Oracle Internet Directory Rel 9. I’m trying to use APIs provided in Application Developer’s Guide. I started by copying and trying to run the examples given in the guide. My procedure connects to LDAP, authenticates me, but won’t create a user. (Actually, it passes the create_user_heandle procedure, but [...]
Answer Question
| November 10, 2010 1:31 PM
Application security, Biometrics, Database, Development, Digital certificates, Encryption, Exchange, Identity & Access Management, Instant Messaging, Oracle, provisioning, Secure Coding, Security, Security tokens, Single sign-on, SQL
Error when tried to update the SSOledbGrid connected to with Sybase Server Database
I have a visual basic 6.0 application with connect to Sybase Server 11 with OBDC Driver ?Sybase System 11?. In VB application use ADO 2.8 for update a table with two fields (Integer, Varchar(10)), the SSOledbgrid return error ?16389? to update or add a register. Show error when I tried to update the varchar field. [...]
Answer Question
| July 16, 2004 3:25 PM
ActiveX, Adaptive Server Enterprise, Database, DB2, Development, Oracle, Servers, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Sybase, Sybase EAServer, Visual Basic
I have a visual basic 6.0 application with connect to Sybase Server 11 with OBDC Driver ?Sybase System 11?. In VB application use ADO 2.8 for update a table with two fields (Integer, Varchar(10)), the SSOledbgrid return error ?16389? to update or add a register. Show error when I tried to update the varchar field. [...]
Answer Question
| July 16, 2004 3:25 PM
ActiveX, Adaptive Server Enterprise, Database, DB2, Development, Oracle, Servers, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Sybase, Sybase EAServer, Visual Basic
MySQL CrossTab Query
MySQL does not have a crosstab query. Does anyone have some code that will return a datastructure on a crosstab query?
Answer Question
| June 8, 2004 7:02 AM
MySQL, PHP, VBA
MySQL does not have a crosstab query. Does anyone have some code that will return a datastructure on a crosstab query?
Answer Question
| June 8, 2004 7:02 AM
MySQL, PHP, VBA
