sqlapi mysql_无法使用SQLAPI ++连接到MYSQL

I am new to working on SQLAPI++. I have everything installed, i.e. MYSQL, SQLAPI++ and I am using Code:Block++ as the editor for my C++ program. I was trying to connect to the database that I had created in the MYSQL, but I am unable to. I see the following error when I invoke Connect() written in SQLAPI++

Process returned -1-73741819(0xC0000005) execution time: 0.431s.

The MYSQL is running on my local machine on port no 3306.

int main(int argc, char* argv[])

{

SAConnection con;

SACommand cmd;

int id =0;

string name = "";

cout<

try

{

con.Connect ("sampledb",

"root",

"abcd",

SA_MySQL_Client);

std::cout<

cout<

cmd.setConnection(&con);

cmd.setCommandText("SELECT * FROM sampledb.table1");

cmd.Execute();

while(cmd.FetchNext())

{

id = cmd.Field("id").asLong();

name = cmd.Field("name").asString();

std::cout<

std::cout<

}

con.Commit();

con.Disconnect();

std::cout<

}

catch(SAException &x)

{

try

{

con.Rollback ();

}

catch(SAException &)

{

}

std::cout<

printf("%s\n", (const char*)x.ErrText());

}

return 0;

}

The code compiles successfully. I am running on Windows 10 machine currently. I wonder what could be wrong with the above code. I have a doubt with the way we mention the database address in the Connect function or does it seem to be some other issue?

解决方案

I tried by installing everything again. This time I used CodeBlock 10.0.5, MySQL 5.5 and MySqlConnector C++ 1.1, and it worked without any issues this time around. Probably it was a compatibility issue earlier which was causing the exception. Earlier I had installed the latest version of CodeBlock, i.e. 16 and MySQL 5.7 along with the SQL connector