In-Memory Processing Storage options
No matter what in memory system you get you have to write the data to disk at some point, otherwise when the server reboots or fails you’ve lost your data. How large is your database, and what problems are you seeing? Personally I’ve got a 1 TB OLTP database serving 45k users daily without any [...]
View Answer
| April 7, 2010 5:37 PM
In-Memory Database, Microsoft Office, Microsoft Vista, Relational database management systems, Relational databases
No matter what in memory system you get you have to write the data to disk at some point, otherwise when the server reboots or fails you’ve lost your data. How large is your database, and what problems are you seeing? Personally I’ve got a 1 TB OLTP database serving 45k users daily without any [...]
View Answer
| April 7, 2010 5:37 PM
In-Memory Database, Microsoft Office, Microsoft Vista, Relational database management systems, Relational databases
Microsoft Access Query: Use a field value as year
You could use the <a href=”http://www.techonthenet.com/access/functions/date/dateserial.php”>DateSerial function</a>. Something like this: <pre>DateSerial([Contract Year],12,31)</pre> -CarlosDL Another way: CDate(”12/31/” & [contract year]) -Msi77
View Answer
| April 5, 2010 3:04 PM
Access 2003 date query, Microsoft Access
You could use the <a href=”http://www.techonthenet.com/access/functions/date/dateserial.php”>DateSerial function</a>. Something like this: <pre>DateSerial([Contract Year],12,31)</pre> -CarlosDL Another way: CDate(”12/31/” & [contract year]) -Msi77
View Answer
| April 5, 2010 3:04 PM
Access 2003 date query, Microsoft Access
Value too Long in Microsoft Access
Only have two real options: 1) make the field longer in the database 2) use a shortened version of the name (1) is the better option
View Answer
| April 4, 2010 10:59 AM
Microsoft Access
Only have two real options: 1) make the field longer in the database 2) use a shortened version of the name (1) is the better option
View Answer
| April 4, 2010 10:59 AM
Microsoft Access
php and mysql
Here is the answer to your question a system built for family tree building and for free (php-mysql) http://www.familytreephp.com/ All the best Sourour
View Answer
| April 3, 2010 10:54 AM
MySQL, PHP
Here is the answer to your question a system built for family tree building and for free (php-mysql) http://www.familytreephp.com/ All the best Sourour
View Answer
| April 3, 2010 10:54 AM
MySQL, PHP
MySQLi and PHP problem with code
Hi. Parse error: parse error, expecting `’}” in C:wampwwwOswaltPatricia_Unit7AssignmentOswaltP_Connect.php on line 48 is the error message. Sorry, don’t know why I didn’t put that in. It also dawned on me that when I created the fields, each of the three fields had max values. areaCode has a max value of 3, same with prefix and [...]
View Answer
| March 30, 2010 10:32 PM
Concatenate, Database, MySQL, PHP, table
Hi. Parse error: parse error, expecting `’}” in C:wampwwwOswaltPatricia_Unit7AssignmentOswaltP_Connect.php on line 48 is the error message. Sorry, don’t know why I didn’t put that in. It also dawned on me that when I created the fields, each of the three fields had max values. areaCode has a max value of 3, same with prefix and [...]
View Answer
| March 30, 2010 10:32 PM
Concatenate, Database, MySQL, PHP, table
MS Access 2002 Previously updated fields revert to previous values
Did you use the .Update method after you edited the record? When you use .edit it just builds a copy in a buffer and does not put it into the table until you .update.
View Answer
| March 30, 2010 5:37 PM
Access 2002, Database issues, Microsoft Access
Did you use the .Update method after you edited the record? When you use .edit it just builds a copy in a buffer and does not put it into the table until you .update.
View Answer
| March 30, 2010 5:37 PM
Access 2002, Database issues, Microsoft Access
Calculating drive volumes and data usage on servers
How often do you restart the servers? We use a method where the servers are rebooted after a backup at 02:00 every day. On reboot, a program called BGINFO, is used to send information about each server to a .mdb file, so we can then compare overall usage, based on a specific time, for all [...]
View Answer
| March 29, 2010 4:39 PM
Database servers, Disk space, Drive Volumes, Server capacity planning, Server Data Usage, Storage
How often do you restart the servers? We use a method where the servers are rebooted after a backup at 02:00 every day. On reboot, a program called BGINFO, is used to send information about each server to a .mdb file, so we can then compare overall usage, based on a specific time, for all [...]
View Answer
| March 29, 2010 4:39 PM
Database servers, Disk space, Drive Volumes, Server capacity planning, Server Data Usage, Storage
Get your FREE ITKnowledgeExchange.com sticker
<img src=”http://http.cdnlayer.com/itke/blogs.dir/24/files/2010/01/michaelsticker.jpg” alt=”From the Desk of Michael” />SMARTS – SKILL – LUCK
View Answer
| March 27, 2010 4:15 PM
CIO, CRM, Database, DataCenter, Domino, Exchange, Linux, Networking, Oracle, SAP, Security, SQL, SQL Server, Storage, Virtual Server, VoIP, Windows
<img src=”http://http.cdnlayer.com/itke/blogs.dir/24/files/2010/01/michaelsticker.jpg” alt=”From the Desk of Michael” />SMARTS – SKILL – LUCK
View Answer
| March 27, 2010 4:15 PM
CIO, CRM, Database, DataCenter, Domino, Exchange, Linux, Networking, Oracle, SAP, Security, SQL, SQL Server, Storage, Virtual Server, VoIP, Windows
Case Statements SQL
If I understand correctly your situation, there is no need of a case statement. You can use the <a href=”http://msdn.microsoft.com/es-es/library/ms184325.aspx”>ISNULL</a> or <a href=”http://msdn.microsoft.com/en-us/library/ms190349.aspx”>COALESCE</a> functions.
View Answer
| March 24, 2010 3:23 PM
CASE statement, SQL
If I understand correctly your situation, there is no need of a case statement. You can use the <a href=”http://msdn.microsoft.com/es-es/library/ms184325.aspx”>ISNULL</a> or <a href=”http://msdn.microsoft.com/en-us/library/ms190349.aspx”>COALESCE</a> functions.
View Answer
| March 24, 2010 3:23 PM
CASE statement, SQL
How to prepare for OCA
OCA or Oracle Certified Associate consists of following Exams. You have to pass these exams to get OCA Certification. 1. 1Z0-001 Introduction to Oracle: SQL and PL/SQL (retired) or 1Z0-007Introduction to Oracle9i SQL® or 1Z0-047Oracle Database SQL Expert or 1Z0-051Oracle Database 11g: SQL Fundamentals And 2. Oracle Database 11g: Administration 1Z0-052 To get training I’d [...]
View Answer
| March 24, 2010 7:55 AM
Careers, Certifications, Database administration, DBA, IT careers, OCA, OCA 10g
OCA or Oracle Certified Associate consists of following Exams. You have to pass these exams to get OCA Certification. 1. 1Z0-001 Introduction to Oracle: SQL and PL/SQL (retired) or 1Z0-007Introduction to Oracle9i SQL® or 1Z0-047Oracle Database SQL Expert or 1Z0-051Oracle Database 11g: SQL Fundamentals And 2. Oracle Database 11g: Administration 1Z0-052 To get training I’d [...]
View Answer
| March 24, 2010 7:55 AM
Careers, Certifications, Database administration, DBA, IT careers, OCA, OCA 10g
How do i recover the DB from suspect mode in sqlserver 2000?
Try the steps in this article http://www.myitforum.com/articles/18/view.asp?id=7381 make sure you have a copy of the database & be prepared to restore from backup if it all goes wrong
View Answer
| March 22, 2010 8:25 PM
Database, SQL Server 2000, SQL Server 2000 Suspect Mode
Try the steps in this article http://www.myitforum.com/articles/18/view.asp?id=7381 make sure you have a copy of the database & be prepared to restore from backup if it all goes wrong
View Answer
| March 22, 2010 8:25 PM
Database, SQL Server 2000, SQL Server 2000 Suspect Mode
ODBC Error Message Windows Server 2003
DISCUSSION: What are you trying to install? I am installing an update to an ERP application. The application had already been installed and running on this server – both the Client and the Server versions. In updating, the installation is successful but when I open/access the program, I get the error message: Error 1429: OLE [...]
View Answer
| March 22, 2010 4:24 PM
ODBC, ODBC drivers, Windows Server 2003
DISCUSSION: What are you trying to install? I am installing an update to an ERP application. The application had already been installed and running on this server – both the Client and the Server versions. In updating, the installation is successful but when I open/access the program, I get the error message: Error 1429: OLE [...]
View Answer
| March 22, 2010 4:24 PM
ODBC, ODBC drivers, Windows Server 2003
DB2 WebQuery: Metadata Error FOC1567
Sorry I did not answer this sooner but just stumbled upon this forum. Regarding the message: (FOC1567) CREATE SYNONYM: DATASOURCE ‘TB_USER_RQ_INFO’ IS NOT UNIQUE Its nothing to do with whether or not its a a Unique index – its the NAME of the index that is not unique. So say you have an index named [...]
View Answer
| March 19, 2010 6:50 PM
DB2, DB2 Web Query, FOC1567
Sorry I did not answer this sooner but just stumbled upon this forum. Regarding the message: (FOC1567) CREATE SYNONYM: DATASOURCE ‘TB_USER_RQ_INFO’ IS NOT UNIQUE Its nothing to do with whether or not its a a Unique index – its the NAME of the index that is not unique. So say you have an index named [...]
View Answer
| March 19, 2010 6:50 PM
DB2, DB2 Web Query, FOC1567
How to Export a MS SQL Image column to a file.
There is no “native” SQL to write an image to a file (or to read/write files of any type). You can read/write files from T/SQL by enabling OLE Automation or by using clr. If you are trying to keep all your code in a stored procedure, then OLE Automation is probably easiest. First – you [...]
View Answer
| March 17, 2010 7:21 PM
blob data, Image databases, SQL, SQL 2005
There is no “native” SQL to write an image to a file (or to read/write files of any type). You can read/write files from T/SQL by enabling OLE Automation or by using clr. If you are trying to keep all your code in a stored procedure, then OLE Automation is probably easiest. First – you [...]
View Answer
| March 17, 2010 7:21 PM
blob data, Image databases, SQL, SQL 2005
create a procedure
You need to read about triggers. Truggers ae procedures that fire when something is done with an associated table — like insert, update, or delete. You are prsented the state of the data at the time (in the case of updaes — both before and after) so it easy to make such an audit trail. [...]
View Answer
| March 17, 2010 2:05 PM
DELETE statement, DROP, SQL Developer
You need to read about triggers. Truggers ae procedures that fire when something is done with an associated table — like insert, update, or delete. You are prsented the state of the data at the time (in the case of updaes — both before and after) so it easy to make such an audit trail. [...]
View Answer
| March 17, 2010 2:05 PM
DELETE statement, DROP, SQL Developer
database querying question SQLite
More details about the application could be needed to provide a good answer. How do you decide that an entity type of ‘bar’ is what corresponds to the ‘foo’ entity ? is it selected by the user, or read from a file, or how ? Does this app have a GUI ? Usually, when a [...]
View Answer
| March 16, 2010 6:35 PM
C, Database, Design, efficiency, SQLite
More details about the application could be needed to provide a good answer. How do you decide that an entity type of ‘bar’ is what corresponds to the ‘foo’ entity ? is it selected by the user, or read from a file, or how ? Does this app have a GUI ? Usually, when a [...]
View Answer
| March 16, 2010 6:35 PM
C, Database, Design, efficiency, SQLite
Creating forms with PHP and MySQL
Look to <a href=”http://phpforms.net/tutorial/html-basics/php-forms.html”>PHP Form Tutorial</a>. It’s too long to write it here
View Answer
| March 16, 2010 6:12 PM
Development, Linux, MySQL, PHP
Look to <a href=”http://phpforms.net/tutorial/html-basics/php-forms.html”>PHP Form Tutorial</a>. It’s too long to write it here
View Answer
| March 16, 2010 6:12 PM
Development, Linux, MySQL, PHP
Connecting C++ to Microsoft Access
1. I am not a C++ developer, but I think I can answer this question. You need to use ODBC drivers. At the beginning of your file, include: #include “sql.h” #include “sqlext.h” Then in your appropriate function: SQLRETURN ret; SQLHDBC dbc; /* assume already allocated */ ret = SQLDriverConnect(dbc, NULL, “DSN=mydsn;”, SQL_NTS, NULL, 0, NULL, [...]
View Answer
| March 15, 2010 5:01 PM
C++, Microsoft Access, Visual Studio
1. I am not a C++ developer, but I think I can answer this question. You need to use ODBC drivers. At the beginning of your file, include: #include “sql.h” #include “sqlext.h” Then in your appropriate function: SQLRETURN ret; SQLHDBC dbc; /* assume already allocated */ ret = SQLDriverConnect(dbc, NULL, “DSN=mydsn;”, SQL_NTS, NULL, 0, NULL, [...]
View Answer
| March 15, 2010 5:01 PM
C++, Microsoft Access, Visual Studio
Using Visual Basic and Access – having problems with other programs sharing memory
The easy answer is to lock down the client and prevent the user from doing anything else on the machine. Set up local policy to prevent non-administrators from running anything other than the HASH of your program. Start->Run->”secpol.msc” In Local Security Settings configure a Software restriction policy as follows (This is for XP, you might [...]
View Answer
| March 11, 2010 6:08 AM
Microsoft Access, Shared Memory, shared memory problem, Visual Basic
The easy answer is to lock down the client and prevent the user from doing anything else on the machine. Set up local policy to prevent non-administrators from running anything other than the HASH of your program. Start->Run->”secpol.msc” In Local Security Settings configure a Software restriction policy as follows (This is for XP, you might [...]
View Answer
| March 11, 2010 6:08 AM
Microsoft Access, Shared Memory, shared memory problem, Visual Basic
AS400 – ORACLE JDBC
Maybe (but I wouldn’t bet on it). IF the SQL is all ANSI standard without any IBM extensions. IF the datatypes all match up properly (Oracle DATE vs DB2 DATE don’t correspond). IF all names match (this is the easy one). The optimizers in the two different RDBMSes are most likely going to decide on [...]
View Answer
| March 11, 2010 12:49 AM
JDBC, Oracle
Maybe (but I wouldn’t bet on it). IF the SQL is all ANSI standard without any IBM extensions. IF the datatypes all match up properly (Oracle DATE vs DB2 DATE don’t correspond). IF all names match (this is the easy one). The optimizers in the two different RDBMSes are most likely going to decide on [...]
View Answer
| March 11, 2010 12:49 AM
JDBC, Oracle
