Sponsor Post: Fear the Cloud? Migration Pros and Cons (on-demand chat from 6/29/2010)
I hope this was a good session. We are involved in providing online backup services to our clients. One of the things many businesses are looking for now is the ability to convert a backup disk image into a virtual machine image. This allows for quick deployment of the backup to a cloud based virtual [...]
View Answer
| July 22, 2010 1:44 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, datamangement, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
I hope this was a good session. We are involved in providing online backup services to our clients. One of the things many businesses are looking for now is the ability to convert a backup disk image into a virtual machine image. This allows for quick deployment of the backup to a cloud based virtual [...]
View Answer
| July 22, 2010 1:44 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, datamangement, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
No Activity Time Out Session
There is the cheap and easy way that isn’t as precise as many would like and a choice of either a very difficult way or a potentially costly way but both with significant precision. Cheap and easy is by setting the QINACTITV system value to 60 along with setting the QINACTMSGQ system value to be [...]
View Answer
| July 21, 2010 9:33 PM
5250 session, AS/400, iSeries, Timeout
There is the cheap and easy way that isn’t as precise as many would like and a choice of either a very difficult way or a potentially costly way but both with significant precision. Cheap and easy is by setting the QINACTITV system value to 60 along with setting the QINACTMSGQ system value to be [...]
View Answer
| July 21, 2010 9:33 PM
5250 session, AS/400, iSeries, Timeout
Databases vs. Data Structures
You are recruiting for this company and you don’t want them to know that you don’t know what it is you are supposed to be looking for. Tough situation. Data structures are the way the data is stored. Even a DBMS or an RDBMS has a “structure” In one sense, data structures have algorithms built [...]
View Answer
| July 20, 2010 7:04 PM
Data Area Data Structure, Data management, Data structures, Database design, Database servers, Databases
You are recruiting for this company and you don’t want them to know that you don’t know what it is you are supposed to be looking for. Tough situation. Data structures are the way the data is stored. Even a DBMS or an RDBMS has a “structure” In one sense, data structures have algorithms built [...]
View Answer
| July 20, 2010 7:04 PM
Data Area Data Structure, Data management, Data structures, Database design, Database servers, Databases
Complete step of ASE15 Migration from ASE12.5
Hi Rameshsaai, According to <a href=”http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc00712_1500/html/mrx150db/CHDEAGBJ.htm”>Sybase’s site</a>, you need to verify that the Mirror Replication Agent is quiesced prior to migrating from Sybase ASE 12.5 to ASE 15.0. And you’ll need to refer to the Release Bulletin for the Mirror Replication Agent. I hope this helps. Em
View Answer
| July 19, 2010 3:00 PM
Adaptive Server Enterprise, Data management software, Sybase ASE 15, Sybase Databases
Hi Rameshsaai, According to <a href=”http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc00712_1500/html/mrx150db/CHDEAGBJ.htm”>Sybase’s site</a>, you need to verify that the Mirror Replication Agent is quiesced prior to migrating from Sybase ASE 12.5 to ASE 15.0. And you’ll need to refer to the Release Bulletin for the Mirror Replication Agent. I hope this helps. Em
View Answer
| July 19, 2010 3:00 PM
Adaptive Server Enterprise, Data management software, Sybase ASE 15, Sybase Databases
Database structure and application outsource protocol
If the contract says so, then yes, otherwise, maybe not. There are some technical details that clients might not want/need to know. Sometimes a high level architectural design may suffice. But, whether it has to be shared with the client or not, depends on what has been agreed. ———————
View Answer
| July 16, 2010 6:18 PM
Application development, Database design, Database Development, Database structure, SDLC, Software Development Process
If the contract says so, then yes, otherwise, maybe not. There are some technical details that clients might not want/need to know. Sometimes a high level architectural design may suffice. But, whether it has to be shared with the client or not, depends on what has been agreed. ———————
View Answer
| July 16, 2010 6:18 PM
Application development, Database design, Database Development, Database structure, SDLC, Software Development Process
What is the code that links vb 6.0 to Ms Access and how to go about it?
Some snippets here…. Also a <a href=”http://www.vbexplorer.com/VBExplorer/vb_feature/june2000/Database_Beginner_ADO_DAO.asp”>good help</a> From Mgi: <pre> Public conMyDB As New ADODB.Connection »»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»» Private Sub Form_Load() Dim rsTemp As New ADODB.Recordset If conMyDB.State = adStateClosed Then Call ConnectToMyDB End If rsTemp.Open “SELECT SomeFields FROM SomeTable”, conMyDB, adOpenDynamic, adLockOptimistic End Sub Public Sub ConnectToMyDB() If conMyDB.State <> adStateOpen Then conMyDB.Open “Driver={Microsoft Access [...]
View Answer
| July 15, 2010 7:02 PM
Access Database, Microsoft Access, VB Code, Visual Basic 6
Some snippets here…. Also a <a href=”http://www.vbexplorer.com/VBExplorer/vb_feature/june2000/Database_Beginner_ADO_DAO.asp”>good help</a> From Mgi: <pre> Public conMyDB As New ADODB.Connection »»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»»» Private Sub Form_Load() Dim rsTemp As New ADODB.Recordset If conMyDB.State = adStateClosed Then Call ConnectToMyDB End If rsTemp.Open “SELECT SomeFields FROM SomeTable”, conMyDB, adOpenDynamic, adLockOptimistic End Sub Public Sub ConnectToMyDB() If conMyDB.State <> adStateOpen Then conMyDB.Open “Driver={Microsoft Access [...]
View Answer
| July 15, 2010 7:02 PM
Access Database, Microsoft Access, VB Code, Visual Basic 6
Need to save dates in Oracle Forms 10g without modifying data values
Make sure your :MAIN_BLOCK.USER_DATE item’s data type is DATETIME and not DATE. DATE items don’t store a time component.
View Answer
| July 15, 2010 4:55 PM
Database management, Oracle 10g Database, Oracle 11g Database, Oracle Forms 10g
Make sure your :MAIN_BLOCK.USER_DATE item’s data type is DATETIME and not DATE. DATE items don’t store a time component.
View Answer
| July 15, 2010 4:55 PM
Database management, Oracle 10g Database, Oracle 11g Database, Oracle Forms 10g
pagination using MySql
Typically, you would do that using the LIMIT clause, which can take 2 arguments the first being the offset of the first record to return, and the second being the number of records to return. Some examples: This would return the first 15 records from yourTable: <pre>SELECT * FROM yourTable LIMIT 0,15;</pre> And this would [...]
View Answer
| July 13, 2010 6:18 PM
MySQL, MySQL query, Pagination
Typically, you would do that using the LIMIT clause, which can take 2 arguments the first being the offset of the first record to return, and the second being the number of records to return. Some examples: This would return the first 15 records from yourTable: <pre>SELECT * FROM yourTable LIMIT 0,15;</pre> And this would [...]
View Answer
| July 13, 2010 6:18 PM
MySQL, MySQL query, Pagination
Need help with documentation on a time tracker project
There are several types of documentation; end user (how to use it) doc, technical (how does it work in detail) doc, over view (how does it work) doc, individual program doc, procedural doc, data flow doc (data movement without details on its transformation), … You should find out if your work place has any standards [...]
View Answer
| July 13, 2010 1:17 PM
C# .NET, MySQL documentation, MySQL functions, MySQL query
There are several types of documentation; end user (how to use it) doc, technical (how does it work in detail) doc, over view (how does it work) doc, individual program doc, procedural doc, data flow doc (data movement without details on its transformation), … You should find out if your work place has any standards [...]
View Answer
| July 13, 2010 1:17 PM
C# .NET, MySQL documentation, MySQL functions, MySQL query
From KPO Background, How about future ?
SearchSAP has a whole section on <a href=”http://searchsap.techtarget.com/resources/SAP-training-and-certification-strategy”>SAP training and certification strategy </a>that you should check out. SearchOracle also has a great <a href=”http://searchoracle.techtarget.com/resources/Oracle-jobs-careers-and-resources”>Oracle career section</a>.
View Answer
| July 12, 2010 3:04 PM
Careers, IT careers, SAP careers, SAP Finance
SearchSAP has a whole section on <a href=”http://searchsap.techtarget.com/resources/SAP-training-and-certification-strategy”>SAP training and certification strategy </a>that you should check out. SearchOracle also has a great <a href=”http://searchoracle.techtarget.com/resources/Oracle-jobs-careers-and-resources”>Oracle career section</a>.
View Answer
| July 12, 2010 3:04 PM
Careers, IT careers, SAP careers, SAP Finance
Oracle Financials
Search SAP has tips on <a href=”http://searchsap.techtarget.com/resources/SAP-training-and-certification-strategy”>SAP training and certification strategies</a>. You can also get advice from the experts at SearchOracle on <a href=”http://searchoracle.techtarget.com/answer/Pursuing-a-career-in-Oracle-Financials”>pursuing a career in Oracle Financials</a>.
View Answer
| July 12, 2010 2:46 PM
Careers, IT careers, Oracle Careers, Oracle certifications, Oracle Financials, SAP careers, SAP certifications
Search SAP has tips on <a href=”http://searchsap.techtarget.com/resources/SAP-training-and-certification-strategy”>SAP training and certification strategies</a>. You can also get advice from the experts at SearchOracle on <a href=”http://searchoracle.techtarget.com/answer/Pursuing-a-career-in-Oracle-Financials”>pursuing a career in Oracle Financials</a>.
View Answer
| July 12, 2010 2:46 PM
Careers, IT careers, Oracle Careers, Oracle certifications, Oracle Financials, SAP careers, SAP certifications
Index with page numbers in Access
Are you sure this directory will be static for individuals listed, and order, and that no person’s entry will take more than one page?
View Answer
| July 8, 2010 4:14 AM
Access Forms Database, Access Functions, Document management
Are you sure this directory will be static for individuals listed, and order, and that no person’s entry will take more than one page?
View Answer
| July 8, 2010 4:14 AM
Access Forms Database, Access Functions, Document management
Sponsor Post: Cloud Migration Pros and Cons Live Chat Today
Suggest to try on Microsoft Online Service that is a business-class communications and collaboration software offering delivered as a subscription service, hosted by Microsoft, and sold with partners. These services help make it easier for customers to rapidly and cost-effectively access the most up-to-date technologies, and are designed for rapid deployment to provide customers with [...]
View Answer
| July 8, 2010 2:53 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, datamangement, Development, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Suggest to try on Microsoft Online Service that is a business-class communications and collaboration software offering delivered as a subscription service, hosted by Microsoft, and sold with partners. These services help make it easier for customers to rapidly and cost-effectively access the most up-to-date technologies, and are designed for rapid deployment to provide customers with [...]
View Answer
| July 8, 2010 2:53 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, datamangement, Development, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
How to connect to database inside VMWare from the web applications
If you configured the VM’s network connection as ‘bridged’, you should be able to connect to the database from any network location as if it were running on a physical machine.
View Answer
| July 7, 2010 1:44 PM
DSN connection, Java Database, JDBC, Oracle Database, VMware, Web Dynpro
If you configured the VM’s network connection as ‘bridged’, you should be able to connect to the database from any network location as if it were running on a physical machine.
View Answer
| July 7, 2010 1:44 PM
DSN connection, Java Database, JDBC, Oracle Database, VMware, Web Dynpro
Find and replace text in text file using MS Access VBA
The text is being replaced in your MyString memory variable, but you never write the modified string to the file. You could do it creating a new file (opening it for writing) and writing each line of text you read from your original file after the needed replacement; or you could read the complete file, [...]
View Answer
| May 8, 2013 12:24 AM
Access 2000, Access VBA, VBA editor, Visual Basic for Applications, XML File Creation
The text is being replaced in your MyString memory variable, but you never write the modified string to the file. You could do it creating a new file (opening it for writing) and writing each line of text you read from your original file after the needed replacement; or you could read the complete file, [...]
View Answer
| May 8, 2013 12:24 AM
Access 2000, Access VBA, VBA editor, Visual Basic for Applications, XML File Creation
Oracle-developers
When you subtract two TIMESTAMP columns you get a time difference, not a date, and the resulting data type is INTERVAL DAY(x) TO SECOND(y). You could add this result to another TIMESTAMP to get a TIMESTAMP result, but I’m not sure why you would want to do that. You might want to provide some example [...]
View Answer
| July 6, 2010 2:31 PM
Oracle applications, Oracle developers, Timestamp, TOAD
When you subtract two TIMESTAMP columns you get a time difference, not a date, and the resulting data type is INTERVAL DAY(x) TO SECOND(y). You could add this result to another TIMESTAMP to get a TIMESTAMP result, but I’m not sure why you would want to do that. You might want to provide some example [...]
View Answer
| July 6, 2010 2:31 PM
Oracle applications, Oracle developers, Timestamp, TOAD
JDBC Connection from JAVA to iSeries DB
Hi, If your class file is in your local PC and using RAD java perspective, you can run your class. RAD’s java perspective is a Java SE development tool, you don’t need to set the class path in general. Do you have your java project setup in RAD ? Are you calling your java class [...]
View Answer
| June 30, 2010 7:45 AM
Java, Java Database Connectivity, JDBC, Rational Developer for IBM i
Hi, If your class file is in your local PC and using RAD java perspective, you can run your class. RAD’s java perspective is a Java SE development tool, you don’t need to set the class path in general. Do you have your java project setup in RAD ? Are you calling your java class [...]
View Answer
| June 30, 2010 7:45 AM
Java, Java Database Connectivity, JDBC, Rational Developer for IBM i
How can I write a SQL query to get the database name ?
Are you trying to get the instance name? That can be gotten by running <pre>SELECT @@SERVERNAME</pre> If you are trying to get the database name, you already have the code to get that.
View Answer
| June 29, 2010 7:38 PM
Database name, SQL 2008, SQL Database, SQL Query
Are you trying to get the instance name? That can be gotten by running <pre>SELECT @@SERVERNAME</pre> If you are trying to get the database name, you already have the code to get that.
View Answer
| June 29, 2010 7:38 PM
Database name, SQL 2008, SQL Database, SQL Query
Linking users of Access 2003 to SQL Server 2008 database
Yes you can use a 32bit driver to connect to a 64bit SQL Server.
View Answer
| June 28, 2010 9:22 PM
Access 2003, SQL Server 2008, SQL Server database, SQL Server Management, SQL Server Migration Assistant
Yes you can use a 32bit driver to connect to a 64bit SQL Server.
View Answer
| June 28, 2010 9:22 PM
Access 2003, SQL Server 2008, SQL Server database, SQL Server Management, SQL Server Migration Assistant
ORA-00902 invalid datatype when trying to create a table with primary key based on two columns in Oracle 10g
Change the constraint declaration. It should be: <pre>CONSTRAINT security_password_pk PRIMARY KEY (user_name,user_password)</pre> (No underscore between PRIMARY and KEY) And, as Mrdenny suggests, don’t inlcude the password in the PK (if you do it won’t cause errors when creating the table, but it would nullify the purpose of the pk).
View Answer
| June 25, 2010 6:16 PM
CREATE TABLE statement, Database issues, Oracle 10.2.0.4, Oracle 10g error messages, Oracle Table
Change the constraint declaration. It should be: <pre>CONSTRAINT security_password_pk PRIMARY KEY (user_name,user_password)</pre> (No underscore between PRIMARY and KEY) And, as Mrdenny suggests, don’t inlcude the password in the PK (if you do it won’t cause errors when creating the table, but it would nullify the purpose of the pk).
View Answer
| June 25, 2010 6:16 PM
CREATE TABLE statement, Database issues, Oracle 10.2.0.4, Oracle 10g error messages, Oracle Table
