Database

Date problem with Delphi 7

I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database. dtsdate.DataSet := qrydate ;  qrydate.Active := false ;  qrydate.SQL.Text := ' select * from datum where datum < 1994/02/05' ; qrydate.Active :=...

MySQL 5.0 advantages and disadvantages

what is the advantage and disadvantage of mysql 5.0?

Write Recordset to MSAccess(mdb) using VB6.0

How can I create a new mdb file from recordset which is populated from oracle db. Please share any examples of writing recordset into mdb file. Thanks in advance. Software/Hardware used: VB6.0, MS Access 2003

MySQL vs. Oracle

what is the major two comparison of mysql5.0 and oracle 10g?

Migrating C code db acess from sybase to sql server 2005 - newbie

I have to change the db access from a sybase to a sql server 2005 in a c program (i have to keep the C code) I have read lots of technical articles but i'm a bit confused ... with ODBC and the use of sqlcli.h i write a simple C code that access the sql server db but i think it is not the better...

Function to find greatest numeric value across different fields

In a row of data with multiple numeric fields, how can I easily find the greatest value using simple function like GREATEST(Attribute1, Attribute2) as for Oracle SQL?

Capture SQL Server logged in db User name in Access 2007 Accdb

I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application.  Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user.  Is there a way...

Lotus Approach and File Maker Advance Pro 10.0.3

Can anyone help me on how to migrate or import/export or open Ms Excel using these softwares Lotus Approach 2000 and File Maker Advance Pro 10.0.3 please thanks Software/Hardware used: Lotus Approach and File Maker Advance Pro 10.0.3

General question about Database Performance Management Software

I was just told that Database Performance Management Software apps are always stand-alone applications. That doesn't seem right to me. Are DPMS tools always stand-alone? 

can you explain what cluster shared volumes are? Is this a new file system?

Can you explain what cluster shared volumes are?  Is this a new file system? This question is from the 7/30 Microsoft Virtualization Chat on ITKnowledgeExchange.com

Serialization: Mutexes vs. Semaphores

I am looking for a way to serialize access to a RPG program across multiple jobs. I have been doing some research on mutexes and semaphores and I am wondering what the advantages/disadvantages of each are. Also if there are any other ways to accomplish this. Thanks in advance for your reply

AS/400 SQL BLOBS

I am trying to read data from a SQL table that contains a BLOB of 10MB.  Since the RPG field size is limited to 32KB, is this even possible? Software/Hardware used: AS/400SQL

mysqldatetime exception

mysqldatetime exception i am using MySql  with c# in my window application , In code i think everything is fine , when i made a latest patch for the given installer it throwing an exceptuon at client side " Cannot perform '<=' operation on MySql.Data.Types.MySqlDateTime and System.String." ...

Access Query - Repeating fields

I have a file of 70K names. Some are dups. I want to create a indicator in Access to flag when the name is repeated indicate 'Y' else 'N'. Any ideas on how to create a query to do this Software/Hardware used: Microsoft Access 2003

Using MS Acess SQL Passthrough To AS400 to find wholes in number sequence between to files

Below is a SQL statement from an Ms-access pass-through query that is pulling the info from an AS400 system. The Fields marked in bold are the two table that I need help with. This query returns the same part numbers form each of the two columns of cores because there are of differ tables. I know...

Why won't my Access subform stay put?

Hi, I have a main form with a subform below it. The subform supposed to be invisible and 5" from the top. When I click a button, it becomes visible and 0" from the top. When I double click the button, the subform is supposed to go back to being invisible and 5" from the top. For some reason,...

ACCESS 2007 and SQL Server 2005 Schema Updates

We have several clients with access to reports (provided via Views). The reports for each client are separated by being under a different SQL Server 2005 Schema. Obviously we can get each client to link to their Views but the client wants things to work like an ADP - that is, as reports are added,...

JDBC Connection from JAVA to iSeries DB

I have a simple class that resides on my local drive. I am attempting to connect to iSeries I5V4 environment and do "select" from one of the DB files. When I run my .class file in Rational Application Development I ghet a "class not found" exception. How do I set classpath in RAD? Should my...

FXP FILES CONVERSION (TO RPG)

  fOXPRO REL 2.6 (FOR dos) CAN SOMEBODY GUIDE ME AS TO HOW FXP FILES ARE CONVERTED BACK TO PRG (WITHOUT SPENDING MONEY) ? Software/Hardware used: fOXPRO REL 2.6 (FOR dos)

T-SQL query to ACESS 2007 database

I need examples of T-SQL queries running on SQL Server 2005 that retrieve data from a MS ACCESS 2007 Table. Any explanations are appreciated. Thanks