C / C++ / MFC Discussion Boards

David Crow15-Oct-07 4:22

15-Oct-07 4:22

Programm3r wrote:
Yes I am using SQLExecDirect(), can I use the return message to establish whether a connection exists or not?

What does it return when you try and interact using a dropped connection?

"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

Re: Test Database Connection

Programm3r15-Oct-07 4:48

Programm3r

15-Oct-07 4:48

I haven't check it yet, but it would make sense to use the return message, the return code is -1. But the return code when a sql error occurs, is also -1. Thus going on the return code is not accurate, but I can get a hold of the return message. Which I can use to see what the real problem was. Making use of SQLGetDiagRec(SQL_HANDLE_STMT, hstmt, 1, sqlState, &nativeErr, Msg, sizeof(Msg), &TextLengthPtr); function.

Thanks for the advice David.
Regards,

The only programmers that are better that C programmers are those who code in 1's and 0's Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Test Database Connection

David Crow15-Oct-07 5:02

David Crow

15-Oct-07 5:02

Programm3r wrote:
Making use of SQLGetDiagRec...

Which is what I was implying.

"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

Re: Test Database Connection

James R. Twine15-Oct-07 7:50

James R. Twine

15-Oct-07 7:50

A Q&D way to ensure that you are correctly roundtripping to the RDBMS and successfully executing SQL is to execute something like:

select 1

-or if using Oracle:

select 1 from dual

   If you get back a successful return code with a result column of "1", then you know everything is working correctly.

   Note: this is a fairly heavyweight solution to what may be an easy problem, depending on the API(s) you have avaialble for your target RDBMSes. But it might be easier than decoding error messages from different RDBMSse...

   Peace!

-=- James
Please rate this message - let me know if I helped or not!<HR>If you think it costs a lot to do it right, just wait until you find out how much it costs to do it wrong!
Avoid driving a vehicle taller than you and remember that Professional Driver on Closed Course does not mean your Dumb Ass on a Public Road!
See DeleteFXPFiles

Re: Test Database Connection

Programm3r15-Oct-07 19:47

Programm3r

15-Oct-07 19:47

Thanks James Smile | :)

Sounds simply enough

Regards,

The only programmers that are better that C programmers are those who code in 1's and 0's Green Alien | [Alien]

Programm3r
My Blog: ^_^

an application can create .exe file by some conditions

jarful15-Oct-07 3:33

jarful

15-Oct-07 3:33

How to do it?
I want to create an application with VC,and the application can create .exe file
Such as,software can produce electronic album
I have no idea,please introduce some skills about this.
Sorry,My english is not very good. Sniff | :^)

Re: an application can create .exe file by some conditions

David Crow15-Oct-07 3:49

David Crow

15-Oct-07 3:49

In order to create a .exe file, you first need to become very familiar with the PE file format. As you are an obvious beginner, I would advise against it. Stick with something more on your skill level.

"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

Re: an application can create .exe file by some conditions

Matthew Faithfull15-Oct-07 3:51

Matthew Faithfull

15-Oct-07 3:51

If you want to write a compiler that can create .exe files then you need to know about the PE (Portable Executable) format. This defines the header format and internal layout for executable files on Windows. There are articles on Code Project about the PE header format and Microsoft have some Knowledge Base articles on in, there are tools on www.sysinternals.com and on Code Project for examining PE headers and you'll probably want a book or two on compilers as well. Good luck.

Nothing is exactly what it seems but everything with seems can be unpicked.

Re: an application can create .exe file by some conditions

Hamid_RT15-Oct-07 19:36

Hamid_RT

15-Oct-07 19:36

If you search on the www.codeguru.com you can find an article on that article it tells detaily about exe files.

php and vc++ compatible encryption algorithm???

programmer8115-Oct-07 2:45

programmer81

15-Oct-07 2:45

Hi All,

I need to decrypt a file encrypted by a php script..it can be any algorithm which is good enough and cannot be cracked easily..if it cannot be cracked at all will be the best solution..but for now i am just looking for any of the encryption algorithm that can encrypt the data good enough not to be cracked..easily...and that can be decrypted easily using VC++...can someone help me out in doing the same..I need it very urgently...any of the algorithm..Rijndael..or Blowfish or anyone..but it can also be decrypted easily..

