C / C++ / MFC

1-Sep-10 0:49

Hi sir,
I want to create a DSN Name and set a path for that.
I am using "SQLConfigDataSource" function for this.

It is not giving any error and running properly.But it is not writing to DNS.

Here ia wat i am doing

SQLConfigDataSource(NULL, ODBC_ADD_SYS_DSN, _T("Microsoft Access Driver (*.mdb)\0"), _T("DSN=SAMPLEE\0DBQ=D:\\SAMPLE.mdb\0"));

Am i doing right???or any other stuff need to be done.

Thanks
Raj

CPallini1-Sep-10 2:09

1-Sep-10 2:09

Did you check the return value?
Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke

[My articles]

raju_shiva1-Sep-10 18:10

1-Sep-10 18:10

Hi,
I tried with this

bool aDSNCreated = false;
aDSNCreated = SQLConfigDataSource(NULL, ODBC_ADD_SYS_DSN, _T("Microsoft Access Driver (*.mdb)\0"), _T("DSN=SAMPLEE\0DBQ=D:\\SAMPLE.mdb\0")); 
printf("%d",aDSNCreated );

aDSNCreated value is zero.

what i am doing wrong??

Thanks
Raj

CPallini1-Sep-10 21:21

1-Sep-10 21:21

From MSDN[^]:

When SQLConfigDataSource returns FALSE, an associated *pfErrorCode value can be obtained by calling SQLInstallerError. The following table lists the *pfErrorCode values that can be returned by SQLInstallerError and explains each one in the context of this function.

raju_shiva2-Sep-10 0:11

2-Sep-10 0:11

Hi sir.

CPallini wrote:
an associated *pfErrorCode value can be obtained by calling SQLInstallerError

I am not getting how to get the errorcode.I am trying as below

bool aDSNCreated = false;
//char *str;// = "asdasdsd\0";	
RETCODE retcode= SQL_SUCCESS;
aDSNCreated = SQLConfigDataSource(NULL, ODBC_ADD_SYS_DSN, _T("Microsoft Access Driver (*.mdb)\0"), _T("DSN=SAMPLEE\0DBQ=D:\\SAMPLE.mdb\0")); 
printf("%d",aDSNCreated );
if(aDSNCreated == false)
{
	retcode = SQLInstallerError(2, NULL,NULL,100,NULL);
         
}

I am not getting wat paramaters to send and return the error code..

please help me out.

Sorry i know its a very silly question.

Thanks
Raj

CPallini2-Sep-10 0:38

2-Sep-10 0:38

I would do:

BOOL isDSNCreated;
isDSNCreated = SQLConfigDataSource(NULL, ODBC_ADD_SYS_DSN, _T("Microsoft Access Driver (*.mdb)\0"), _T("DSN=SAMPLEE\0DBQ=D:\\SAMPLE.mdb\0"));
if (isDSNCreated == FALSE)
{
  CHAR szError[SQL_MAX_MESSAGE_LENGTH];
  DWORD dwError;
  WORD cbError;
  RETCODE retcode;
  retcode = SQLInstallerError(1, &dwError, szError, SQL_MAX_MESSAGE_LENGTH-1, &cbError);
  // check 'retcode', have a look at 'dwError', show 'szError', whatever...
}

raju_shiva2-Sep-10 1:45

2-Sep-10 1:45

CPallini wrote:
retcode = SQLInstallerError(1, &dwError, szError, SQL_MAX_MESSAGE_LENGTH-1, &cbError);

Hi sir,
I am getting this error:

Error	47	error C2664: 'SQLInstallerErrorW' : cannot convert parameter 3 from 'CHAR [512]' to 'LPWSTR'

Thanks
Raj

CPallini2-Sep-10 2:11

2-Sep-10 2:11

The use:

  <big>TCHAR</big> szError[SQL_MAX_MESSAGE_LENGTH];
  DWORD dwError;
  WORD cbError;
  RETCODE retcode;
  retcode = SQLInstallerError(1, &dwError, szError, SQL_MAX_MESSAGE_LENGTH-1, &cbError);
