Page 1 of 3 123 LastLast
Results 1 to 5 of 12

Thread: Connect as SYSDBA in Oracle

  1. #1
    Join Date
    Oct 2008
    Posts
    54

    Question Connect as SYSDBA in Oracle

    Hi

    Is there any chance I can connect as SYSDBA in Oracle? I'm creating a Web Setup project. I tried to add 'DBA Privilege=SYSDBA' to AdoCxnAdditional column of ISSQLDBMetaData table through Direct Editor, but it returns me 'Invalid connection attribute'. Logging in as other users works fine to me (sure, bcoz they're not SYSDBA). Any idea?

    Thanks in advance

  2. #2
    Join Date
    Oct 2001
    Location
    Schaumburg, IL
    Posts
    2,177
    Since the ODBC Driver for Oracle provided from Microsoft does not support the functionality, you need to use the ODBC Driver for Oracle provided from Oracle. Please follow the steps below to change InstallShield using an ODBC driver provided from Oralce:

    1. Go to the ISSQLDBMetaData table in the Direct Editor.
    2. Change the column values as follows:
      AdoDriverName: {Oracle in instantclient11_1}
      AdoCxnServer: DBQ=
      ISAttributes: 6
    3. Rebuild your setp.

    Note that the ODBC driver name may be different from "{Oracle in instantclient11_1}" on your system. Check the Microsoft Data Access - ODBC Administrator that can be launched from the Control Panel to find out what you have on your system.

    Once it is done, you will be able to connect as SYSDBA if you type "AS SYSDBA" after your password such as "mypwd AS SYSDBA" in the Password field on the SQLLogin dialog. If you want to provide a dropdown comobox that has three options; Normal, SYSOPER, and SYSDBA instead of typing the keyword in the password filed, try this:

    1. Add a ComboBox control to the SQLLogin dialog in the Dialog Editor.
    2. Set "CONNECTAS" to the Property setting:
    3. Add the following 3 items:
      Text: "Normal", Value: "Normal"
      Text: "SYSOPER", Value: " AS SYSOPER"
      Text: "SYSDBA", Value: " AS SYSDBA"
    4. Add the following event to the Next button of the SQLLogin dialog:
      Event: [IS_SQLSERVER_PASSWORD]
      Arguemnt: [IS_SQLSERVER_PASSWORD][CONNECTAS]
      Condition: CONNECTAS<>"Normal"
    5. Make sure that the event you added in the previous step is sequenced before the event calling the ISSQLServerValidate action.
    6. Rebuild your setp.


    Hope that helps.
    Last edited by hidenori; 11-17-2008 at 11:43 PM.

  3. #3
    Join Date
    Oct 2008
    Posts
    54
    How can I obtain/install {Oracle in instantclient11_1}? I only have {Microsoft ODBC for Oracle} in ODBC section in Control Panel.

    The latest version I found in Oracle website only Oracle ODBC Drivers for Oracle 10.2
    http://www.oracle.com/technology/sof.../utilsoft.html

    Thanks.

  4. #4
    Join Date
    Oct 2001
    Location
    Schaumburg, IL
    Posts
    2,177
    I used the Instant Client Package - ODBC for my test. The Oracle ODBC Drivers for Oracle 10.2 should work as well.

  5. #5
    Join Date
    Oct 2008
    Posts
    54

    Thumbs up

    Oh really cool...It works! And now I can use InstantClient 11 instead of asking the user to install InstantClient 10 as you recommended at my other thread: http://community.installshield.com/s...=184359&page=2

    Thanks

Page 1 of 3 123 LastLast

Posting Permissions

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