• How can I synchronize three instances of MySql

    I have three instances of MySQL located in Chicago, London and Hong Kong and I want to keep them sychronized. Is there a standard way to do this.

    Kcornell5 pointsBadges:
  • Accessing AS/400 DB2 physical files with Java

    Hello All, We have one JDE Word Writer program, which export the order master data in the DB2/400 Physical files. We want to access this data from our java program (reside on windows platform). I am wondering how we can do that. I got one hint that can be accessed by ODBC connection. But I am...

    GeethaNatarjan15 pointsBadges:
  • Changing Database Collation

    Hi, I am trying to change the collation of a database and the table and columns, does anyone now how to do this? Thanks.

    Db23290 pointsBadges:
  • Finding nth most recent action with SQL

    I am trying to determine the date on which a certain number of things have happened cumulatively, eg I have a varying number of buyers each month. I want to find out on what date of that month, those buyers make their 3rd purchase. My SQL doesn't seem to support TOP or ROWCOUNT so I would...

    Munona995 pointsBadges:
  • Performance Issue with an Access File Updated through an .accde file with Linked Tables

    I have an Access 2007 Database for tracking daily time for 90+/- employees located on a shared network folder. To enter tasks and time, users click a batch file, which copies a separate .accde file to their C: drive and then opens the file. This .accde file contains a Form for data entry, linked...

    EngTech5510 pointsBadges:
  • Access 2007 removing completed data

    I am working on a database where we visit a prospect 3 times and then remove the prospect for the visitation list. Is there a way to do this so that when the third visit field is entered, Access automatically removes the data or at least hides it?

    MeBrainHurts5 pointsBadges:
  • How a S/W in c# working in N/W accesses access database from other computer not having access

    hi, my project code works in network when i place my database of access in the computer which has ms-access, but wht to do when the other comp, with which i want to connect doesn't have ms-access, then how will i connect to it and run my project?

    Fairy5 pointsBadges:
  • DB2/400 field to match an Oracle VARCHAR?

    We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS field, apparently any...

    Michaelwpeak5 pointsBadges:
  • Compare a field from a file to a column from DB2

    Need to compare a field from a VSAM file to a column from a DB2 table and run through the whole file/table to find differences.

    BobBill10 pointsBadges:
  • Paragraph marks in an ASP blog page.

    My web site includes an asp created blog page that accepts a message in a form text box, sends it to an Access database then returns it to the page. It works without trouble EXCEPT when a user hits enter to go to a new paragraph. The paragraph character is sent to the database but ignored when...

    Boblafferty20 pointsBadges:
  • Execute command in SQL

    can someone tell me the error in this statement declare @cmd nvarchar(4000) declare @PatNo bigint set @PatNo=123 set @cmd= N'insert into TmpDues ( PatNo, BillDate, ReceiptNo, PayMode Amt) select ReceiptTable.PatNo,ReceiptTable.BillDate,ReceiptTable.ReceiptNO,'+ '''Cash'''+' as PayMode,CashAmount...

    Ash1235 pointsBadges:
  • Flat file to PF conversion

    Hi, can anybody tell me how to transfer the entire flat files contents to a new Physical file in regular fields format?

    ten20081,150 pointsBadges:
  • How to get delete history from schema

    How to get delete history from a schema? Application requirement is to get the username ,primary key,date for the deleted records from tables.

    Sureshborse5 pointsBadges:
  • Free Chapter – Tuning database applications for performance

    Another free chapter download is available on the IT Bookworm Blog. Written by: John Goodson and Robert A. Steward Book: The Data Access Handbook: Achieving optimal database application performance and scalability Overview: “Performance and scalability are more critical than ever in today’s...

    BrentSheets6,925 pointsBadges:
  • How to use DateDiff to calculate costs?

    Hi, In my Access bookings system you select a number of Units and a start and end booking time. I need to calculate the cost of each Unit for the booking as well as a total cost for all Units in the booking. The information is stored in two tables: a bookings table called tblHourPeriod with the...

    Dontgetit105 pointsBadges:
  • Open Access 2007 files with Windows 2000 OS

    Is there a reader that that will read .accdb files using a Windows 2000 operating system?

    Skywatcher10 pointsBadges:
  • Calculating prior Query fields

    Inside my query, is four listed fields; date, printer, and a Start and End meter for daily meter readings to keep track of printer impressions. I'm trying to receive a return value by subtracting a meter reading from the START field in a current row and the END meter in the previous row depending...

    Bostic8720 pointsBadges:
  • Access: Form to input dates

    Hi, I was wondering if some Access expert could help me with this short questions. I have an access database with one table, which has 4 columns: ID, Task, Date, Hours I would like to create a form in which a user sees the following headings Task : Mon : Tue : Wed : Thur : Fri and they just fill in...

    Js876525 pointsBadges:
  • DateAdd Function

    I have a dateadd function in a query Cdate:DateAdd("yyyy",[Length],[StartDate]). I need the year added from how long we give someone to complete certain courses. Example, Lenght = 2, StartDate = 1/2/2007, Cdate = 1/2/2009. This works and that's not the problem. Now I need to run the query with the...

    AccessFlunky50 pointsBadges:
  • DB2/400 – Source Physical File Deletion?

    I have a question related to DB2/400. Let’s say, your source physical file name is “QDDSSRC” and inside this source physical file when you try to create a physical file with name same as that of source physical file “QDDSSRC”, if I am not wrong the source physical file will get deleted....

    BibinGeorge130 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