• Query error when using application role with ADO connection

    I am developing an application with an ADO connection. I need to run a query on two different databases on the same server using an application role. When I run the query I get an error \domainusername does not have a logon on database (referring to the second database). Is there any way around it?...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using an array to detect specific difference in numeric value

    Is it possible to use an array to detect when a character value changes in one variable (ex: act_code = COFF COFF NC01) and then assign a value from another existing variable to a new variable? For example, whenever a change is encountered (COFF to NC01), I need SAS to use the corresponding...

    Risk analyst10 pointsBadges:
  • How i can modify WSCST file witch attribute are CTXFORM : V6R1

    I use function of 5761-TS1 IBM Transform Services for i5/OS on V6R1 for print to PDF. I change printer file; specify TOSTMF and WSCST parameter. So I can print to PDF but Thai Fonts is not work! How I can modify PDF transform map fonts of WSCST file witch attribute are CTXFORM? I read the redbook :...

    Dtikiskza15 pointsBadges:
  • datetime conversion

    SQL Analyzer has issues w/below relative to the datetime conversion- - what is the problem? convert(varchar(10),ft.postdate,101) 'PostDate',

    Mictip5 pointsBadges:
  • Embedded SQL in a Cobol program using a sub-select in the select clause

    The following works fine in SQLPLUS: SELECT SOVLCUR_PIDM INTO :STDN-PIDM FROM SOVLCUR WHERE SOVLCUR_PIDM = :HOLD-STU-PIDM AND SOVLCUR_LEVL_CODE = 'UG' AND SOVLCUR_LMOD_CODE = SB_CURRICULUM_STR.F_LEARNER AND SOVLCUR_CURRENT_IND = 'Y' SSRMEET_ROOM_CODE FROM SSBSECT, SSRMEET, SGRSPRT WHERE...

    Warpmail5 pointsBadges:
  • SQL linking to database in XP

    First of all, I tried to create an ODBC connection to a local SQL database. It successfully created but it does not show up. I know it is there because I can link to it via Access or if I try to create the same one again, it tells me it is already there and if I want to overwrite it. In trying to...

    Bigblew15 pointsBadges:
  • Deletion of Macros when doing a repair & compact

    We are experiencing a problem of a number of macros being deleted after performing a repair & compact. Could this be a space problem or could it be a problem with how the environment is set up--what do you think could be the problem?

    SharieL10 pointsBadges:
  • what is refactoring

    Our company has a project defined as "AppWorx Upgrade and Script Re-factoring". what is refactoring of a script?

    Dekohls10 pointsBadges:
  • JBoss – JMS – Multicast

    Is it possible to configure the JMS messaging service in JBoss to use multicast from server to clients?

    Sweilrus5 pointsBadges:
  • CREATE BACKUP OF SPECIFIC DATA IN ORCALE DATABASE USING JAVA COMMAND OR PROCEDURE

    RESPECTED SIR, i am doing a project. My front end is java and back end is oracle. In my project i stored data in oracle. but I want to create it's back. plz give my a procedure in java to create backup of my data file. which is operate from java front end.

    Juned5 pointsBadges:
  • forms 9i help

    hey , i want to know is there any way to change the java window applet size by any built in and change the oracle picture as well as toolbar.so plzzzz let me know its kind of urgent... thanks in advance nishant

    Nishant835 pointsBadges:
  • Functional Specialist

    Dear, I am MBA (Finance) with over 10 years of experience in Home Loan industry in Credit Analysis and Disbursement department. Last year, my company had launched a new software and I was a part of the core-team involved in Gap study and the testing of the software for implementation. Now, There is...

    Angelc5 pointsBadges:
  • How to have uses click on the dropdown combo box or list box and have only sections of the form open, depending on the list or combo box item clicked.

    How to have uses click on the dropdown combo box or list box and have only sections of the form open, depending on the list or combo box item clicked.

    065 pointsBadges:
  • update query fails as table gets locked by select query (sql blocking issue).

    I have a perl script which updates some table records in sqlserver 2000, the flow is like below: * A select query This select query selects IDs(with other records too) * An update query This update query updates a bit column from 0 to 1 for the IDs retrieved from above select query. The problem I...

    Shashanksingh1915 pointsBadges:
  • how can i limit the data size while entering to the database ?

    how can i limit the data size while entering to the database from Excel sheet using vb6?

    Shwetha20 pointsBadges:
  • How do I print from within a DOS program (FoxPro) to a wireless printer?

    How do I print from within a DOS program (FoxPro) to a HP OfficeJet j6480 wireless printer?

    JerryMus5 pointsBadges:
  • open a green screen from a java application

    We have a java application running on websphere and on click of a button in the browser based application, we need to open a 5250 session and open an inquiry application written in COBOl? We are not sure as how to achieve this. Any help is greatly appreciated...

    Uiiuo50 pointsBadges:
  • .cfi extension with cfincludes?

    Has anyone every heard of using the .cfi extension rather than .cfm with cfincludes. This is a mandatory standard where I work but I've never heard of it before. I have yet to find proof that .cfi is even a ColdFusion file extension. Please let me know your experiences. Thanks

    Kryssten5 pointsBadges:
  • What are the pros and cons for log shipping vs. replication in SQL Server? When is one favored over the other?

    What are the pros and cons for log shipping vs. replication in SQL Server? When is one favored over the other?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Tool to scan workstation for sensitive data or not permitted files

    Hi! Is there a enterprise tool available on the market to scan all the workstations on a network and find non-compliant files like MP3, Videos, etc that users may store on their machine. I would also be interested to scan 'text' based files for sensitive data like credit card numbers or social...

    Richard0070 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