C / C++ / MFC

Cedric Moonen28-Aug-07 1:05

Cedric Moonen

28-Aug-07 1:05

Why would you want such a thing ?

Cédric Moonen
Software developer

Charting control [v1.2]

Russell^'28-Aug-07 1:17

Russell^'

28-Aug-07 1:17

Only to put at the end files too long Cry | :((

to be compiled (of course... I have a very big project), in this way I will compile for first the files that I'm probally editing and, if there is bugs, I'll get errors more soon. Blush | :O

Russell

toxcct28-Aug-07 2:51

toxcct

28-Aug-07 2:51

this is probably because you rebuild all every time, no ?

why don't you just recompile only the units you just modified ?

[VisualCalc][Binary Guide][CommDialogs] | [Forums Guidelines]

Russell^'28-Aug-07 2:56

Russell^'

28-Aug-07 2:56

Yes, of course, in that way I'll obtain a faster result.
But as you know, developing you compile many times per hour the same project and shorcuts are very fine.
So, if it is possible to suggest a custom file order, I'll have only to press F5 as everyone Blush | :O

.
Elseway I'll buy a faster PC. Laugh | :laugh:

Russell

toxcct28-Aug-07 3:04

toxcct

28-Aug-07 3:04

_Russell_ wrote:
But as you know, developing you compile many times per hour the same project and shorcuts are very fine.

i don't really get what you mean here...

[VisualCalc][Binary Guide][CommDialogs] | [Forums Guidelines]

How to Create a toolbar with Bitmap and text

Russell^'28-Aug-07 3:17

Russell^'

28-Aug-07 3:17

toxcct wrote:
i don't really get what you mean here...

Because you are a good programmer Big Grin | :-D

, not like me:
every time I make some changes I put in the project new code with new errors Cry | :((

, so I need to compile it again and again and again to let finally the application run.
Sigh | :sigh:

Then every shortcuts (like F5) are very useful to leave me enough calm, elseway it will drive me crazy. Mad | :mad:

Russell

sudheee27-Aug-07 23:51

sudheee

27-Aug-07 23:51

i want to create a tool bar which should contain both text and bitmap. it should be done in dialog based application
like toolbars in any window(Ex. Back with left arrow, forward with right arrow, save with floppy symbol)
can anyone help me.plz.

thanks in advance

regards
sudhakar

Re: How to Create a toolbar with Bitmap and text

Nishad S28-Aug-07 0:47

Nishad S

28-Aug-07 0:47

You can find a lot of samples here in CP.

One sample here[^]

- NS -

ODBC Reconnect

sanjutvm27-Aug-07 23:44

27-Aug-07 23:44

Hi,

I'm using VC++ 6.0 and ODBC connection to SQL Server.
I need to handle the situation when network is disabled and enabled.
I'm applying a retry logic which will check for db connection and try to reconnect for specified number of times within specified time interval.

When the network is disabled during a db function like open/requery etc.,and enabled within specified time interval, it works fine.

When the network is disabled and enabled before a db call, it fails.

Retry logic is as below:

while(!CheckConnection())
{
Reconnect();
nRetries++;
Sleep(nTimeInterval);
}
if(nRetries < SpecifiedNum)
return TRUE;
else
return FALSE;
}

CheckConnection()
{
.........
SQLRETURN nReturnVal = ::SQLGetConnectAttr(m_hdbc,
SQL_ATTR_CONNECTION_DEAD,
(SQLPOINTER) &nConnectionStatus,
sizeof(SQLINTEGER),
NULL);
...........
}

Reconnet()
{
OpenEx(m_strConnectionString, dwFlags)
}

nReturnVal returns success. So it doesn't again open the DB. So it is failing.

If i check validation and reconnect in overdriven function of CRecordset::Open() it will be applied everytime, even if network was not disabled.

How do I check whether network connection has disabled and enabled before calling a db function?

Thanks & Regards,
Sanju

KarstenK28-Aug-07 1:06

KarstenK

28-Aug-07 1:06

If you close the DB connection after each DB function youre out of it. So an Open should work.

Arent there thrown any exceptions? Handle them carefully. Unsure | :~

Or write a simple SQL statement in a function to test alive-Status. Cool | :cool:

Greetings from Germany

sanjutvm28-Aug-07 3:45

28-Aug-07 3:45

Hi,

Thank you for the reply.
Actually I'm not closing the DB connection in between forcefully. Only when the application exits, i'm closing it.
When the network connection is disabled, the db connection goes of.
So when i open a recordset, i'm getting unhandled exception. It is not even going to the catch block.
So before opening the recordset, i checked for connection, using SQLGetConnectAttr(). When the network is disabled and enabled before caling CRecordset::Open(), SQLConnectAttr() returns SQL_SUCCESS. Since, when the network connection got disabled, i'll be out of DB and I'll have to open it again no?
I need to handle this situation.

Thanks & Regards,
Sanju.

KarstenK28-Aug-07 4:09

KarstenK

28-Aug-07 4:09

Checking the DB connection should be enough.

If you loose the connection all of your handles are invalid, so you need new and VALID handles. For this you got to reopen!!!

Greetings from Germany

sanjutvm28-Aug-07 23:13

28-Aug-07 23:13

Hi,

Thank you for the reply.
I'm using SQLConnectAttr()to check the db connection.
When I disable the network, SQLConnectAttr is returning success.
So I'm not able to check the condition and open the db.
this is how the code is:

SQLRETURN nReturnVal = SQLGetConnectAttr(m_hdbc,SQL_ATTR_CONNECTION_DEAD,
(SQLPOINTERnConnectionStatus,sizeof(SQLINTEGER), NULL);
switch(nReturnVal)
{
case SQL_SUCCESS:
bStatus = (BOOL) ((nConnectionStatus == SQL_CD_TRUE) ? FALSE : TRUE);
break;
case SQL_SUCCESS_WITH_INFO:
...
break;
default:
...
break;
}
The nReturnVal is always SQL_SUCCESS, if network connection is available or not. Based on nReturnVal only, i can reopen the db.

DBMS Name = MS_SQL_SERVER_DBMS
Driver Name(SQLSRV32.DLL)
ODBC Driver Version(03.52)
Driver Version(03.85.1117)

What should i do?

Thanks & Regards,
Sanju

David Crow28-Aug-07 4:20

David Crow

28-Aug-07 4:20

sanjutvm wrote:
So when i open a recordset, i'm getting unhandled exception.

Which implies you should have a try/catch block to handle this.

"A good athlete is the result of a good and worthy opponent." - David Crow

"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

sanjutvm28-Aug-07 21:13

28-Aug-07 21:13

Hi,

Thank you for the reply.

I've catch(CDBException* pDB), catch(CException* e), catch(...). But it is not going to any one of this catch block.

Thanks & Regards,
Sanju

David Crow28-Aug-07 2:45

David Crow

28-Aug-07 2:45

Is IsDestinationReachable() of any help?

"A good athlete is the result of a good and worthy opponent." - David Crow

"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

sanjutvm28-Aug-07 23:30