SPONSORS:






User Tag List

Results 1 to 6 of 6
  1. #1
    Member
    Join Date
    Aug 2000
    Posts
    58
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Connecting to the Database.

    Hi all,

    I have to do the following.

    1. I have to compare two databases.

    so what I want to do is get the Table name, get the Column Name for each table and then get the data from each table for each database.

    But when I tried to put two SQL function i.e. DB_Tables and DB_Columns, I get following error message"

    [ ] *** Error: (HYC00) [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented

    Even when I tried to put one of SQL function inside the for loop, it works for first iteration, then I get the above error message.

    Does anybody know if we can have more than one SQL function in a single testcase.

    Thank you very much.

    Yamini


    ------------------

  2. #2
    Senior Member
    Join Date
    Jul 2001
    Location
    Elizabeth, CO, USA
    Posts
    653
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Connecting to the Database.

    Yes, you can have multiple SQL functions inside of a testcase, but you may need to create a new handle for the second.

    What, exactly, does your testcase look like?

    Additionally, the error you're getting is from the ODBC driver; SilkTest is merely passing the error along. May be that the driver does not support what you're trying to do.

    - Dave


    ------------------
    Amelior Technology
    dreed@ameliortech.com
    WaltzingRhino.com
    A concerned Borland customer, a fly in the ointment, a wrench in the works.

  3. #3
    Member
    Join Date
    Aug 2000
    Posts
    58
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Connecting to the Database.

    Hi Dave,

    In my testcase, I am reading table name from a text file. I am creating a list of Table names.

    Then I am using for loop for ex.

    for each table in listoftables
    Get the column name
    Appendit it to list

    disconnect.

    for first iteration it gives me column names for the first table. for second one I get the error message.

    Thanks.

    yamini

    <BLOCKQUOTE><font size="1" face="Verdana, Arial, Helvetica">quote:</font><HR>Originally posted by dcreed:
    ****Yes, you can have multiple SQL functions inside of a testcase, but you may need to create a new handle for the second.

    ****What, exactly, does your testcase look like?

    ****Additionally, the error you're getting is from the ODBC driver; SilkTest is merely passing the error along. May be that the driver does not support what you're trying to do.

    ****- Dave


    <HR></BLOCKQUOTE>



    ------------------

  4. #4
    Junior Member
    Join Date
    Mar 2001
    Location
    San Jose, CA, US
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Connecting to the Database.

    Looks like it's very common task to compare 2 DB (baseline vs. target). Currrently I'm working on script which somebody created for this company couple years ago.
    DB comparasion (MS Access, SQL server, Oracle server). They said it worked before but not now.
    I made it working for Access now (removed hard coded pathes).

    Let me know if you still has this ussue.
    Yevgeniy
    babichev@hotmail.com

    ------------------


    [This message has been edited by Yevgeniy (edited 08-13-2001).]

  5. #5
    Member
    Join Date
    Aug 2000
    Posts
    58
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Connecting to the Database.

    Hi Yevgeniy,

    I am still having the problem.

    can you help me?

    Yamini
    yaminipatel@hotmail.com

    <BLOCKQUOTE><font size="1" face="Verdana, Arial, Helvetica">quote:</font><HR>Originally posted by Yevgeniy:
    Looks like it's very common task to compare 2 DB (baseline vs. target). Currrently I'm working on script which somebody created for this company couple years ago.
    DB comparasion (MS Access, SQL server, Oracle server). They said it worked before but not now.
    I made it working for Access now (removed hard coded pathes).

    Let me know if you still has this ussue.
    Yevgeniy
    babichev@hotmail.com

    <HR></BLOCKQUOTE>



    ------------------

  6. #6
    Super Member
    Join Date
    Jul 2001
    Location
    Earth
    Posts
    1,882
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Connecting to the Database.

    Did you get help on this? If not, please attach your script so we can take a look at it.

    ------------------
    James Soderborg
    http://www.ameliortech.com
    jamesso@ameliortech.com

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 12:53 AM.

Copyright BetaSoft Inc.