C / C++ / MFC Discussion Boards

okonur4-Feb-07 9:26

4-Feb-07 9:26

I pressed "new" to create a new data source. Then I selected MySQL ODBC 3.51 Driver and press "advanced". I wrote:
DRIVER={MySQL ODBC 3.51 Driver}
SERVER=localhost
DATABASE=test
UID=onur
PWD=pass
Finally I saved it under Program Files/ODBC/Data Sources
No any error it gave. However, if I dont write the above parameters, it doesnt set up a connection. What is the problem with those parameters? Could you help me?

Re: Adding a MFC ODBC Consumer class

Mark Salsbery4-Feb-07 9:45

Mark Salsbery

4-Feb-07 9:45

okonur wrote:
Could you help me?

I'm trying Poke tongue | ;-P

Does the database "test" exist? It needs to be created and have at least a table or view in it.

What if, instead of using the Advanced button, you choose the driver, click next - I haven't used
MySQL so I don't know, but other database drivers provide their own dialogs for setting up a
datasource.

I don't know what kind of ODBC interface MySQL has but with SQL Server it gives you a chance to
test the datasource connection as well.

Assuming you've setup your new data source correctly, you'll need to select the new datasource to
proceed with making your ODBC consumer class. I still don't think you're getting this far though.

Re: Adding a MFC ODBC Consumer class

okonur4-Feb-07 10:02

okonur

4-Feb-07 10:02

The database "test" exists and has tables in it. I think the problem is with the parameters.

Re: Adding a MFC ODBC Consumer class

Mark Salsbery4-Feb-07 11:43

Mark Salsbery

4-Feb-07 11:43

Yes.

Because I have no life, I downloaded and installed MySQL. Wink | ;)

I've wanted to try it out anyway.

Here's what I did:
Right click on project, choose add class
Select MFC/MFC ODBC Consumer
Click Data Source... button
Click Machine Data Source Tab
Click New Button
Select which type of data source - User or System
Click Next button
Select MySQL ODBC 3.51 driver
Click Next
Click finish
You should see MySQL's ODBC connection setup dialog - Fill in all the info on all tabs
Click the test button - if not succesful fix the info in the dialog
If successful test click ok
You're back at the select datasource dialog - Select the datasource you just created

Now, seeing it in real life - I did a googly search and found this...

MySQL Bugs[^]

hmmm...

Re: Adding a MFC ODBC Consumer class

Hamid_RT5-Feb-07 6:53

Hamid_RT

5-Feb-07 6:53

Is your problem solving? Smile | :)

WhiteSky

Re: Adding a MFC ODBC Consumer class

okonur9-Feb-07 3:32

okonur

9-Feb-07 3:32

I am on holiday Smile | :)

Re: Adding a MFC ODBC Consumer class

Hamid_RT9-Feb-07 5:22

Hamid_RT

9-Feb-07 5:22

Very good;)

WhiteSky

Re: Adding a MFC ODBC Consumer class

David Crow4-Feb-07 17:25

David Crow

4-Feb-07 17:25

See if this article is of any help.

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

Re: Adding a MFC ODBC Consumer class

Mark Salsbery5-Feb-07 7:49

Mark Salsbery

5-Feb-07 7:49

Nice article!

The OPs problem I reproduced is, using MySQL, the 7th dialog in your article never comes up
when using the wizard to create the recordset class.

I wouldn't necessarily expect it to because I was under the impression that getting a list of
tables and views in a database is vendor specific. Am I wrong? Is there a standard SQL
statement to do that?

Thanks,
Mark

Re: Adding a MFC ODBC Consumer class

David Crow5-Feb-07 8:40

David Crow

5-Feb-07 8:40

Mark Salsbery wrote:
Am I wrong? Is there a standard SQL
statement to do that?

I don't know.

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

MAPS

sameer224-Feb-07 6:01

sameer22

4-Feb-07 6:01

Hi everyone
I m new to vc++. Now I m doing my undergraduate project in a wifi location system.
I want to track user's position on aGUI containing a map , but I have no idea about images and maps and how to import them and use them in VC++.
I hope someone will show me a webpage or book about this topic.
Thank U in advance.

Re: MAPS

Waldermort4-Feb-07 6:14

Waldermort

4-Feb-07 6:14

What format are your maps, how many are there and how is the users position being represented?

Re: MAPS

sameer224-Feb-07 6:55

sameer22

4-Feb-07 6:55

The maps are JPEG or CAD but i may convert them if necessary.There are more than 4 maps , depending on where the user is the appropriate floor map will be loaded then user's location will be represented by a dot on the map that represents his actual position.
Thank U.

Re: MAPS

Waldermort4-Feb-07 7:19

Waldermort

4-Feb-07 7:19

I don't know about CAD but OleLoadPicture is able to load a JPEG image into an IPicture instance. Search the article on CP to know how to load the picture. Once loaded you will have HBITMAP which is what most of the GDI functions use when drawing to the screen.

Create a window, or choose a RECT in your main window. Use GetDC() CreateCompatibleDC() SelectObject() and BitBlt(), or StretchBlt(), to draw the picture to the screen. Then draw your dot on top of this image using SetPixel() for a single dot, or Ellipse() if you want something a little bigger.

