Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Database connection using Account User

Database connection using Account User

Database connection using Account User

I have an MTS package containing a dll that must connect to an Oracle database. My understanding is that I should create an account for this package (rather than using an interactive user). How do I use the account to connect to the database i.e. can I find the username/password of the account from within the dll? or am I just getting in a muddle.


RE: Database connection using Account User

The user name and password which u specify while creating a package is not ur database login info. Its the info which ur presentation layer will use to connect to MTS server to access the package. It also has an advantage. If u r specifying the username and password for a package then ur MTS server need not be logged in into always. It should just be UP ( at login screen). But if u select the interactive user option then somebody has to be logged in to ur MTS server always.
So, i would suggest just specify the username and password hile creating a package and forget about it. It has nothing to do with ur database.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close