• 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 :=...

    Marieps5 pointsBadges:
  • Format CSV file column width.

    I converted a dataset to a CSV file and found when opening the file, all the column widths are fixed. This causes most of the columns to be truncated. Is there a way (not manually) of making the columns auto-fit. Language: Cobol.

    JoanIk5 pointsBadges:
  • MySQL 5.0 advantages and disadvantages

    what is the advantage and disadvantage of mysql 5.0?

    Mysql10 pointsBadges:
  • Retrieving the ‘SA’ password

    By mistake I deleted my SA account. Now I am unable to access the isql I had done. I know that if you have lost the 'SA' password, then you can regenerate another one. I followed the steps outlined in the SearchEnterpriseLinux ATE answer on the topic of regenerating an SA password. But nothing...

    Linux - Ask the Expert270 pointsBadges:
  • Duplicate public name ACL Manager

    ERROR IN LN when clicking tools PREFERENCES -- DUPLICATE PUBLIC NAME ACL MANAGER

    Jaffer20 pointsBadges:
  • 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.

    Nikhildhar35 pointsBadges:
  • Database connection problem

    I am working on a japanese project. the DB is oracle8i. So I am using classes102 and nls_charset10 driver zip files. I am able to connect to db through SQL* but not through code. the error is: java.sql.SQLException: 20 at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:407) at...

    Sankya1235 pointsBadges:
  • Microsoft Access table dropped primary key and index

    I am using MS Access 2007 on Windows XP Professional. The main table in my Purchase Ordersdatabase has dropped its primary key and index (no duplicates). Previously, it worked without any problems, and caught duplicate values. Now, when I try to reset the primary key, I get the message, "The...

    Swd14420 pointsBadges:
  • 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...

    Ppeterso15 pointsBadges:
  • Access 2007 on an Xserve Server

    Is this possible to take a MS Access Db and run it on the Xserve Server

    DarrylH5 pointsBadges:
  • 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?

    Kevling5 pointsBadges:
  • 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

    Nilo15 pointsBadges:
  • 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...

    0949595 pointsBadges:
  • Cisco Access Control Lists – Recommended default template?

    Hey guys! I was hoping to find a default access control list template that you may use to block off, reserved addresses, known worms, viruses, vulnerabilities when you are setting up a new router? Trying to think of every possible threat is impossible but a good recommended starting point for...

    Tkrn10 pointsBadges:
  • Advance database menagement system

    How I secure my data

  • Multiple DELETE From Statements in Query Manager

    How do I enter more than one Delete from ...... where .. Statement from within Query Manager?

    Pb5410 pointsBadges:
  • 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

    ITKE54,650 pointsBadges:
  • 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?

    Newsqluser25 pointsBadges:
  • Access & iSeries AS400 Tbl and Query Issues Error Code 5001

    I am in Access and I have (A) a passthrough queries=(INMSP300) and (B) table queries=(dbo_ECC_APP.OEM),I want to join. In the dbo_ECC_APP.OEM there are number identifiers that have no associate number were in INMSP300 there are both and they are associated. So I need to have all the number in the...

    CompEng1,185 pointsBadges:
  • DB2 connection in VBscript

    I need to delete some records from a DB2 database on an AS400 using VBscript.

    Larksys5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following