• Can’t create ODBC connection to sql 2005 instance

    I have a server 2003 two node cluster with SQL 2005 installed. The orginal instance is working fine and there is no connection problem. I have created a second instance and can connect with the SQL Management Studio. When i try to create a ODBC connection from my client os both XP and VISTA both...

    Therockatmsu15 pointsBadges:
  • Link microsoft SQL server to Active Directory

    I am getting an error while running a qurey for excuting against OLE DB provide'ADSDSOobject' Please advice Thanks Rajaa

    IT45 pointsBadges:
  • Left outer join

    I have 5 related tables. The main table is meeting. The other tables are participant_meeting, vendor,user_id, address. I need the meeting information and the particpant who attentds the meeting(participant_meeting), and their address(address) the vendor for the meeting (vendors) , user_id for the...

    Niveanand5 pointsBadges:
  • Multiple Join Update

    Hi, my need is to update a table with a join of 2 other tables. The first table (a) has 5 columns (product_id number, ist number, plan number, plan_w number, ist_w number) The second table (b) has 2 columns (prod_group_id number, percent number) The third table (c) has 2 columns (product_id number,...

    Keltos25 pointsBadges:
  • adding hyperlink

    I have created columns in the query for links to pdf files. Each one belongs to an employee. My question is how do I create the link to showup on the form for each employee? The links belong to certain employees while others have no link. I am currently running Access 2000.

    Sunshine07660 pointsBadges:
  • JavaScript addContent function – Packaging Options

    * IS THERE A WAY to use this javascript addContent function, * Incorporate the utility of an ADD button * But avoid using the packaging of FORMS? While making use of a sample for addContent (located at http://www.randomsnippets.com/2008/04/14/how-to-dynamically-add-content-to-a-div-via-javascript/,...

    Bryanfox5 pointsBadges:
  • Oracle SQL question

    I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I'm unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case statements but Oracle doesn't like...

    Wanderer95775 pointsBadges:
  • copy file to PC

    I need to know how to copy a native iSeries DB2 file to the IFS in PC file format

    StillKickin5 pointsBadges:
  • Conversion of 32bit Informix to 64bit Informix

    how to Convert 32bit informix to 64bit informix in hp-ux 11i

    Rajuujar5 pointsBadges:
  • How to implement a “is a”/generalization relationship in an ERD?

    I'm using SQL Server 2005 Developer edition.

    Obhasha0795 pointsBadges:
  • IIf and showing all

    I want to show in my criteria that: IIf([Issues].[DataOrigin]=2,-1,( no criteria or (0 or -1)) If I use null instead of no criteria my result is wrong if I use (0 Or _1) in Iff function my result is same as -1 but when I use (0 Or -1) in query I have right answer. Anyway I would like to show...

    Hh13545 pointsBadges:
  • Unique ID for existing table

    I want to add a column to an existing table where its values should be unique and auto generated in a sequential order

    Ragas60 pointsBadges:
  • Access 2007 table versus forms

    I use Access for contact mgmt. database. I have my "main" table that has all my client info. If I create a form (looks like spreadsheet) and it is populated by the names in the table and I need to delete names from the FORM, not the original table, does it delete also from the main table?

    Gpl5 pointsBadges:
  • AS/400 data to Microsoft Access database

    In my business, I use an MS Access database to monitor inventory of my client and encode similar data to my client's AS400 system. I am asked by my client to simplify my job by encoding only in AS400 and have the data transferred to my Access database automatically to whatever method is possible....

    JEV5 pointsBadges:
  • ODBC Connection to iSeries

    Hi, My company has just upgraded to V6RM0 of iSries and I have had problems connecting to the new server through ODBC using Crystal Reports or SQL server DTS. The packages I already had set up are still functioning and I can get a connection OK, but whern I try to create a new package I get an a...

    MBell40 pointsBadges:
  • SQL in an SQLRPGLE program

    I want to use embedded SQL in an SQLRPGLE program to search a file for a field entered in a screen to select data using the LIKE operand. This is my code C/EXEC SQL C+ DECLARE C1 CURSOR FOR SELECT * FROM F0101JN WHERE ALADDZ = :SZIP C+ AND ABALPH LIKE :SINNME ORDER BY ABAN8 C/END-EXEC * I entered...

    Alpfalpf25 pointsBadges:
  • backup of MySql with VB.Net

    How can i get backup of MySql in VB.Net?

    Bvicky9920 pointsBadges:
  • linking report to form by macro

    I have a report that various info including name is pulled off of a form. i want to be able to click on the name in the report and have it bring up that particular record in the form. i can click on the name and it brings up the first record, but i want it to go to the specific record that matches...

    Mjward755 pointsBadges:
  • creating reports with forms/subforms

    I have created a report that is linked to the form. When I click the preview command button it asks for Emp. ID I enter in the ID Number and click ok. The print preview screen shows up with nothing on it. How can I get the data to show up on the report? and when I create complete report how can I...

    Sunshine07660 pointsBadges:
  • log sql queries?

    queries seem get mangled by our report writer middleware; I'd like to see the actual SQL received by Oracle9i from a particular user. how?

    Ktpierce5 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