win7+qt5.2.0 connection oracle11g problem and its solving method

After establishing the connection with the following code, there are a few problems

[HTML]View Plaincopy

2. Connecting to a database
4. Qsqldatabase db = qsqldatabase:: Adddatabase ("Qoci");
6. /** Connecting the Oracle Database
8. * Database name: ABC
10. * Table Name: my_oracle
12. * User name: sys
14. * Password: 123
16. * Port number: (default) 1521
18. */
20. Db.setport (1521);
22. Db.sethostname ("localhost");
24. Db.setdatabasename ("abc");
26. Db.setusername ("sys");
28. Db.setpassword ("123");
30. if (!db.open ())
32. {
34. Link database failed ";
36. Db.lasterror (). text ();
38. return false;
40. }

When you export the contents of Db.lasterror (). Text () to a label, the following questions appear:

1. Prompt: Driver not loaded

Workaround: Copy the folder sqldrivers under the Qt installation directory C:\Qt\Qt5.2.0\5.2.0\Src\qtbase\plugins to your own project file build-linkoracle-desktop_qt_5_2_0_ Mingw_32bit-debug\ theDebug directory.

There are four files in the folder sqldrivers: Libqsqloci.a, LIBQSQLOCID.A, Qsqloci.dll,qsqlocid.dll

2. Prompt: ORA-28009: Should establish the SYS connection unable to logon as SYSDBA identity or sysoper identity

Workaround: Create a new user, connect with the new user, and connect successfully.