mysql - SQLConnect Fails With Data source name not found, and no default driver specified C++ -


i have installed unixodbc , having ubuntu 14. below 

#cat /etc/odbc.ini  [mariadb] description     = odbc mariadb  driver              = /usr/lib/x86_64-linux-gnu/libmaodbc.so setup               = /usr/lib/x86_64-linux-gnu/odbc/libodbcmys.so usagecount      = 1

and 

# cat /etc/odbcinst.ini  [mariadb] description     = odbc mariadb  driver              = /usr/lib/x86_64-linux-gnu/libmaodbc.so setup               = /usr/lib/x86_64-linux-gnu/odbc/libodbcmys.so usagecount      = 1  // sqlconnect_ref.cpp // compile with: odbc32.lib #include <sqlext.h> #include <mysql/mysql.h> #include <stdlib.h> #include <iostream> #include <sstream> #include <string>  using namespace std;  void extract_error(char *fn, sqlhandle handle, sqlsmallint type) {     sqlinteger = 0;     sqlinteger nativeerror;     sqlchar sqlstate[ 7 ];     sqlchar messagetext[256];     sqlsmallint textlength;     sqlreturn ret;      std::cout << "\nthe driver reported following error \n" << fn;         {         ret = sqlgetdiagrec(type, handle, ++i, sqlstate, &nativeerror,                         messagetext, sizeof(messagetext), &textlength);         if (sql_succeeded(ret)) { //            std::cout << "%s:%ld:%ld:%s\n" << sqlstate << (long) <<          (long) nativeerror << messagetext;          std::cout << sqlstate << (long) << (long) nativeerror << messagetext<<std::endl;         } } while( ret == sql_success ); }   #define check_error(e, s, h, t) ({\         if (e!=sql_success && e != sql_success_with_info)       {extract_error(s, h, t); return 1;} \ })  int main() {    sqlhenv henv;    sqlhdbc hdbc;    sqlhstmt hstmt;    sqlreturn retcode;    sqlchar * outconnstr = (sqlchar * )malloc(255);   sqlsmallint * outconnstrlen = (sqlsmallint *)malloc(255);    // allocate environment handle   retcode = sqlallochandle(sql_handle_env, sql_null_handle, &henv);    // set odbc version environment attribute   if (retcode == sql_success || retcode == sql_success_with_info) {   retcode = sqlsetenvattr(henv, sql_attr_odbc_version,      (void*)sql_ov_odbc3, 0);    // allocate connection handle       if (retcode == sql_success || retcode == sql_success_with_info) {      retcode = sqlallochandle(sql_handle_dbc, henv, &hdbc);       // set login timeout 5 seconds      if (retcode == sql_success || retcode == sql_success_with_info) {         sqlsetconnectattr(hdbc, sql_login_timeout, (sqlpointer)5, 0);           // connect data source        // retcode = sqlconnect(hdbc, connstr, sql_nts, (sqlchar*) null, 0, null, 0);     retcode = sqlconnect( hdbc,             (sqlchar*) "mydb", sql_nts,             (sqlchar*) "", sql_nts,             (sqlchar*) "", sql_nts );         check_error(retcode, (char *)"sqlconnect", hdbc, sql_handle_dbc);          // allocate statement handle         if (retcode == sql_success || retcode == sql_success_with_info) {            retcode = sqlallochandle(sql_handle_stmt, hdbc, &hstmt);             // process data            if (retcode == sql_success || retcode == sql_success_with_info) {              std::ostringstream createtablednstr;             createtablednstr << "create table mytable\n"             << "(\n"             << "    myid    integer    auto_increment primary key,\n"             << "    dummy   integer    not null\n"             << ")"             << "    engine = myisam\n";              retcode = sqlprepare(hstmt, (sqlchar *)createtablednstr.str().c_str(),sql_nts);             if (retcode != sql_success)             {                            std::cout << "sqlprepare retcode != sql_success";              }             retcode = sqlexecute(hstmt);             if (retcode != sql_success)             {                  std::cout << "sqlexecute retcode != sql_success";              }                sqlfreehandle(sql_handle_stmt, hstmt);            }            else { std::cout << "sqlallochandle error" << std::endl; }             sqldisconnect(hdbc);         }         else { std::cout << "sqlconnect error" << std::endl; }          sqlfreehandle(sql_handle_dbc, hdbc);      }   }   sqlfreehandle(sql_handle_env, henv);    } }

i compiled

g++ odbc.cpp -l odbc

when run driver reported following error 

sqlconnectim00210[unixodbc][driver manager]data source name not found,       , no default driver specified

is have right configuration in .ini files or missing .

can please guide same ?

thanks in advance.

  sdk


Comments

Post a Comment

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

actually have store importing products store product data insert , update image or image url not insert , update. this xml code name datapro.txt. <products_joined> <productcode>3710_012t</productcode> <vendor_partno>eah5450silent/di/1gd3(lp)</vendor_partno> <productname>test product ta</productname> <hideproduct>n</hideproduct> <stockstatus>20</stockstatus> <lastmodified>1/5/2016 10:25:00 am</lastmodified> <lastmodby>2</lastmodby> <productweight>0.9</productweight> <productprice>100</productprice> <productmanufacturer>asus tek</productmanufacturer> <vendor_price>32.69</vendor_price> <numproductssharingstock>0</numproductssharingstock> <categoryids>107</categoryids> <producturl>http://tebkq.mvlce.servertrust.com/productdetails.asp?productcode=3710_012t</producturl...
Read more

Laravel mail error `Swift_TransportException in StreamBuffer.php line 269: Connection could not be established with host smtp.gmail.com [ #0]` -

i developing website contact-us page guest users can send me email using gmail . anytime try send mail using contact-us form, error swift_transportexception in streambuffer.php line 269: connection not established host smtp.gmail.com [ #0] this mail.php return [ 'driver' => env('mail_driver', 'smtp'), 'host' => env('mail_host', 'smtp.gmail.com'), 'port' => 587, 'from' => ['address' => '', 'name' => ''], 'encryption' => env('mail_encryption', 'tls'), 'username' => env('mail_username'), 'password' => env(mail_password), 'sendmail' => '/usr/sbin/sendmail -bs', 'pretend' => env('mail_pretend', false), ]; this .env mail_driver=smtp mail_host=smtp.gmail.com mail_port=587 mail_username=afecjaped@gmail.com mail_password=********...
Read more

c# SetCompatibleTextRenderingDefault must be called before the first -

i tried search exception couldn't find solution on case i'am using code below invoke .net application : assembly assem = assembly.load(data); methodinfo method = assem.entrypoint; var o = activator.createinstance(method.declaringtype); method.invoke(o, null); the application invoked has form , in entrypoint of application : [stathread] static void main() { application.enablevisualstyles(); application.setcompatibletextrenderingdefault(false); //exception application.run(new form1()); } setcompatibletextrenderingdefault must called before first iwin32window object created in application. edit : assembly = assembly.load(data); methodinfo method = a.gettype().getmethod("start"); var o = activator.createinstance(method.declaringtype); method.invoke(o, null); you should create new method skips initialization...
Read more