• What is the best method to connect Oracle and DB2 DB with HIGH reliability and speed?

    Hello, My company currently has 2 ERP systems: JDE (in Oracle) and another which has 3 of our divisions. The decision has been made to move the remaining 3 divisions to JDE. The other divisions currently push pricing to the 2nd ERP system from home grown Contract Systems on the System i nightly...

    MaryKyrrynMathias70 pointsBadges:
  • IF and then statement in query

    I'm having issues with an if statement in a query. Basically I need to know how to get the following: If field 1 is > 0% then field 2 = 25. I don't know VBA

    tphester5 pointsBadges:
  • Java CSV reader (+charts)

    Hello there, I'm trying to create a Java web application which will do the following: -upload .CSV files -store them in a database -will display charts depending on the content of the .CSV file Any ideas? It HAS to be in JAVA! Thanks in advance, Peter

    pforos220 pointsBadges:
  • Teacher’s salaries

    I created a database for contracts using Access 2003. I changed a calculation in a form that was created and it works on the form, but when I open a query it's still displaying the old totals from the old calculation method. What do I need to do to make it change in the query also?

    Smith35 pointsBadges:
  • Database how to connect OpenOffice base to Visual Basic

    How do I connect OpenOffice base to Visual Basic?

    Learn5 pointsBadges:
  • Trigger removed

    How to know if some one had removed the trigger from the file? We have a situation like this so how to know who did that? Shall we get the data from journaling?

    Anu143525 pointsBadges:
  • Trigger

    Guys, we got a problem here...our file is associated with Insert and delete trigger. So will an SQL delete query execution trigger the job attached?

    Anu143525 pointsBadges:
  • Trouble creating SQL statement from MS Access Form

    I'm creating an INSERT statement from the text fields in a form. This is a snippet: mySQL = mySQL & Combo0 & "','" & Text3 & "','" & Text5 & "','" & Text7 I am alternating the double and single quotation marks to enclose the entire statement as a single STRING while...

    MarcC5 pointsBadges:
  • Can somebody provide me SQL questions based on various situation?

    I have started working on SQL DB. During an interview question, there were various situations given through which we need to write some queries. Questions/ Situations where UNION , ORDERBY , JOINS , DATE Functions and others are used. Can somebody provide me SQL Join situation questions for...

    Mayurkhe295 pointsBadges:
  • MS Access database

    I have a MS Access database with records that I have uploaded to Windows Server. I wish to have an user open the records on their local machine and be able to add/edit records on the remote server. What is the simplest way to accomplish this? I have also created a data access page. It seems that...

    Mgregory0 pointsBadges:
  • MS Access 2007, IIF and Null expressions

    Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometimes contains a value and but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25”. I believe that I should be using...

    Phil12550120 pointsBadges:
  • Is there a query to search text of all SQL Server database objects that reference a specific table/instance?

    We want to migrate to SQL Server 2005. We need to find all database objects such as Stored Procedures, Views, Triggers, User Defined Functions accessed specific tables, DTS packages that reference a specific table/instance. Is there a query that will allow me search the text of all?

    SQL Server Ask the Experts2,585 pointsBadges:
  • AS/400 – iSeries SQL Update of on table with values from another joined table

    I've use an SQL utility on the AS/400 call SEQUEL by ASC, that allows updating of values in one table from values in another joined table. The syntax is something like this: update set((a.fld1=b.fld1)(a.fld2=b.fld2)) from file1 a join file2 b on a.key1=b.key1 where a.key1='OnlyTheOneIWant'I no...

    Mark90990 pointsBadges:
  • Configuring Cisco Wireless Router

    Greetings, I have a Cisco 871 wireless router and am having problems configuring it to act as a Wireless Access Point for my small internal network using Microsoft Small Business Server 2003. I am trying to set up one client access via wireless. Using Cisco’s SDM Express, when trying to change...

    RP@ADF15 pointsBadges:
  • Applying an ACL in Packet Tracer for class

    I'm having a problem figuring out how to configure the following:Allow hosts on the 192.168.30.0/24 network web access to any destination Allow hosts on the 192.168.30.0/24 network ICMP access to any destination. Explicitly deny any other access origination from the network.Now the they say...

    MRLS71815 pointsBadges:
  • Find and replace text in text file using MS Access VBA

    Hi I need to modify some tags of an XML file that I receive. How can I search the file for specific text and replace it? Here is the code I have right now. It runs without errors but does not replace the text.Function ReplaceTextInFile() Dim sSearchText As String Dim sReplaceText As String Dim...

    Vgnadeau15 pointsBadges:
  • Schedule SQL job to run and export to CSV file

    Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!

    Sesa5 pointsBadges:
  • Database connectivity ASP.NET using C#

    Hi, I'm new in ASP.NET so excuse me if this is a stupid question. I'm trying to connect a page to the database but there may be some problem. Please help me...... This the ASPEX file cod: using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using...

    Fabregas5 pointsBadges:
  • ITKE Discussion tool bar

    It's been a few weeks since I had the discussion tool bar. ITKE development can not replicate the problem. Did you experience this problem? How did you resolve it? Thanks Phil 5/7/13 .. added tags that have nothing to do with this task but might get some attention

    philpl1jb49,950 pointsBadges:
  • Upgrade from Access 97 to Access 2010

    Hi All, I have a client requirement to upgrade our existing application which is developed on Access 97 and running on Win Xp to Access 2010 Win 7. The Access 97 database has file like .MDB, .MDE and .MDW. Can someone, please suggest a way to upgrade form Access 97 to Access 2010. This application...

    mercuryspark10 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