Skip to main content

[archive] COBOL login to Oracle

  • March 19, 2008
  • 1 reply
  • 0 views
D

[Migrated content. Thread originally posted on 18 March 2008]

Once I setup a user in Oracle as externally identified as in OPS$user I am able to login as that user via telnet and issue a ?sqlplus /? command and I am in without username or password specified just as it should work.

Having set that up how would the connect statement need to look to support automatic Login?


EXEC SQL
CONNECT ???
END-EXEC


I could not find an example to represent this.

I tried

CONNECT : username/password

and CONNECT : /

but nothing works.

Thanks

    1 reply

    D

    [Migrated content. Thread originally posted on 18 March 2008]

    Once I setup a user in Oracle as externally identified as in OPS$user I am able to login as that user via telnet and issue a ?sqlplus /? command and I am in without username or password specified just as it should work.

    Having set that up how would the connect statement need to look to support automatic Login?


    EXEC SQL
    CONNECT ???
    END-EXEC


    I could not find an example to represent this.

    I tried

    CONNECT : username/password

    and CONNECT : /

    but nothing works.

    Thanks
    EXEC SQL CONNECT TO :dsn-name as C1
    USER :userid USING :passwd
    END-EXEC.

    There are embedded SQL example programs, check out the \\AcuGT\\sample\\acusql\\oracle examples

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement