C / C++ / MFC Discussion Boards

Wamuti14-Sep-07 4:58

14-Sep-07 4:58

Does this mean that i don't include the second table while creating the project? If this is so, what will i do while assigning variable for the table i leave out while in the class wizard in the Member variables? Thanks, i am learning alot Smile | :)

Wamuti: Any man can be an island, but islands to need water around them!
Edmund Burke: No one could make a greater mistake than he who did nothing because he could do only a little.

Re: ODBC readOnly problem

David Crow14-Sep-07 6:02

David Crow

14-Sep-07 6:02

Wamuti wrote:
Does this mean that i don't include the second table while creating the project?

You'll need multiple recordsets. The one you currently have is for viewing, while updating the tables would require additional recordsets.

"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: ODBC readOnly problem

Wamuti15-Sep-07 5:11

Wamuti

15-Sep-07 5:11

Thanks. I am working on it Big Grin | :-D

Wamuti: Any man can be an island, but islands to need water around them!
Edmund Burke: No one could make a greater mistake than he who did nothing because he could do only a little.

How to run application

john563213-Sep-07 23:23

john5632

13-Sep-07 23:23

Hi,
How can I run MS-Outlook through code.

Thanx in advance.

Re: How to run application

Hamid_RT13-Sep-07 23:31

Hamid_RT

13-Sep-07 23:31

See ShellExecute function.

Re: How to run application

nbugalia14-Sep-07 0:07

nbugalia

14-Sep-07 0:07

Also see CreateProcess api.

Re: How to run application

Mark Salsbery14-Sep-07 7:15

Mark Salsbery

14-Sep-07 7:15

Also see here[^]

Mark

Mark Salsbery
Microsoft MVP - Visual C++
Java | [Coffee]

How to automate the DSN creation for a database.

chandu00413-Sep-07 23:04

chandu004

13-Sep-07 23:04

hi,
say for example,
i have created one database application in vc, and i access the MS access database through that.
so first i create a DSN from control panel\odbc datasources.
obviously i have to access that database through the dsn from vc++.
now if i want to install it on my clients machine, i have to copy the files first, then map the DSN and then run the application.
now what i want is, is there any method to automate the creation of DSN, such that, just by a single click on my application, this DSN gets created.
thanks.

Re: How to automate the DSN creation for a database.

jhwurmbach13-Sep-07 23:11

jhwurmbach

13-Sep-07 23:11

There are a lot of setup-generation suites that allow you to start scripts during the setup-process.
One of these is NSIS[^], and its free even for commercial use.
There are many others. Just google.

Though I speak with the tongues of men and of angels, and have not money, I am become as a sounding brass, or a tinkling cymbal.
George Orwell, "Keep the Aspidistra Flying", Opening words

Re: How to automate the DSN creation for a database.

chandu00413-Sep-07 23:19

chandu004

13-Sep-07 23:19

thanks for your reply.
i shall verify the tool.
but i wanted some code snippet which can create the dsn if i supply the database filename and dsn name.

Re: How to automate the DSN creation for a database.

jhwurmbach13-Sep-07 23:21

jhwurmbach

13-Sep-07 23:21

To be honest, I have not the faintest idea what 'dsn' is.
But as you seemed to know how to make one, I showed you a way how to automate that on your client computers.

Though I speak with the tongues of men and of angels, and have not money, I am become as a sounding brass, or a tinkling cymbal.
George Orwell, "Keep the Aspidistra Flying", Opening words

Re: How to automate the DSN creation for a database.

Wamuti14-Sep-07 4:54

Wamuti

14-Sep-07 4:54

DSN means Data Source Name(I also have known it today!) Laugh | :laugh:

. I guess it is the name that C++ will use in connection to a driver to a database.

Wamuti: Any man can be an island, but islands to need water around them!
Edmund Burke: No one could make a greater mistake than he who did nothing because he could do only a little.

Re: How to automate the DSN creation for a database.

Dave Kreskowiak14-Sep-07 5:44

Dave Kreskowiak

14-Sep-07 5:44

And DSN's are just about competely useless in todays environment...

Unless you're actually going for lower performance and a more "generic" approach to database work.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: How to automate the DSN creation for a database.

Wamuti15-Sep-07 5:05

Wamuti

15-Sep-07 5:05

Dave Kreskowiak wrote: And DSN's are just about competely useless in todays environment... Unless you're actually going for lower performance and a more "generic" approach to database work.

