Shulou(Shulou.com)06/01 Report--

By installing the PostgreSQL ODBC driver, and then accessing the database through OTL

Code

Void TestByOtl ()

{

Odbc::otl_connect db

Odbc::otl_connect::otl_initialize ()

Try {

Db.rlogon ("Driver= {PostgreSQL Unicode}; Server=192.168.10.227;Port=5432;Database=pas;Uid=postgres;Pwd=admin12345")

Odbc::otl_cursor::direct_exec (

Db

Create table student (id int, name varchar (30))

);

Odbc::otl_cursor::direct_exec (

Db

"insert into student values (31090012, 'fengyuzaitu@126.com')"

);

}

Catch (odbc::otl_exception& p) {/ / catch OTL exception

Cerr

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.