• Setting up access rights in a SQL Server 2005 database

    Hello, I'm using MS SQL Server 2005. I'm connecting to the server via ADO. I have a question about access rights. Let me explain this with an example. Let's say I have a database named DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3. I want to create a SQL Server user that will have all rights on...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Query

    Hi Team, I have scenario with me. For that I need to create a query. The scenario is as follows: When My Location And Department is equal in the file I want to Multiply Quantity Column with Cost Column and Add it. Loc Dept Quantity Cost 1 10 10 2 1 10 10 3 1 10 11 5 2 10 10 7 For above example in...

    ankit2002770 pointsBadges:
  • Sort and index

    What is the difference between sorting and indexing?

    dksdileep10 pointsBadges:
  • iDB2 connection String permenant solution

    I have a DB2 connection string to our i-Series that works. "DataSource=10.10.10.10;userid=LIVEXML;password=LIVE1;DefaultCollection=DATALIB031;" We have been developing a lot of apps and web services that use this type of connection. My problem is when our i-Series software is upgraded (about every...

    ToddN20006,495 pointsBadges:
  • Connecting C++ to Microsoft Access

    How do you connect Visual c++ to the Microsoft Access database?

    Rich150010 pointsBadges:
  • Improving the initial speed of a SQL query

    I have optimized my SQL query to the maximum extent. The first time I ran the query, it took 7 seconds; the next time it took half a second. Why did this happen? How can I make the query run faster the first time around?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Retrieving data from AS/400 tables with PHP?

    I think I will die! Does anyone know how to get data from a table on AS/400 displayed with PHP through ODBC? I'm starting to go mad. I tried ODBC drivers (iSeries Access client, Client Access). Nothing helps. I have Apache server as localhost on my machine and PHP installed and that works fine. The...

    Avrelivs80 pointsBadges:
  • How to connect to an AS/400 database from a remote PHP script

    Hello. I have a requirement to use a PHP script running under Windows to access a remote DB2/400 on an iSeries. Can anyone please assist in what PHP coding would be needed, thank you! Regards Paul

    PaulTaylor15 pointsBadges:
  • backup and recovery

    details about backup and recovery and suppose i was import data from oracle database. we can export to another database(not oracle)?

    Onlyplsql5 pointsBadges:
  • MySQL syntax

    Hi, Have a table budget When I try this: MySQL: insert into budget values (’Department A’,1,2,200) Department A represents:A Department called A 1 represents: a course no from table course 2 also represents: a course no from table course. It doesn't work. Any suggestions?

    Ak1bo78150 pointsBadges:
  • Store image from a directory into Oracle database using SQL

    I have a directory containing 1000s of photos which I have to upload into Oracle 9i DB. I need to use only SQL plus for this. I want a simple material to upload all those photos.

    cmuraz5 pointsBadges:
  • Timestamp InCOBOL/400

    Can we use Timestamp in COBOL/400. If we can, how?

    Michael Tidmarsh25,445 pointsBadges:
  • Script to extract files information from FTP server

    Hi, I wonder if you could help me with the following please. I would like to construct a script (in any language whichever it's easiest) which when run, it will: Log on to a ftp server using a generic account and password It then find the files (no downloading) in a specific folder that begins with...

    Aiko2720 pointsBadges:
  • Firewall preventing NET USE drive mapping PC to iSeries.

    Does anybody know what ports are used when I run net use * \\servername\share PWD /User:USER ? The firewall is stopping it somewhere although ports 137, 139, 445, and 8471-8477 are open on the firewall. It eventually times out with "System error 53 has occurred - The Network Path was not Found"...

    stropley10 pointsBadges:
  • MS Access 2013

    Does anyone have VB code for add a new value to a lookup table during execution of application?

    Robertar15 pointsBadges:
  • Connect Direct File transmission

    How to confirm whether the file has fully transmitted from source system(say mainframe) to iseries. I know how to check manually using wrkoutq. Mainframe is transmitting FileA to iseries. File transmission itself will take 1 hour to complete or sometimes may take upto 2 hours. iseries job should...

    anuppdas105 pointsBadges:
  • Free IT Book: Official Cert Guide for CCNP Security SECURE 642-637

    This week's free IT book is just what you need if you're planning to take your CCNP Security SECURE 642-637 certification exam. From exam topics and quizzes to exam prep tasks and realistic exam questions, the Official Cert Guide is a must for everyone preparing or planning to prepare for this...

    MelanieYarbrough6,345 pointsBadges:
  • Joining More Than 2 Files

    What is the best way to join more than 2 files using SQLRPGLE with embedded sql?

    TJSDAD35 pointsBadges:
  • How to retrieve, add and update data manually using VB.NET 2005

    Hey guys! I'm quite new to VB.NET 2005. I need to know how to add, update and retrieve data manually using VB.NET 2005. In the software which I'm trying to implement, data is entered in text boxes and then they are updated/added into an SQL table. When retrieving the data, for example: A student is...

    Obhasha0795 pointsBadges:
  • Free IT Book: Fedora and Red Hat Enterprise Linux

    The Practical Guide to Fedora and Red Hat Enterprise Linux serves as both a tutorial and an on-the-job reference. You'll learn to use GUI-based tools, the command line, and Perl scripts, and how to set up key Internet servers. How do you win this book? Simply answer one of five questions and post...

    MelanieYarbrough6,345 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