• SQL Server 2005 within MS Access VBA

    I have am MS Access (VBA) program where I need to create a table on a SQL Server database then append data to the table. I have the code that generates the update query but I need the ADO code that creates the connection to the SQL Server 2005 database then I need the code that will execute the...

    Rjwilcox45 pointsBadges:
  • Including a primary key in a nonclustered index in SQL Server 2005

    The query optimizer for SQL Server 2005 is suggesting that we include a primary key as part of a nonclustered index. Is it OK to include that to increase SQL performance?

    SQL Server Ask the Experts2,585 pointsBadges:
  • DSN and DSN-Less Connection

    What is difference between DSN and DSN less Connection? Which is better to use and Why?

    Mkaaa15 pointsBadges:
  • Additional TAB in AD Service for Automation

    Do we have a way in that While adding a group for a user in active Directory it should pick a Mail from the Lotus notes as a proof and as a reason for adding that group to a user, it should store the details in one of the common attributes in AD service (like General Tab, Member Of, Organisation...

    Krishp10 pointsBadges:
  • Progress/400 with DB2/400

    Firstly I would like to thank to all that helped me on my doubt with AS/400. We migrated of Progress/400 version 9 for Progress/400 version 10, and now the access to the db2/400 is from ODBC. Can I improve the performance of AS/400 knowing that the tables generated by Genexus version 9 doesn't have...

    SILVARB440 pointsBadges:
  • Trouble opening an inaccessible table in SQL Server 2005

    A client of ours is running SQL Server 2005 with PS2 on Windows Server. His database size is about 5 GB. Every now and then something happens and one table (the most important) becomes inaccessible. When we try to open the table, it gives a “SQL time out” error. This sometimes happens twice a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Echo a variable in PHP which displays as a link

    hi, I have a number of variables that i pull from a mysql database. I want 1 of the variables to show as a link to a web page. i have tried the following code, which displays everything fine, except for the $url bit echo "<p>$djname $genre $biography <a href='/$url'> Profile</a>";...

    Whiteyoh15 pointsBadges:
  • Replication

    Is there any tool that can make some documents replicate faster than the others on the server.The issue overhere is that we have to trigger replication before the appointed time because of some particular documents.Is it possible to make replication faster on that such documents on the server?

    BELLS20 pointsBadges:
  • XML-INTO

    I'm trying to use XML-INTO with %XML to convert an XML document into a DB2 database file. The XML file has four levels of data with elements from each level that need to be used for the database record. Naturally, the relationships between the level are important, too. The levels are Header...

    GLinds0125 pointsBadges:
  • MDE to updating table in backend database

    I inherited a few databases which were created in Access 2000. I only have Access 2003 and I needed to make a new MDE file, I converted to Access 2003 then created the new MDE file. Now the problem is this, the new MDE won't write to the backend database.

    Herdine30 pointsBadges:
  • good PL/SQL user guide

    I am interested in a good reference guild for PL/SQL which explain all utilitity commands and configuration patterns and files. Your help is much appreciated.

    Hfeshari0 pointsBadges:
  • Database connectivity with c++

    How to connect backend(database to C++(front end) ?

    Mkaaa15 pointsBadges:
  • Whats a good tool/software to import (excel, csv) into IBM DB2

    Whats a good tool/software to import (excel, csv) into IBM DB2? Would be great if this tool/software is free or doesn't costs to much. thanks

    Geyes15 pointsBadges:
  • V8 CMP EDM Pool

    Strobe shows very high CPU in Module DSNGEDM Sections DSNGECMP & DSNGEPUF (which free expanded EDM Pool Storage) for dynamic SQL in a CICS Region. Is this an EDM Pool sizing issue?

    Winger19515 pointsBadges:
  • Dynamic sql with delete and commit

    Hi, I need to delete rows from different db2 tables in COBOL with commit in between after some 100 or 200 rows. Is there any away I can restrict my delete statement for some particular rows as in Select for fetch first 100 rows only. The values of table names will be known only during the execution...

    Sramki0 pointsBadges:
  • Unloading specific records in a foreign key, cascade format.

    Hi, We have DB2 version 8, os/390. I know how to use QMF and JCL. I would like to unload, to files, specific records that I would enter, by the key, in a where clause. The record would then cascade down to unload ALL tables, with a specified TBCREATOR name based on foreign keys. I would like the...

    Donnaw5 pointsBadges:
  • Selecting an area within security to start

    Hi, I'm studying for an MSc in Information Security from Royal Holloway University of London, I have a B.Engg. degree in computers and a PG Diploma in Networking and Communication as well as the CCSA and CCNA. I'm also studying for the CISSP. Now, with all these qualifications, could you please...

    Secmax0 pointsBadges:
  • ‘You are not authorized to access that database’ error message for Lotus Notes user

    I have a Lotus Notes user who keeps receiving the error message: "You are not authorized to access that database." when working with his local copy of his email file. To my knowledge, he is not using a different ID file. The first two times this happened, we deleted the local copy of his email file...

    Domino Ask The Experts435 pointsBadges:
  • Report -Conditional Format with multiple conditions: Access 2007

    I am trying to generate a report that will change the font to different color if of a date field but the total number of days will change if another field = ?. So basically if [TYPE] = CHILD then DATE()-30= (red font), and DATE()-31 BETWEEN DATE()- 60= (yellow font) and DATE()-61 BETWEEN DATE()-...

    Nichalos825 pointsBadges:
  • Microsoft Access and Oracle

    Can tables created in Access or Excel be imported into Oracle?

    Micheline foxxe10 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