Thanks a lot..
Regards

checking browser

mitok15-Oct-07 2:28

mitok

15-Oct-07 2:28

hi! i have explorer window and i should check "does my window have parent folder", only check, don't browse(!) i use COM interface IShellBrowser? but it doesn't help me, because i need only checking.
Does anybody have such experience ?

thanks for answers. Smile | :)

Re: checking browser

David Crow15-Oct-07 3:20

David Crow

15-Oct-07 3:20

mitok wrote:
...i should check "does my window have parent folder"...

"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

Re: checking browser

Hamid_RT15-Oct-07 19:40

Hamid_RT

15-Oct-07 19:40

Can you more explain?

Re: checking browser

mitok16-Oct-07 1:02

mitok

16-Oct-07 1:02

yes , i can. i'm developing a plugin for Windows Explorer (windows Vista). I have windows explorer and i need to check when in my window - desktop! in other words there isn't parent folder of folder which is opened in my explorer window. (but don't browse). application shouldn't depend on concrete language.

thanks for answers.

How to add strings in CStringArray object?

Atul2315-Oct-07 2:23

Atul23

15-Oct-07 2:23

Hi All,

I am using CStringArray object for adding number of strings in it. I used following code

m_HTML_Page_arry->SetAt(i,strPagePath);

where m_HTML_page_arry is declared as CStringArray *m_HTML_page_arry in .h file of this class. I got assertion on the above code. So if anybody have solution to this then plz forward it to me.

Atul

Re: How to add strings in CStringArray object?

Nishad S15-Oct-07 2:28

Nishad S

15-Oct-07 2:28

Use Add

- NS -

Re: How to add strings in CStringArray object?

Atul2315-Oct-07 2:40

Atul23

15-Oct-07 2:40

Hi

I use Add as following way, though there is Assertion, what is the problem in this code.

m_HTML_Page_arry->Add(strPagePath);

Thanks in Advance

Atul

Re: How to add strings in CStringArray object?

chandu00415-Oct-07 2:53

chandu004

15-Oct-07 2:53

have you allocated memory for this?
m_HTML_Page_arry

Suggestion to the members:
prefix your main thread subject with [SOLVED] if it is solved.
chandu.

Re: How to add strings in CStringArray object?

Atul2315-Oct-07 2:56

Atul23

15-Oct-07 2:56

Hi Chandu,

I did not allocate memory to m_HTML_Page_arry object. I used it directly. So can I allocate memory to it.

Thanks in advance

Atul

Re: How to add strings in CStringArray object?

chandu00415-Oct-07 3:02

chandu004

15-Oct-07 3:02

allocate it and see.

Suggestion to the members:
prefix your main thread subject with [SOLVED] if it is solved.
chandu.

Re: How to add strings in CStringArray object?

David Crow15-Oct-07 3:47

David Crow

15-Oct-07 3:47

Do you have something akin to:

m_HTML_Page_arry = new CStringArray;

Why are you not just using an actual object rather than a pointer to one? Most of the time, this indicates a design flaw.

"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

Re: How to add strings in CStringArray object? SOLVED

Atul2315-Oct-07 4:16

Atul23

15-Oct-07 4:16

Hi David,

Thank u very much.. problem gets solved

Atul

Re: How to add strings in CStringArray object? SOLVED

Hamid_RT15-Oct-07 19:42

Hamid_RT

15-Oct-07 19:42

And in the end remember you must delete this object.

Need local C++/WinMobile consulting help

billsh15-Oct-07 2:08

billsh

15-Oct-07 2:08

Hello:

Looking for local (around Western Philadelphia, PA suburbs -- preferably Exton/Malvern area) person with experience coding C++ Windows Mobile apps.
SQL Server 2000/2005 experience helps.

Please send me a note if you are local and interested.

Please (please) no recruiters and check the map to see if you are local first. India is not local Smile | :)

Thanks
~Bill

Conversion

Deepa Nonu15-Oct-07 2:01

Deepa Nonu

15-Oct-07 2:01

How could I convert a BSTR value to an enum value in a COM class???

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.