Okay, i am interested! What makes you say so Confused | :confused:

What is the better alternative?

Wamuti: Any man can be an island, but islands to need water around them!
Edmund Burke: No one could make a greater mistake than he who did nothing because he could do only a little.

Re: How to automate the DSN creation for a database.

Dave Kreskowiak15-Sep-07 6:21

Dave Kreskowiak

15-Sep-07 6:21

How about I sum it up with a couple articles. They're a bit on the old side, but they both still hold true, today even more so...

OLEDB For Me[^]
ACCESS DATABASES (DSN vs DSN-LESS)[^]

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: How to automate the DSN creation for a database.

Wamuti16-Sep-07 1:14

Wamuti

16-Sep-07 1:14

Thanks

! Just got your mail. I am going through them right now Big Grin | :-D

Thank, i'll sure get back to you. Smile | :)

Wamuti: Any man can be an island, but islands to need water around them!
Edmund Burke: No one could make a greater mistake than he who did nothing because he could do only a little.

Re: How to automate the DSN creation for a database.

David Crow14-Sep-07 3:04

David Crow

14-Sep-07 3:04

chandu004 wrote:
...is there any method to automate the creation of DSN...

Yes, but why not just use a DSN-less 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: How to automate the DSN creation for a database.

Mark Salsbery14-Sep-07 7:21

Mark Salsbery

14-Sep-07 7:21

To configure data sources programatically, see

Installing and Configuring the ODBC Software[^]

particularly the sections "Configuring Data Sources" and "Registry Entries for Data Sources".

Mark

Mark Salsbery
Microsoft MVP - Visual C++
Java | [Coffee]

Please Help

Programm3r13-Sep-07 22:44

Programm3r

13-Sep-07 22:44

Hi all,

What can I do to prevent the following:

Invalid Cursor State Error with the MS Oracle ODBC Driver

I have visited this link: Invalid Cursor State[^] and tried what they suggested, i.e: If using the ODBC API directly, call SQLPrepare() before calling SQLExecute() and SQLExtenedFetch() to refresh the recordset. But it is not working, I still receive the error. I have notied that if I create a new recordset for each sql statement is works, but that creates huge memory leaks.

Can anyone please help me ???
Many Thanks
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: ^_^

How to identify Enter Key pressed by user ?

Atul2313-Sep-07 22:44

Atul23

13-Sep-07 22:44

Hi All,

In my project I want to check Whether user press Enter key or not after type a text in text box. In which event I have to check it and how can i check it.

Thanks in Advance

Atul

Re: How to identify Enter Key pressed by user ?

chandu00413-Sep-07 22:52

chandu004

13-Sep-07 22:52

try using the pretranslatemessage handler.
but here, you have to implement your own logic.
any mmore clarification required, get back.

Re: How to identify Enter Key pressed by user ?

Maxwell Chen13-Sep-07 22:52

Maxwell Chen

13-Sep-07 22:52

What type is the project?

Maxwell Chen

Re: How to identify Enter Key pressed by user ?

sps-itsec4613-Sep-07 23:16

sps-itsec46

13-Sep-07 23:16

This should help:

http://www.codeproject.com/dialog/pretransdialog01.asp[^]

cheers!
mykel

OMM: "Let us be thankful we have an occupation to fill. Work hard, increase production, prevent accidents and be happy."

Re: How to identify Enter Key pressed by user ?

Hamid_RT13-Sep-07 23:34

Hamid_RT

13-Sep-07 23:34

Did you use of PreTranslateMessage .

Re: How to identify Enter Key pressed by user ?

David Crow14-Sep-07 3:17

David Crow

14-Sep-07 3:17

The use of PreTranslateMessage() *might* work, but most implementations are incorrect. The other downside is that it permanently ties the child control to the parent. A better solution is to derive a class from CEdit. Override the OnGetDlgCode() method and return DLGC_WANTALLKEYS. Then override the OnChar() method like:

void CMyEdit::OnChar( UINT nChar, UINT nRepCnt, UINT nFlags ) 
{
    switch (nChar)
    {
        case VK_RETURN:
            GetParent()->SendMessage(some_custom_msg, GetDlgCtrlID(), (LPARAM) this);
            return;
    }
 
    CEdit::OnChar( nChar, nRepCnt, nFlags );
}

When the edit control "sees" the Enter key, it posts a message to the parent indicating such. The parent can then respond accordingly, if at all.

"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

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