• Updating the database using information_schema

    I am having database a and b i want to update database a according to updations in database b .b is same as a operations are done on b database and after complition a will get updated for permanent change? how can I do this automatically by using information_schema in sql server 2000

    Mcm5 pointsBadges:
  • Trying To Make A pop up on MS access to come up every time a client needs to pay me..

    So I have a table full of details of my clients.. including when they have to pay me (the date) and how much they have to pay me.. Im not an expert at MS access. i know how to make forms and all that but not this.. can somebody tell me how to get a pop up to come up every three months saying the...

    Helpwithmsaccess5 pointsBadges:
  • Connecting Visual Basic and SQL Server

    After creating ODBC, what code will connect the front-end Visual Basic and the back-end SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • ODBC connectivity to Oracle 10g database from an Oracle 6i client

    Talking through VB Code from a Oracle 6i Client to a 10G database using ODBC.

    Ronneyrajapathirana5 pointsBadges:
  • How to order a list?

    i have a list from a text file in this format: Wence Rollins Hernandez Perry Rollins Dai Holzapfel Hernandez Perry Stelzer Adhikari Darrow Heafey Harmon Dai Steenbock Darrow Bell Steenbock Adhikari Bell Holzapfel Stelzer Heafey i have to put in in a format like this: Wence, Rollins, Dai, Steenbock,...

    Adhikarisubodh5 pointsBadges:
  • AS400 ODBC

    Are the permissions for ODBC authority viewable. I am able to view the users that have the ability to perform odbc, but how do I view whether they have read, write, and delete capabilities. Thanks.

    Mramos110 pointsBadges:
  • How can we automate the DB2/400 used in AS/400 through QTP?

    We want to access the DB2/400 in AS/400 through QTP. So please can you give me reply how we can connect the DB2/400 through QTP? Actually we are not getting the database where stored in AS/400.

    DBconnectivitywithQTP5 pointsBadges:
  • How to perform efficient testing of the Data Base Fail over (DBFO) mechanism?

    We have Server connected to Primary, Secondary DB instance. If any of these DB instance is shutdown, forced to shutdown, network disconnected etc, then server will failover to the secondary db and viceversa. We want to test the 'DB Connection Pooling' feature involved in the DBFO mechanism. Also,...

    Saimadhu455 pointsBadges:
  • Replication history

    Hi there, 1) I try to replicate a database from our sister company plant via VPN, but the problem is the replication cannot started and an error message prompted -> "Unable to locate program : nwrdaemn.dll". 2) I also cannot open the database using Notes Server id even though the server ID has...

    Anevil140 pointsBadges:
  • Importing addresses via .CSV as a new contact group

    I am working on sending out a mass email based on a list of names received as a .csv. I have converted this file to a .wk4 and a .wk1 and I am able to import the names, however, when trying to import the names as a group they appear as seperate contacts. Is there anyway to import all of these names...

    Saylorjr5 pointsBadges:
  • Handling null values in XMLType function

    I have xmlfile stored in table in CLOB column.It contains some null rows with some spaces. While parsing that column, am using xmltype function on that column, then it is giving error :LPX-00229 input source is empty, beacuse of null clob columns. I have to craete an function index also using...

    Cirysha10 pointsBadges:
  • where does the file get created in AS/400 system when we fire embedded INSERT query in an RPGLE program

    we are inserting deptid in departments table using the following INSERT statement: INSERT INTO departments (department_id, department_name ) VALUES (30, ':Purchasing'); so where does the departments file get created in As/400 system? when we are doing a runqry on departments file, it is giving the...

    Mohan K695 pointsBadges:
  • indexes on a large table

    hello, i got a 5milion rows on a single table, my database is sql2005 and my select is : SELECT top * FROM tbl1 WHERE ip_from <= 3515134258 and ip_to >= 3515134258 the 3515134258 is on a sample but the format is similar: SELECT top 1 * FROM tbl1 WHERE ip_from <= [value] and ip_to >=...

    Bbbttt15 pointsBadges:
  • MS Access & EDI

    Is there a way to use MS Access to interface with a database that uses EDI? If so, what do I need to do to do this & where can I get more info on this?

    Axcel5 pointsBadges:
  • Page up and page down coding for embedded SQL

    I want to code loading a single page subfile through Embedded SQL. How do I handle the page up and page down key in that program?

    AS400 - Ask the Expert485 pointsBadges:
  • Export from database to Excel and filter by DropDownList

    please provide me with all information on how to export my data to an excel sheet and how to filter the data using a dropdownlist (asp.net)

    Yaz5 pointsBadges:
  • Combo box date/alpa field

    Can it be done and how... I create a combo box and I want the field to have some alpha some numeric. the drop down will say "N/A". But if they want to put a date in that field, should be able to. My testing show it has to be either or. Also when I type in the year in that field, I will be typing...

    Slcart115 pointsBadges:
  • Configureing DTC in Windows 2008 64 bit clustering with SQL 2008 std 64 bit

    I have read some limited blogs and kb articles about this DTC setup in windows 2008 clustering with SQL 2008. I like to get some clarification about this DTC setup. Our shop doesn't use distributed transactions but we do use transactional replication. So our DTC is mostly used in SQL related...

    OceanDeep15 pointsBadges:
  • ODBC in AS/400, OS/400, System i, i5/OS

    Where can I find an ODBC Driver for AS/400? I asked this because I would like to setup an ODBC in AS/400 to connect Lotus Notes (in AS/400) to MySQL (in Windows).

    Yinphin15 pointsBadges:
  • Advice on buying new PC

    I have a Pentium 4 & need to upgrade. I teach Microsoft, use graphics in my manuals, & use CorelDraw a lot. I also design huge Excel spreadsheets with lots of formulas and design databases in Access - what would be a good PC processor, ram, etc? I have been quoted on a system with a Quadcor...

    Shazzie70 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