SPONSORS:






User Tag List

Results 1 to 5 of 5
  1. #1
    Member
    Join Date
    Jan 2001
    Location
    Westborough, mA, USa
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Connecting to a oracle 9i database

    Hi,

    Has anyone connected successfully to an Oracle 9i data base using DB_Connect().

    I need to connect to oracle as a sysdba. There is not documentation in Silk to connect this way.

    Thanks

    Sandeep

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

  2. #2
    Super Member
    Join Date
    Jul 1999
    Location
    Rancho Santa Margarita, CA
    Posts
    1,439
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)

    Re: Connecting to a oracle 9i database

    You should be able to connect to Oracle 9i the same way as you connect to Oracle 7 or Oracle 8i. Double-check your ConnectString to make sure you have the right DSN, UID, and PWD then follow the DBTester functions example from the Online Help.


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

  3. #3
    Member
    Join Date
    Jan 2001
    Location
    Westborough, mA, USa
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Connecting to a oracle 9i database

    Gilbert,

    The command for connecting to an Oracle 9i database, is :
    "connect user/pwd as sysdba"
    Otherwise you get the error message - "
    "connection as user should be as sysdba or sysoper".

    Was just wondering whether Silk has a parameter to specify whether it is a sysdba or sysoper.

    Thanks

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

  4. #4
    Super Member
    Join Date
    Jul 1999
    Location
    Rancho Santa Margarita, CA
    Posts
    1,439
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)

    Re: Connecting to a oracle 9i database

    Sorry Sandeep. I thought you meant you've been doing this type of connection all along successfully in previous Oracle versions (7 or 8i) and only now in 9i that you cannot connect.

    My guess (have not tried it) is to maybe use DB_Connect using your normal UID and PWD and then doing a DB_ExecuteSql () containing the "connect user/pwd as sysdba" in it.
    Hope that works!



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

  5. #5
    Senior Member
    Join Date
    Jun 2000
    Location
    Chicago, IL USA
    Posts
    383
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Connecting to a oracle 9i database

    Yes, I have done it many times and it works (not very well).

    It can be really messy and it gives me a headache just to think about explaining it all.

    The first step is to make sure that you can connect using Oracle SQLPlus. If you can't, then get your local database person to set it up for you. They should give you a UserId and password for a SysDBA. When that is done, look at the settings in the "tnsnames.ora" file -- you will need those for SilkTest.

    Then, you need to configure you ODBC driver in Windows -- search for previous threads that explain that.

    Then you need to know how to use the SilkTest DB functions correctly -- search for previous threads that explain that.

    Hope this helps, let us know how it works.

    ------------------
    Rob Kapteyn

    [This message has been edited by RobKapteyn (edited 08-21-2002).]
    Rob Kapteyn, CSTE
    RobKapteyn@gmail.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 09:26 PM.

Copyright BetaSoft Inc.