<small>If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
                -- Alfonso the Wise, 13th Century King of Castile.<br>
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. 
                -- Iain Clarke
<br></small><small><a href="http://www.codeproject.com/script/Articles/MemberArticles.aspx?amid=1778670">[My articles]</a></small>

raju_shiva2-Sep-10 19:00

Store a point within rect

2-Sep-10 19:00

Hi sir,
Thank you.Its building without error.
I am getting the retcode as zero(i.e SQL_SUCCESS).
But i am not finding the DSN Created when i am checking through Control Panel->ODBC

Thanks
Raj

mesajflaviu1-Sep-10 0:37

Re: Store a point within rect

1-Sep-10 0:37

How can I store an position of point ( point of end/begin of an line ) which is within an rect ?

void CSelectTool::OnLButtonDown(CNetMapView* pView, UINT nFlags, const CPoint& point)
{
	CRect rect = m_Tracker.m_rect;
	// if an line is within rect then store their point into ptLine
	...
	CPoint ptLine;
	if(rect.PtInRect(rectLine.TopLeft()))ptLine = rectLine.TopLeft();
	if(rect.PtInRect(rectLine.BottomRight()))ptLine = rectLine.BottomRight();
	...
}

now I need ptLine value in follow event :

void CSelectTool::OnMouseMove(CNetMapView* pView, UINT nFlags, const CPoint& point)
{
	CRect rect = m_Tracker.m_rect;
	// rect was moved , but I want to move ptLine in  the update position
	// what is new value of ptLine ?
}

CPallini1-Sep-10 0:48

typdef struct MFC [modified]

1-Sep-10 0:48

If I got you then you have to move the line of the same amount of the rectangle. i.e.

Store the original position of the rectangle.
On mouse move, subtract to current rectangle position the stored one, to obtain the offset.
add the offset to the line.

mesajflaviu31-Aug-10 20:45

31-Aug-10 20:45

Can you tell me how to insert / acces an struct elements from another class then declare it ?

//CMyView.h

...
...
typedef struct tagLine{
	CDrawObj* pObj;
	UINT nHandle;
	CPoint point;
}Line;
...
...

	CList<<Line,Line>> m_line;
...

//CSelectTool.cpp

void CSelectTool::OnLButtonDown(CMyView* pView, UINT nFlags, const CPoint& point)
{
	// pObj is an valid pointer of custom object
	// I don't know how to insert new element !?
	pView->m_line.AddTail(pView->Line(pObj,1,point));	// this is error
}

void CSelectTool::OnMouseMove(CMyView* pView, UINT nFlags, const CPoint& point)
{
	// I don't know how to access element of pView->m_line;
}

Can you help me please ? Thank you !!!

modified on Wednesday, September 1, 2010 2:51 AM

Eugen Podsypalnikov31-Aug-10 21:02

Eugen Podsypalnikov

31-Aug-10 21:02

Try something like following Smile | :)

...
typedef struct tagLine {
  int m_i1, m_i2;
  Line(int i1, i2) : m_i1(i1), m_i2(i2) {};
} Line;
...

void CMyView::AddNewLine(int i1, int i2)
{
  m_Line.AddTail(new Line(i1, i2));
}

virtual void BeHappy() = 0;

mesajflaviu31-Aug-10 21:15

31-Aug-10 21:15

Ok , and when I want to acces an element of m_Line ?

CPallini31-Aug-10 21:26

31-Aug-10 21:26

MSDN has a code sample [^] about accessing elements of a CList.
Smile | :)

Cedric Moonen31-Aug-10 21:02

Cedric Moonen

31-Aug-10 21:02

mesajflaviu wrote:
pView->m_line.AddTail(pView->Line(pObj,1,point)); // this is error

If your structure is defined globally (not inside your class), then you can simply do something like this (given that the structure has the appropriate constructor and your m_line variable is public):

