Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256

    Unanswered: Access front-end for calling an ORACLE procedure

    We need to use an ORACLE stored procedure for some time to manipulate order-lines order for order.
    I am looking for a way to make this user-friendly. I do not want to hand TOAD or SQL-PLUS to a user, but was thinking about creating an Access front-end.
    Has some-one dabbled with such requirements?
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  2. #2
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    I would use the ado connection objecct.

    You will probably need to translate your cursors to Access recordsets, but you can execute action queries directly with the SQL.

    Here is the connection string I use:
    Provider=MSDAORA;User ID=UID;Password=PWD;Data Source=TNSNAME;

    Here is a link for more connection strings:

    http://tinyurl.com/crqz
    All code ADO/ADOX unless otherwise specified.
    Mike.

Posting Permissions

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