Database connection using Account User

[maxyboy]

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.

max

 

[Shuchi]

Hi,
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.

Regards,
Shuchi