• Connection with two Database for an Application

    I have an application that makes use of 2 different database say A and B. I am working with A but using some datas as views from database B. How can I establish the connection with two database using Bridges?

    Rashik5 pointsBadges:
  • Copy data from flat file to a flat file

    My requirement is : I need to copy data from 1 big flat file to a flat file,but size of this flat file must not > 3MB, if size increases then new members will be created and remaining data will be copied there ….so on..hence this small files will only contain records with size upto 3mb. Can...

    Supriyob2165 pointsBadges:
  • JDBC/ODBC to Excel 2007 getting Exception

    Iam getting the SQLexception by trying to connect using JDBC/ODBC to Excel 2007 through Java. Any Guys can tell abt this problem. java.sql.SQLException: [Microsoft][ODBC Excel Driver] External table is not in the expected format. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at...

    Ansipar288315 pointsBadges:
  • Access mailbox through the file system?

    We are running Exchange 2003 Server Enterprise with SP2, on Windows 2003 SP1. We have a user who wants to make a connection to an Exchange mailbox folder from an MS Access database. I know that Exchange 2000 used to have the M: drive for file system access, but that no longer exists in Exchange...

    Serendipity100 pointsBadges:
  • How much access do you give users?

    I am auditing a enterprise data warehouse and am concerned at the level of access provided. I've found many users who have read, update, and delete rights to all working environments (testing, QA, Production)

    JimHayward5 pointsBadges:
  • os on data base servers

    do you need an os on a data base server if you have sql loaded

    Carman5 pointsBadges:
  • Problem replication propagation

    Hello, I explain my problem. I have 3 databases (CTS1, CTS2 and CTST) in multimaster replication. CTS1 and CTST first run without problem. CTS1 is master site definition. I have added master site CTS2 without quiescing replication. Now I have 3 master sites running. I have the following problem : A...

    Fsoter065 pointsBadges:
  • Conditional Format – Access 97

    Unfortunately, the company I work for uses Access 97, and the Conditional Format Wizard is not available in this version. Can you help me with building a macro/expression to create a conditional format for a form? I need to format the form's background color based simply on whether the record is...

    Alayneb215 pointsBadges:
  • ORACLE DBMS vs. SQL sever DBMS

    What are some key differences between Oracle DBMS versus an SQL server DBMS? Also, What are factors that would make someone want to use an Oracle DBMS versus an SQL server DBMS?

    Ryzawack15 pointsBadges:
  • Problems from reindexing tables every day on a SQL Server

    We have a daily job running to reindex all the tables for all the databases on our SQL Server. If I reindex selective reporting tables everyday, take a transaction log backup right after reindexing and check if the transaction log is greater than 1GB, I think I should invoke a stored procedure to...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Microsoft Access query window

    I use an Access program to record student records. The program has built in queries, but when I try to start one the popup window is tiny; all you see is border, no text, no restore or exit buttons. I can't catch an edge with the mouse to enlarge it. Also, the program opens without the toolbars I...

    Masterlink5 pointsBadges:
  • Creating pop-up reminders

    I am maintaining a data baase of living documents whic require a review every 2 years. I need a reminder before the 2 year anniversary arrives. The table currently has a "Effective Date" column. Please keep in mind that I am not well versed in macros. Thanx for any help,

    Darkness5 pointsBadges:
  • Oracle, MySQL connectivity by HSODBC

    Hello, We have tried to connect with MySQL from Oracle 10g Rel.2 through HSODBC and getting the following error: ERROR at line 1: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from MYSQLDB Both MySQL...

    Shafiqurrahmanbappy5 pointsBadges:
  • Run scheduled job on SQL Server

    we do integrate SQL SERVER woth Oracle database, and its usually work withour problems. the last two days the intgration is not working and the following error displayed in the job history. Cannot create COM Server to load and execute DTS Package. Error -2147221008 (800401F0): CoInitialize has not...

    Kmadani35 pointsBadges:
  • Database refresh

    i want to refresh the database for every week from a cluster environment. could you please suggest a feasible option not back and recovery. I tried the following ways: 1. through SSIS database transfer task-but it failed 2. through copy database wizard-not working please tell us how to work through...

    BOKAMD815 pointsBadges:
  • Penetration Testing.

    Hi!! Good Morning. I have a simple question for you today. I intend to have a penetration testing done for all of my 3 sites - My US Office, My India Office & My US Datacenter. Can you suggest any trustworthy site which can offer me a free reliable scan? Also, I would like to have you suggestion on...

    Nileshroy0 pointsBadges:
  • Grouping the records in RPG

    How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a 'SQL precompile failed' error. How do I handle this?? And i have to display the employee records grouped by their locations... how can this be done??

    Shwesmile20 pointsBadges:
  • Multiple codes in a field

    Hi there, I'm a complete Access noob, but I need to figure something out! Is it possible to put more than one code in one field? For example I need to answer 500 letters. Each letter has a code say 01-500. In each letter there are 3 questions that need to be answered, but half of the questions in...

    Thomasstegenga5 pointsBadges:
  • Problem with slow loading database after delete record/data

    currently facing problem in loading my database after i delete some record from the database..i have compact for the database but still have the slow accessing problem..kindly assist..many thanks

    Tmlife5 pointsBadges:
  • Facing a problem while working with transactions

    I m having my SQL server on Machine A and i m starting one transaction on server from Machine B, now in between suppost Transaction from Machine B creates a new record in one of the table on server using insert into statement, after creating the record the LAN connection of Machine B is...

    Rajratna5 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