• Oracle Application Express Item

    I have two tables with parent-child relationship. Is there a way to automatically populate the foreign key field of the child table with the exact data from the primary key of the parent table?

    Rwy265 pointsBadges:
  • How to create an SSIS package for importing an Access table to SQL Server, running SPs and exporting data to Excel

    I need to create a SQL Server Integration Services (SSIS) package for importing an MS Access table into SQL Server, then running some stored procedures on this database and finally exporting the result to Excel. I am comfortable in writing queries and working in Management Studio but I don’t know...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Fetchind duplicate rows from a table

    A table has appox 60 fields. i would like to fetch all the rows having all values of the field equal excpet 3 fields.

    Sri245 pointsBadges:
  • How can I collect database/server information across multiple MSSQL versions.

    I would like to collect database info(backups, databases, logins, etc) as well as server information ( MSSQL version, patch level, etc). I would like to use one server to collect information from all of my servers. I have MSSQL 7, 2000, & 2005 on Windows servers 2000 & 2003. I am also new to MSSQL...

    AngieJo20 pointsBadges:
  • access data change history

    i wanna know if the data entry will change the entered value more than one time or if i can make history register for data update and change

    Rosealzubi115 pointsBadges:
  • MySql Query

    Hi Gurus i have a problem in MYSql Query Browwser there is a table "jiuser" in "jasperserver" database. this table has a column "username". there is another table " jiresourcefolder" in the "jasperserver" database. this table has a column "uri". now i wana find out which user can access which uri....

    Abhi Here20 pointsBadges:
  • Great Plains 8 ODBC Error (45)

    This just started today, Great Plains has been working for a good time now. I get first error message when logging on " A get/change first operation on table 'tablename' (45)." And then when you click on More Info... it says "[Microsoft][ODBC SQL Server Driver][SQL Server]Database'Databasename' is...

    bradob160 pointsBadges:
  • Cloning Vista installation

    I have a "perfect" MS Vista setup that I need to clone or deploy to another 20 computers. The hardware is identical and it all needs to be done in a hurry. In the old days I would have copied hard drives by hooking up the next drive to the second IDE controller. Then I would have used my trusty...

    Chairish5 pointsBadges:
  • Installing McAffee = Crashed laptop

    I was installing mcaffee virus shield from a network drive on a laptop for one of my co-workers and about 3/4 way through the installation an error came up that stated it needed Frame Package and then I got a fatal system error with “error in services system will shut down in (countdown)” and...

    Tim204320 pointsBadges:
  • CSV data into Excel 2007

    Here's the issue. I have a .csv file that I want to import into Excel. This .csv came originally from Access. It has things like access database color values in it. I want to be able to do the following: 1. Change each "chr" value into it represented ascii equivalent. Example: chr(58) is a ":"....

    SHAPOW35 pointsBadges:
  • DB2 Web Query- Change Report Layout

    I have a report which contains all the information I require. The problem is, there are two totals (automatically produced after a break) that I would like to move down to another section of the report. Any way of doing this?

    TomS5 pointsBadges:
  • G socket error in Lotus Notes

    I have a user who launched Lotus Notes and the user got a g socket error

    Wes5 pointsBadges:
  • referential integrity

    quick question about referential integrity: let's say i have 4 tables: A table has NAME B table has NAME, CODE C table has CODE D table has NAME, CODE, ELSE A (NAME) is referenced by B (NAME)and C (CODE) is Referenced by B (CODE) if i reference B (NAME, CODE) from D, do i need to reference A (NAME)...

    Abruck15 pointsBadges:
  • Flexgrid loading from CSV and saving to CSV

    I am creating database application that will allow the user to enter information into a flexgrid as well as load data from a CSV file into the flexgrid as well as save that file and i have a couple of questions 1, how do i make the application load the data from a specific CSV file 2, how do i make...

    Armageddonash135 pointsBadges:
  • Moving oracle database

    HI, We have planned to move our oracle 10g production database from Solaris to Aix bix. So experts, please suggest any best practices that you follow or any scripts that should be run before moving it or any documentation or case study that will help us to do the work more efficiently. Thanks a lot.

    8320 pointsBadges:
  • Cisco AcessControlServer – Authentication

    Hi I'm configuring a Cisco ACS for our diploma thesis and now i have this problem: The Authentication of the IETF Radius-server operates properlym but the authentication of the nac doesn't work. All clients come in my quarantine-vlan. In the logs there is the SharedRAC: Quarantine_RAC displayed. I...

    Stefan6005 pointsBadges:
  • Oracle Installation on Portable Media

    Hello Friends, I am working on Oracle 9i (Rel - 2). I am thinking of developing an application in which I can install Oracle on a portable media (Eg. Portable Hard Disk) and create a databse on the same. First of all, I want to know whether it is possible to install the Oracle on a portable media....

    Girishdadlani5 pointsBadges:
  • select only duplicate employee numbers

    How does one select only duplicate employee numbers to be printed? Sounds simple?

    Moonquest15 pointsBadges:
  • Server 2003, NTBackup Utility, Shadowcopy Service and Network Drives.

    Good afternoon! I have an interesting scenario I'm trying to resolve here. Namely, I wish to execute a centralized backup of Outlook PST files for my users across my building. The problem is that most users do not log off, or shut down Outlook. This is not a situation that I am able to remedy, as...

    Lonewolfbw525 pointsBadges:
  • Is there a server running on localhost: 3306?

    Has anyone seen this error before? We've got a Windows 2003 Standard Server running MySql 5.x.x, with ColdFusion MX 7.x.x. Everytime we try to add a new MySql DSN Connection we get this error: Connection verification failed for data source: cudefault java.sql.SQLException: Communication failure...

    Ozzyit25 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