pView->m_line.AddTail(Line(pObj,1,point));

However, it is always better to make your variables private and provide a AddLine to your CMyView instead.

mesajflaviu wrote:
// I don't know how to access element of pView->m_line;

The same way you wrote it. But once again, providing a getter is much more clean.
If you want to access a specific line in your list, then you have to use the methods from the list to retrieve the line you are looking for.

Cédric Moonen
Software developer

Charting control [v3.0]
OpenGL game tutorial in C++

mesajflaviu31-Aug-10 22:53

31-Aug-10 22:53

Here is my trial :

//	CMyView.h

typedef struct tagLine{
	CDrawObj* pObj;
	UINT nHandle;
	CPoint point;
}Line;

...
...
	CList<Line,Line> m_line;

//	CMyView.cpp

void CMyView::AddLineStruct(CDrawObj* pObj, UINT nHandle, CPoint point)
{
	Line LineStruct;
	LineStruct.pObj = pObj;
	LineStruct.nHandle = nHandle;
	LineStruct.point = point;
	m_line.AddTail(LineStruct);
}

//	CSelectTool.cpp

void CSelectTool::OnLButtonDown(CNetMapView* pView, UINT nFlags, const CPoint& point)
{
...
	pView->AddLineStruct(pObjLine,nHandle,point);
...
}

void CSelectTool::OnMouseMove(CNetMapView* pView, UINT nFlags, const CPoint& point)
{
	// here I try access elements of pView->m_line
	POSITION pos = pView->m_line.GetHeadPosition();
	while(pos != NULL)
	{
		pView->Line data = pView->m_line.GetNext(pos); // here is an error :
		//	error C2273: 'function-style cast' : illegal as right side of '->' operator
		// error C2146: syntax error : missing ';' before identifier 'data'
	}

}

still , I don't know how to acces elemts of the structure ....

mesajflaviu31-Aug-10 22:59

31-Aug-10 22:59

Perhaps will go if I declare Line strucure as global , but I didn;t want to do that ... is not elegant Frown | :(

Cedric Moonen31-Aug-10 23:06

Cedric Moonen

31-Aug-10 23:06

Why not ? If your structure has to be manipulated externally from your CMyView class, then it makes sense to make it a class which is not defined in your CMyView class (the class, not instances of the class of course).
And I would probably make it a class instead of a structure because you could add some useful methods to it (like check if the line is close enough to a given point, calculate the lenght of the line, ...). Of course, you can still do that with a structure but for most people using a structure in C++ means that it is an object that only contains data (and no method). This is of course not a strict rule.

Cédric Moonen
Software developer

Charting control [v3.0]
OpenGL game tutorial in C++

Cedric Moonen31-Aug-10 23:02

Cedric Moonen

31-Aug-10 23:02

The AddLineStruct method is correct and is what you have to do in order to hide the implementation details from classes which are using CMyView (encapsulation).

Now you should do something similar as that for retrieving a line. I don't know based on which information you would like to retrieve a specific line but I guess this is based on the mouse location (the point variable) ?
So, you could create a method GetLine(const CPoint* point) which is retrieving a line (or an array of line) which are close to the point. This way, you also hide the internals about how your lines are managed by the CMyView class.

Just to clarify your doubts: you seem to be very confused about how to declare your variable (because in all cases it was wrong). So, if your structure is globally defined, you just have to do this:

Line newLine = ....;

and if your structure is defined inside your CMyView class, then you should simply do this:

CMyView newLine = ....;

It doesn't make any sense to have to use an instance of CMyView in order to instanciate a variable (pView->Line).

Cédric Moonen
Software developer

Charting control [v3.0]
OpenGL game tutorial in C++

CPallini31-Aug-10 23:06

31-Aug-10 23:06

mesajflaviu wrote:
pView->Line data = pView->m_line.GetNext(pos); // here is an error :

What's wrong with

Line & line = pView->m_line.GetNext(pos);

mesajflaviu1-Sep-10 0:33