Re: MAPS

Hamid_RT4-Feb-07 7:43

Hamid_RT

4-Feb-07 7:43

In addition with WalderMort see http://www.wotsit.org[^] about cad files Wink | ;)

WhiteSky

Re: MAPS

sameer224-Feb-07 8:27

sameer22

4-Feb-07 8:27

Thanx , i ll try.
Much Appreciated.

Re: MAPS

Hamid_RT4-Feb-07 8:30

Hamid_RT

4-Feb-07 8:30

You're welcome Wink | ;)

WhiteSky

Re: MAPS

ThatsAlok6-Feb-07 20:18

ThatsAlok

6-Feb-07 20:18

sameer22 wrote:
I want to track user's position on aGUI containing a map , but I have no idea about images and maps and how to import them and use them in VC++.
I hope someone will show me a webpage or book about this topic.

try google api.. search google for same!!!

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow

cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
Support CRY- Child Relief and you

Unable to create an automation project using MFC and a type library

milltooth4-Feb-07 5:35

milltooth

4-Feb-07 5:35

I'm having problems using the following MicroSoft example.
http://support.microsoft.com/kb/178749[^]

When I get to step 6. "Add an include directive for each header file..."

If I try to complile I get 187 errors. Here's the 1st one.

Error 1 error C2371: 'FontPtr' : redefinition; different basic types c:\documents and settings\dan\my documents\visual studio 2005\projects\auotexcel\auotexcel\debug\excel9.tlh 982

I'm running Visual Studio 2005, Microsoft Excel 11.0 Type Library, Windows 2003 Server.

Thanks for any help.
Dan

Global variables [modified]

Makakuin4-Feb-07 5:05

Makakuin

4-Feb-07 5:05

Hi! I`m creating a dialog based application with one main dialog containing TabCtrl each of tabs in TabCtrl contain individual dialog. This application will be used for ticket printing in a museum and each tab is for different ticket type, where you will only need to enter the count of visitors. The ticket prices are held in a database. To avoid the need to access database each time the price of a ticket needs to be read, I want to create a global Struct variable, then on applications InitInstance() read the values in to that variable.

Example:

Struct prices<br />
   {<br />
     double price1;<br />
     double price2;<br />
     double price3;<br />
     double price4;<br />
   };<br />

I tried defining the struct in applications header file, then after class definition in same header I added line:

extern CMyApp::prices price;

Later in applications InitInstance() I call:

CMyApp::prices price;

That way I`m able to access price.price1, price.price2.. etc. in any class.

Iv`e heard about creating seperate class for global variables and then access them like CMyGlobals::Variable...
What is the best way of creating global variables? And what is your opinion of my solution.

Thanx!

-- modified at 11:10 Sunday 4th February, 2007

Re: Global variables

Waldermort4-Feb-07 6:20

Waldermort

4-Feb-07 6:20

Using global variables is often very undesirable in C++. I recommend, instead of creating a global struct, create a singleton class.

class Prices {<br />
private:<br />
  Prices();<br />
  ~Prices();<br />
public:<br />
  static Prices* CreateInstance(){<br />
    static Prices;<br />
    return &Prices;<br />
  }<br />
}

Then, anytime you want to get your prices, just call Prices::CreateInstance().

You could even create the class in such a way that it must be initialized with the ticket prices before CreateInstance will return a pointer.

Re: Global variables

ThatsAlok6-Feb-07 20:19

ThatsAlok

6-Feb-07 20:19

much better would you create singleton class use it through out the project!

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow

cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
Support CRY- Child Relief and you

Saving with property sheet

DanYELL4-Feb-07 4:53

DanYELL

4-Feb-07 4:53

I have a property sheet in a CFormView. The property pages dont
seem to be created until I visit the specific View, so I do not
want to transfer data from a CPtrArray to display in the property
page until the property page is created.

What function can I use in my View or property pages to transfer data
from a CPtrArray to actually display in the property page? I cant use
OnUpdate. If I do, this is called before I visit the property page and before its Window is created. I have not had any luck with OnActiveView in the CFormView (which would then load data from the property pages).
I tried OnSetFocus and that really throws the whole program off; I cant
type data in edit boxes or doing other really small things. I tried
OnInitialUpdate as well.

Im trying to find a function to call in my CFormView class or in the
property pages that will then let me display data on the property
page.

Please, please, any response any one can give me will be greatly
appreciated.

Sincerely,
Danielle Brina

Re: Saving with property sheet

Mark Salsbery4-Feb-07 9:04

Mark Salsbery

4-Feb-07 9:04

In the property pages:

OnInitDialog() is first chance you get to access the page's dialog with a valid HWND.
Just like any dialog, it's a great place to initialize/populate controls.

OnOk() is the last chance.

OnKillActive() gives you a chance to validate user input before allowing the user to switch pages
or leave the sheet.

motion detection

ceejeeb4-Feb-07 3:54

ceejeeb

4-Feb-07 3:54

I have developed an application that grabs frames from a webcam, but i now need to compare these frames for motion(differences). I have had a look around and the only method i found was to compare each pixel in each frame but the speed of this is far to slow to be pratical.
Can any help me out?

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