• Single “Filler” Field Flat File vs Multiple Fields Defined Flat File

    What are the Pros and Cons of using a Flat File with a single large field defined compared to a Flat file with multiple defined fields? For example: Physical File: TESTFILE1 R TESTFILE FIELDA 50 Physical File: TESTFILE2 R TESTFILE DEFINED1 20 DEFINED2 10 DEFINED3 5 DEFINED4 15

    AWDSYSMGR20 pointsBadges:
  • Configuring a SQL Server to optimize for best performance

    We are running SQL Server 2005 on Windows Server 2003 R2 Enterprise Edition x64 SP2. These are Dell 2950 servers with 16 GB of RAM, and they are dedicated to SQL Server. We are mainly performing large database migrations utilizing SSMA and ODBC from Sybase. How can we configure Windows and/or SQL...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Sending a message from Access thru Lotus

    Error message comes up: "A stored from can not contain computed subform" and my message comes out unformated on Lotus 6.5 but it is fine on 8.0 (or is that really the reason?) All our users are on 6.5, what do I do to fix this?

    Ricard5 pointsBadges:
  • Oracle archives are not moving from primary to standby database

    Archives are not moving from primary to standby database, which are in the same machine. What things do I need to check?

    OracleATE190 pointsBadges:
  • ADO connection fails after upgrading from Oracle 10g to Oracle 11g

    I have an Oracle 11g database and am using ADO to communicate with it. Under 10g the ADO Connection property 'SERVER' returned the correct database name, but since upgrading to 11g, the returned SERVER name is NULL. Any ideas?

    OracleATE190 pointsBadges:
  • Looking for Antivirus for Win Storage 2003 x64 server

    Hi, We are looking for an antivirus software that proven to work well with windows storage 2003 x64 server. Our current product works just fine on all other 2003 servers, but it brings down this one from time to time. Thanks, Oksana

    Oksana0 pointsBadges:
  • DBA:DB ratio

    Test, but useful, question: How many DBAs and databases do you have at your organization? We have 160 oracle databases, across 105 servers, supported by 4 dbas. (We actually have more databases, but some are not supported by the Oracle DBAs.) Thanks, Carolyn

    Catalysttx0 pointsBadges:
  • Subscript beyond count on nested table (trying to update a column in a trigger for the same table as trigger)

    CREATE OR REPLACE PACKAGE trigger_api AS PROCEDURE tab1_row_change (p_id IN ae_dt526.field1%TYPE, p_action IN varchar2, p_field13 IN varchar2, p_blanket_ind IN varchar2 ); PROCEDURE tab1_statement_change; END trigger_api; / CREATE OR REPLACE PACKAGE BODY trigger_api AS TYPE t_change_rec is record (...

    APB10 pointsBadges:
  • Crystal Reports OBDC (Oracle)

    I created an OBDC on the client to link into the Oracle server, and using it in Crystal report, I can only see the system tables, but not the database table. Using the same obdc in Access application, I can see and am able to link all the tables. Do anyone know why is that I can't see the database...

    Askme5 pointsBadges:
  • What are the most overused tech buzzwords for 2008?

    I'm the editor for whatis.com and I'm trying to put together a list of the most overused tech buzzwords for 2009. Can you help? Cloud is #1 on my list (and all its variations). Green will be on the list too. What else belongs on the list?

    Margaret Rouse1,725 pointsBadges:
  • delete from flat file

    HI My flat file contains data copied from a spool file.The records in this file is used as reference to delete links from dir.Can i delete those records in the flat file for which there is no link in the dir(that is the link or text file object has been deleted from the dir) ?I tried using embedded...

    0 pointsBadges:
  • Access 2007 – How to include option group on report

    Hello, I'm new to Access so please consider this when forming your response. This has been driving me crazy and I've looked high and low on the 'net for a solution. I look forward to your response. I have a form with an option group. I've wish to have this display on my report. Take for instance...

    Tuxalot5 pointsBadges:
  • Notes rich text field to BLOB/Memo field in SQL Server using ADOdb

    I have an agent that uses ADODB to connect and insert a row into a SQL Server database. I want to store the contents of the Body field in the memo (rich text) into a Memo field in the SQL Server database (or Blob field). I'm finding examples of reading this kind of data back into a Notes...

    tjarman90 pointsBadges:
  • AS/400 to SQL Server 2008

    Hi, Is there a way to pull an AS/400 File into SQL server 2008? From within SQL 2008 we do not see an ODBC connection that will work for the 400(??) I am not familiar with SQL server and we need to get some data to it. Can anyone shed some light on what I may be missing in regards to the link to...

    Rmason335 pointsBadges:
  • ODBC on Linux

    A user on Twitter, @garyvee, has a question for the community: Whats the best solution for ODBC on Linux ? And is anyone actively working with it? The direct link to his question is here.

    JennyMack4,280 pointsBadges:
  • Monthly Average in Access 2007

    Dear All, I need to calculate the monthly average on an array of data the gets added to weekly. Therefore, from Jan to March, the total is divided by 3. Come April, the total should be divided by 4, and so forth. Please, no VB code if possible - my VB sucks Thanks Riaan

    Riaane65 pointsBadges:
  • Biometric based secuity system

    I'm looking for information based on experience that anyone might have with the various technologies used for Biometric time clocks. In particular, the reliability of Retina scans vs Finger print vs Facial Recognition. I've installed a low end system from WASP that works well enough for the company...

    Flame14,925 pointsBadges:
  • join logical files

    Hi, Can i join one physical file's 2nd member to another physical file's 5th member? Is it possible? If so how? can anybody help me out?...thanks

    ten20081,150 pointsBadges:
  • Changing field format in Access 2003

    We have an Access data base that includes date of birth in the format mm/dd/yyyy. For reasons I don't need to go into now, we have to change all of them to a different format - yyyymmdd. Is there a way of doing this without changing every individual record? This would save us hours of work. Thanks

    Britinga425 pointsBadges:
  • Access/Word Mail Merge Currency lost digits

    I made a Donations database which merges with a Word document that provides a receipt. The data that comes over drops zeros after the decimal. Ex: $700.00 appears as $700 ...Even worse $700.60 appears as 700.6 How do I get the decimals to show?

    OBI Girl85 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