U++ forum: Welcome to the forum

Re: Can I use Upp::Oracle8 connect to Oracle10? [message #9168 is a reply to message #6083]

Thu, 19 April 2007 21:44

Sbleck
Messages: 16
Registered: April 2007
Location: Brazil

Promising Member

Hi,

I tried to see this code running to learn more about U++ and the connection to Oracle databases, but the only result I obtained were errors (a lot of them, unfortunately...). I tried to compile with MingW (and MSC) the code below:

#include <Core/Core.h>
#include <Oracle/Oracle8.h>
#include <iostream>

CONSOLE_APP_MAIN
{
Oracle8 oracle;
Cout() << "Connecting...\n";
Cout() << "Connect state: " << oracle.Open("scott/tiger@prev") << "\n";

Sql sql(oracle);

String cmd = "select * from emp" ;
Cout() << "Executing " << cmd << "...\n";
sql.Execute ( cmd ) ;
Cout() << "Execute done...\n";
// Everything right here..
while( sql.Fetch() ) // this line wrong.. in the function Fetch(), a ASSERTION error...
Cout() << String(sql[0]) << ": " << String(sql[1]) << "\n ";

}

The code above I named it "SQL_Oracle2", because I checked the sintax and compared the code with another example, named "SQL_Oracle". Probably I'm doing something wrong, but I could't find why I had problems with a little piece of code. Please take a look in the attached file, also. If anybody could help, any advice should VERY appreciated...

Tks in adv,
Sven

Attachment: Problems encountered when building the SQL_Oracle sample using MingW and MSC in 04192007.zip
(Size: 141.55KB, Downloaded 430 times)

Report message to a moderator