• MSDTC Error with database/Windows Server 2003

    I'm using two server 1.Application server(windows XP Pro SP2) and 2.Database server(windows server 2003). when execute an application that will connect to my machine for database access and next it'll connect to DB server, at this time it produce "Communication Underlying Transaction has failed".....

    ManiS0815 pointsBadges:
  • How to put Access Control List in Cisco WS-C2960-24TT-L

    What are the commands to put Access control List in cisco WS - C2960-24TTL

    Whyshree5 pointsBadges:
  • CA Database Command Center — good competitors?

    Please note: The following question was recently submitted via e-mail by a user. We're looking to use CA's Database Command Center, but I want to know if there are any good competitors we should be looking into as well.

    JennyMack4,280 pointsBadges:
  • i need MCQ’s in principle of distributed database system

    MCQ's on query processing/ MCq's on trancation managment?

    JD105 pointsBadges:
  • Rebuilding Logical Files

    What does rebuilding a logical file do? Is rebuilding the same as recompiling? Or, is it a separate process How often should they be rebuilt? If you reorganize a physical file, does that rebuild the logical files as well?

    Dcantwell470 pointsBadges:
  • SQL Server query

    how would I write an SQL statement to view the number of purchases for each month in the year of 2008..?

    Hodhod5 pointsBadges:
  • Connectivity between Oracle BI Publisher and Microsoft Access

    I need to make a connection from BI Publisher to an MS Access database. Anyone can help me with the connect string and database driver class details for setting up a JDBC?

    Ms123115 pointsBadges:
  • Windows ODBC driver for IBM DB2 database

    I'm looking for a windows ODBC driver to access a DB2 database on the AS400. Does anyone have a link or suggested vendors?

    mshen27,385 pointsBadges:
  • Making two records into one

    I was not sure on how to word the title of my questions, so it is better if I simply give you my query and result: SELECT DISTINCT PJ.EMPL_NUM, (CASE WHEN PAY_TYPE = 1 THEN RATE ELSE 0 END) AS REG_RATE, (CASE WHEN PAY_TYPE = 3 THEN RATE ELSE 0 END) AS OVR_RATE FROM dbo.tblPayrollFlashJobDetail AS...

    Fscopel15 pointsBadges:
  • Runtime Error 2147217900 (80040e14) – Syntex Error (Missing Operator) in query expression

    Sir, I am using VB6 as fronthand and Access database as backend. Now in my project i want to display only those records which match selected value through combobox. but when executing system giving error as "Runtime Error 2147217900 (80040e14) - Syntex Error (missing Operator)in query expression "...

    RajeshP20 pointsBadges:
  • File attribute DFU

    I have come across an object whose type is *File and attribute is DFU? What does this mean?

    Niklethaldan10 pointsBadges:
  • Dymo Printer programmatically with VB.NET

    For a project i need to get the print out in Dymo LabelWriter Duo Printer. I am facing the problem in 1. How can i make a file with extension as *.lwl or *.d1l 2. How can i pass values to the file i had made above. I am using VB.Net , VS 2005 as IDE and MS Access 2007 as backend. Any fast help is...

    Honeyprogrammer35 pointsBadges:
  • Missing Database Name and toolbar

    Why does the name of the database and the associated toolbar not show up when I look at the list of tables IN that data base. It does for most of my databases but not for one of them. How do I fis this?

    LarryThompson5 pointsBadges:
  • Retrieving Records based on Record Selection from another table

    I have an Access database (which eventually is going to SQL)that contains several tables. One table is contains categories of items that are available for purchase. The other tables contain those items that belong to the appropriate category. In other words I have categories of flowers, vegetables,...

    Tjlevin10 pointsBadges:
  • Changing BCP format file collation

    Hi All, I was wondering if it was possible to change the collation of the format file created by the BCP utility from CS to CI, than import the data? The reason I ask this is I want to import the data from one column to another column using a different collation using bulk insert. Thanks.

    Db23290 pointsBadges:
  • Q+A 5 Recover Database FAIL. Get File In Use

    We are running Q+A 5 and cannot do a successful “Recover Database”. Get “FILE IN USE BY aaa, bbb, aaa, ccc, bbb, bbb, bbb” message. All users were out of Q+A. Also we had the users mentioned in message re-boot their XP PRO workstations. Please Note: UIDs repeat in the in-use message.

    CGuy5 pointsBadges:
  • SQL or VBA code to loop through two columns of data

    I have a database table with 196000 rows (product code and related product codes) and the columns are: product code link product 000507 000123 000507 000456 000507 000789 000508 123456 000508 654321 000508 879456 000508 123789 etc etc I need this data changed to: 000507 000123, 000456, A product...

    Limey5 pointsBadges:
  • 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:

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