• Old Approach App in XP

    Hello, Have an older Lotus Approach '97 DB App here that I have been asked to see what it would take to get back working in our XP enviroment. This is about 10 Approach Databases in an relational type of setup with about 2000 records and 150 or so custom layouts. Have messed with it a bit and for...

    R8escjohn0 pointsBadges:
  • Database architecture – MS SQL 2000 and SAP R/3 4.6C

    I am upgrading the disk arrays on my production server over the Christmas holiday, and would love to hear some opinions on how you would recommend partitioning the new array. Currently, I have four disk arrays on the production server, divided into four drive letters (and hence four database files)...

    SylvJumaga0 pointsBadges:
  • Print Numbers in words

    By using a single SQL Query Is it possible to print numbers in words. Example : To print "5,550 Dollars" in words Expected Query result : "Five Thousand Five Hundred and Fifty Dollars Only" Is it Posssible by a single query

    Sanmails0 pointsBadges:
  • ORA-01000 error even if all statements and resultsets are closed in finally

    I am getting ORA-01000 error even if I have closed all statements and resultsets in finally for all query (not using prepared statements). Also OPEN_CURSOR is set to 500. We are using Oracle 8.1.7 and in JDBC driver 'Enable Resultset' is ON and 'Enable Closing cursors' is OFF Please suggest how to...

    DeveloperJava0 pointsBadges:
  • Run exe from Forms 6i

    Hi Can I run an external exe app from a when-button-pressed trigger? If the exe expects input parameters and outputs a code can these also be processed by forms 6i? If so, how do I acheive this? My OS is Windows 2000. Thanks.

    Dlaw650 pointsBadges:
  • SQL Table Updates

    This is probably a simple question, but I seem to be butting my head against a brick wall. Here's the scenario: T have two databases, call them A and B. A is created when a user registers on a forum site here at the Uni, and B is their "profile". There is a common ID in both files. Because of a bug...

    Moldor0 pointsBadges:
  • Question about a frequently changing column as primary key

    Thank you for taking take to read my question. We have a live J2EE application using Oracle 8i. Now we are doing v2 to add some modules. We found it has a frequently changing column (status_code) as part of the composite primary keys in some major tables. We know it can cause future proformance...

    Paulachen0 pointsBadges:
  • a simple but complex query

    hai everybody, consider a table which has column names as col1,col2,col3 tht is col1 col2 col3 -- column name xx 10 a1 xx 10 a1 yy 20 a1 yy 20 a1 and the output should be in the following format col3 xx yy -- column name a1 20 40

    Carbuncle0 pointsBadges:
  • Remore RS232 Control

    Good Day All I wondered if anyone knows how to remotely access and control RS23 devices. I will give you my example. I have a PC which is attached to 2 RS232 devices. I would like to have some form of control of the devices attached to the PC from a remote location, like a PC in another room or...

    Jondean0 pointsBadges:
  • Error tracing using triggers

    I'm running an application, using a SQL Server 2000. At some point we've implemented an error, that seems to cause the wrong data to be deleted from a table. We've tried locating the error both by browsing through the potential code likely to contain then error, and by logging different kinds of...

    LeChuck0 pointsBadges:
  • Regarding Oracle connectivity issues

    I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the...

    Vabene0 pointsBadges:
  • Using Query returned values in Oracle Graphics 6i

    Hi all, I wrote a query in Oracle Graphics Builder (6i)(Bar Graph). The query will return diff. categories(so multiple bars) wherein each category will contain atleast one subcategory(Maximum three). So, each bar will contain either one or all the three sub-categories. My requierement is to set the...

    Mphani0 pointsBadges:
  • SQL Server 2005 adoption

    My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. I am interested in your thoughts on SQL Server 2005 adoption. Based on your knowledge of SQL Server 2005, what hurdles do you foresee in using the new DBMS? Do you think Management Studio will be more difficult to...

    Nbellistri0 pointsBadges:
  • Join and manipulate data from two separate databases

    I'm using SQL2000. How can I join and manipulate tables from two different databases? Thanks, wbrannon18

    Wbrannon180 pointsBadges:
  • Java and Oracle

    hi Sir, I have an application web based. using Oracle backend and Java front end. App server is in weblogic and Solaris os and two cpu with 8 applications. DB server is oracle 8.1.7 on Solaris This application is getting slow when number of threads are more ( like many users login and related...

    Shajie0 pointsBadges:
  • Connecting to the Database

    I am trying to connect my project in Visual C++ 6.0 to the database in Microsoft Access 2003 using DAO but am receiving an error message stating that 'unrecognised database format', how can I do it then?

    Jmirror0 pointsBadges:
  • To add a column to an oracle(8i) table someplace other than the end of the list?

    Greetings, Is there a way to add a column to an oracle(8i) table someplace other than the end of the list? Thank you very much, Paula Chen

    Paulachen0 pointsBadges:
  • Reference a query object from another query

    I want to be able to reference a db2 query from another query. Is this possible? For example: select table_data.field1, query_data.field1, query_data.field2 from table_data, query_data where table_data.field1 = table_data.field 1 In the above example, query_data is a db2 query that I have created...

    MichaelPatt0 pointsBadges:
  • Synchronizing expired merge subscription database with publication database

    I had a merge subscription expire and now need to synchronize two disparate databases. How do I do so without overwriting the subscriber database with the publication snapshot? Thanks for any help you can give.

    Micjones0 pointsBadges:
  • Help using oracle Analytical function.

    I am trying to create a query that will do two parallel select from the data available. I want to write one select statement using analytical functions, What I want to do is as follows: I one single query I want to find out the count of the transactions in the last 7 days from sysdate and last 6...

    Prativa0 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