The SQLCA. DBMS="O90 Oracle9i (9.0.1)"
The SQLCA. LogPass="mangager"
The SQLCA. ServerName="oracle"
The SQLCA. LogId="system"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm=""
Connect using the sqlca;
String usr, password
The SELECT usr. Usr,
Usr. "
INTO: usr,
: password
The FROM usr
WHERE usr. Usr=: sle_1. Text;
If sle_1. Text="" or sle_2. Text=" "then
Messagebox (" error!" The user name or password cannot be empty! "" , the exclamation! , ok! , 2)
The else
If usr=sle_1. Text and password=sle_2. The text then
Messagebox (" authenticated!" , "the user name and password are correct, you are welcome to use this system!" And Information! , ok! , 2)
Open (rushuk)
The else
Messagebox (" error!" , "the user name or password mistake, please input again!" , the exclamation! , ok! , 2)
End the if
End the if
This code is not connect to the database properly, the user name password table, can't enter the account password is wrong, my database table is USR please give advice or comments

CodePudding user response:

What message?

The SQLCA. LogPass="login database password"
The SQLCA. LogId="login database, the user"
Use you create user, the user password

CodePudding user response:

The database login user (table space belonging to a user.)

CodePudding user response:

This is what I create, I have already connected in dbbasa,
On the input interface I enter my user in database, the password still cannot log in

CodePudding user response:

Enter the user name password prompt "user name, password incorrect"
Can't connect the USR list, the inside of the user's password has

CodePudding user response:

See if there are any connection under tracking

CodePudding user response:

Track on

CodePudding user response:

Usr and password two variables a messagebox look at what value