By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,269 Members | 1,507 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,269 IT Pros & Developers. It's quick & easy.

Amending a Startup form of an Oracle 6i Application

P: 2
I have recently joined a pharmacuetical company as a Manager M.I.S

I have source code of an oracle application developed in 6i by my predecessor. I am unable to take help from him due to some technical reasons.

All I have is the server administration, source code files for oracle clients.

I have to change the main connection password, but if I do so all the users will be unable to logon to the application.

Does this mean that the connection password to oracle database is hardcoded in the startup form.

There is a file called start.fmb compiles as start.fmx located on all clients PCs. I guess the old password for oracle database connection must be provided in this startup file.

I wish if I could attach the startup form for you and request you to tell me how can I implement the new password into the forms.


Thanks in advance

Amjad Mahmood
Manager M.I.S
Helix Pharma
Karachi
Pakistan
May 28 '07 #1
Share this Question
Share on Google+
2 Replies


debasisdas
Expert 5K+
P: 8,127
Mr. Amjad
welcome to TSDN

It seems u r in some trouble. But your case is bit critical.
I wish i could help u ,but it won't be wise to suggest u anything based on what u guess or what i assume ,without going for details
May 28 '07 #2

P: 2
Thanks for your reply.

I am basically a VBA developer. I have accepted a challanging assignment from my boss (Finance Director, who is also head of IT) to takeover the oracle server administration + oracle Clients technical support. Having a zero level experties on Oracle makes this task ever challenging. The only thing on which I can rely on is my joining of various oracle forums on the internet, puting questions to hundreds of experts available on the net, and learning through their sharing of experience.

THE SCENARIO IS....
ORACLE SERVER 9i IS ON SERVER

ORDER PROCESSING & INVENTORY MANAGEMENT SYSTEM IS DESIGNED USING ORACLE DEVELOPER 6i

FOLLOWING IS HOW AN ORACLE CLIENT CONNECTS TO SERVER
C:\ORANT\BIN\ifrun60.EXE 'D:\project\HSONSCHE\start.fmx' cn=js

ALL FORMS FMX FILES ARE LOCATED ON THE PATH BELOW:
D:\project\HSONSCHE\
ALL REPORTS rep FILES ARE LOCATED ON THE PATH BELOW:
D:\project\HSONSCHE\REPORTS

WHEN I CONNECT TO ORACLE SERVER FROM ANY CLIENT pc
I EXECUTE
C:\orant\BIN\PLUS80W.EXE

IT takes from me input:
username = HSONSCHE
password = hsons
host string=js

THE PROBLEM
I must change the password of username 'HSONSCHE' for security reason, because it is known to many power users across the network, I want to restrict the unauthorized access for any body to go to back-end (e.g. execute an sql and delete or alter the invoices data etc).

THE Connection string sort of commands I find in start.fmb as follows


WHEN-NEW-FORM-INSTANCE

Expand|Select|Wrap|Line Numbers
  1. declare
  2.      a paramlist;
  3. begin
  4.     a:=create_parameter_list('connect_string');
  5.     add_parameter(a,'cn',text_parameter,:parameter.cn);
  6.     new_form('d:\project\hsonsche\logo1',full_rollback,no_query_only,a);
  7. end;
  8.  
  9.  
MY QUESTION IS SAY MY NEW PASSWORD FOR HSONSCHE IS 'JSONS'

WHAT CHANGES I MUST DO IN START.FMB FILE SO THAT THE NEW PASSWORD IS IMPLEMENTED.

PLEASE FEEL FREE TO ASK FOR MORE INFORMATION WHICH I MUST/PROBABLY HAVE MISSED. SINCE ALL SOURCE CODE FILES ARE IN MY CUSTODY , JUST GUIDE ME I WILL GET ALL THE INFORMATION WHICH YOU MAY REQUIRE.

PLEASE PARDON ME IF MY LAYMAN APPROACH TROUBLES YOU.

THANKS A LOT IN ADVANCE




Mr. Amjad
welcome to TSDN

It seems u r in some trouble. But your case is bit critical.
I wish i could help u ,but it won't be wise to suggest u anything based on what u guess or what i assume ,without going for details
May 28 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.