C / C++ / MFC Discussion Boards

Re: Trying to do this with ADO only? Possible?

JT Anderson9-Sep-02 5:29

9-Sep-02 5:29

Try this:

#pragma warning(disable: 4146)
#import "msado15.dll" rename("EOF", "adoEOF")
#import "msadox.dll" rename("DataTypeEnum", "AdoxDataTypeEnum")
#pragma warning(default: 4146)

All of the ADO stuff will be in the ADODB namespace.
All of the ADOX stuff will be in the ADOX namespace.

redefinition problems

ns7-Sep-02 8:26

7-Sep-02 8:26

I have a databadse project with

#import msado25.tlb

Now i want some ADOX functionlaity so I added:

#import "c:\Program Files\Common Files\system\ado\msadox.dll" no_namespace

I get 18 redefinition errors! How can I get around this and use ADOX and ADO in the same project?

Thanks,
ns

Re: redefinition problems

Joaquín M López Muñoz7-Sep-02 9:33

Joaquín M López Muñoz

7-Sep-02 9:33

Hello ns. I don't know much about ADO(X), but this might help:

Can't you just use ADOX and forget about ADO? As it name suggests, probably ADOX covers ADO as well.
If you can't, you might try using ADO and ADOX in different .cpps so that no name clash occurs.

Joaquín M López Muñoz
Telefónica, Investigación y Desarrollo

CP's CADOX class (CArlos Antollini)

ns7-Sep-02 8:06

7-Sep-02 8:06

I added #include "adox.h" to my db project and got these errors:

--------------------Configuration: Train1 - Win32 Release--------------------
Compiling...
Train1View.cpp
c:\trainer\a_tr noblob indb series\trnoblob13g\release\msadox.tlh(104) : error C2011: '_Collection' : 'struct' type redefinition
c:\trainer\a_tr noblob indb series\trnoblob13g\release\msadox.tlh(133) : error C2011: '_DynaCollection' : 'struct' type redefinition
c:\trainer\a_tr noblob indb series\trnoblob13g\release\msadox.tlh(511) : error C2011: 'DataTypeEnum' : 'enum' type redefinition
c:\trainer\a_tr noblob indb series\trnoblob13g\release\msadox.tlh(554) : error C2011: 'Properties' : 'struct' type redefinition
c:\trainer\a_tr noblob indb series\trnoblob13g\release\msadox.tlh(580) : error C2011: 'Property' : 'struct' type redefinition
c:\trainer\a_tr noblob indb series\trnoblob13g\release\msadox.tli(14) : error C2084: function 'long __thiscall _Collection::GetCount(void)' already has a body
c:\trainer\a_tr noblob indb series\trnoblob13g\release\msadox.tli(21) : error C2084: function 'class _com_ptr_t<class _com_IIID<struct IUnknown,&struct __s_GUID  _GUID_00000000_0000_0000_c000_000000000046> > __thiscall _Collection::_NewEnum(void)' a
lready has a body
c:\trainer\a_tr noblob indb series\trnoblob13g\release\msadox.tli(28) : error C2084: function 'long __thiscall _Collection::Refresh(void)' already has a body
c:\trainer\a_tr noblob indb series\trnoblob13g\release\msadox.tli(38) : error C2084: function 'long __thiscall _DynaCollection::Append(struct IDispatch *)' already has a body
c:\trainer\a_tr noblob indb series\trnoblob13g\release\msadox.tli(44) : error C2084: function 'long __thiscall _DynaCollection::Delete(const class _variant_t &)' already has a body
c:\trainer\a_tr noblob indb series\trnoblob13g\release\msadox.tli(386) : error C2084: function 'class _com_ptr_t<class _com_IIID<struct Property,&struct __s_GUID  _GUID_00000503_0000_0010_8000_00aa006d2ea4> > __thiscall Properties::GetItem(const cla
ss _variant_t &)' already has a body
c:\trainer\a_tr noblob indb series\trnoblob13g\release\msadox.tli(397) : error C2084: function 'class _variant_t __thiscall Property::GetValue(void)' already has a body
c:\trainer\a_tr noblob indb series\trnoblob13g\release\msadox.tli(405) : error C2084: function 'void __thiscall Property::PutValue(const class _variant_t &)' already has a body
c:\trainer\a_tr noblob indb series\trnoblob13g\release\msadox.tli(410) : error C2084: function 'class _bstr_t __thiscall Property::GetName(void)' already has a body
c:\trainer\a_tr noblob indb series\trnoblob13g\release\msadox.tli(417) : error C2084: function 'enum DataTypeEnum __thiscall Property::GetType(void)' already has a body
c:\trainer\a_tr noblob indb series\trnoblob13g\release\msadox.tli(424) : error C2084: function 'long __thiscall Property::GetAttributes(void)' already has a body
c:\trainer\a_tr noblob indb series\trnoblob13g\release\msadox.tli(431) : error C2084: function 'void __thiscall Property::PutAttributes(long)' already has a body
C:\Trainer\A_TR NOBlob inDB series\TrNoBlob13g\Train1View.cpp(3991) : warning C4553: '==' : operator has no effect; did you intend '='?
C:\Trainer\A_TR NOBlob inDB series\TrNoBlob13g\Train1View.cpp(4449) : error C2264: 'GetCount' : error in function definition or declaration; function not called

Error executing cl.exe.

Train1.exe - 18 error(s), 9 warning(s)

I like the class but dont know how to make errors disapppear. I have #import msado25.tlb

How to get mask of IP adress

zbyrat7-Sep-02 7:35

zbyrat

7-Sep-02 7:35

Maybe it's very stupid question. I'm talking about application working on LAN. I can get IP adress but i need send a broadcast message. IMO is simplest way replace part of IP adress with 0xFF(or something like this depending on adressing of LAN) and send UDP packet. But i don't know how to get mask and find right part of adress to replace. Can anybody help me?

Re: How to get mask of IP adress

JohnnyG7-Sep-02 8:58

JohnnyG

7-Sep-02 8:58

I'm not sure what you're talking about here. Mask? Anyways, if you want to send a broadcast message just set the destination IP address to 255.255.255.255 and set the port to whatever port you're going to be using. I believe most routers will block that (not routeable) so it won't go out on the Internet but remain on your LAN and probably won't cross any segments.

Re: How to get mask of IP adress

JohnnyG8-Sep-02 5:00

JohnnyG

8-Sep-02 5:00

Ok, after doing some research on a related topic, I stumbled across what you were talking about. You're asking about the subnet mask.

I don't know how you get it. But, as I stated earlier you can send 255.255.255.255 as a broadcast for all subnets. If your IP address was 192.168.1.22 and your subnet mask was 255.255.255.0 then sending a broadcast message with IP address 192.168.1.255 would work also. Thus, that becomes a broadcast message for that subnet only.

The procedure I read said negate OR the subnet mask with your IP address to get that value.

e.g. ip |= ~mask to get broadcast address.

writing help documentation

ns7-Sep-02 7:25

7-Sep-02 7:25

I have to supply documentation for the user of the app (not docs for the code). Things like features and instructions and troubleshooting etc. I'd like to make this like the help system we see that pops up with tabs for index, search, contents etc. Can you please point me to links, sample code etc on how to do this?

Thanks,
ns

Re: writing help documentation

Simon.W7-Sep-02 17:41

Simon.W

7-Sep-02 17:41

try HtmlHelp released by microsoft

I am seeking...
For what?
Why did you ask me for what? I don't know!

How do i add a lib file to my project in Visual Studio .NET?

Redeemer-dk7-Sep-02 5:24

Redeemer-dk

7-Sep-02 5:24

can't find it...

thanks

Re: How do i add a lib file to my project in Visual Studio .NET?

Stephane Rodriguez.7-Sep-02 5:56

Stephane Rodriguez.

7-Sep-02 5:56

In the Solution Explorer window, right-click on your project and select Properties. In the dialog box, unfold the Linker folder, click on Input. Then add your .lib file(s) in Additional Dependencies.

MS quote (http://www.microsoft.com/ddk) : As of September 30, 2002, the Microsoft® Windows® 2000 DDK, the Microsoft Windows 98 DDK, and the Microsoft Windows NT® 4.0 DDK will no longer be available for purchase or download on this site. Support for development will ship at the same time as the Windows XP Service Pack 1 (SP1) release.

Re: How do i add a lib file to my project in Visual Studio .NET?

valikac7-Sep-02 5:59

valikac

7-Sep-02 5:59

-Projects
-Add existing item...

Kuphryn

Thanks to both of you.

Anonymous7-Sep-02 6:38

Anonymous

7-Sep-02 6:38

ADO

dsfasdfadsfasdfadsf7-Sep-02 3:20

dsfasdfadsfasdfadsf

7-Sep-02 3:20

If you have a "simple" ADO application in C++ that shows the usage of stored procedures, then please write the code here .

Re: ADO

NormDroid7-Sep-02 3:24

NormDroid

7-Sep-02 3:24

Yes Sir!

// AdoHelper.cpp: implementation of the CAdoHelper class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "AdoHelper.h"

#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CConnection* CConnection::m_pInstance = NULL;

void CConnection::SetConnection(const CString& strConnectString)
{
m_strConnectString = strConnectString;
}

CConnection::CConnection()
{

m_pInstance = NULL;
m_bConnect = FALSE;
}

CConnection::~CConnection()
{

}

void CConnection::Disconnect()
{
try
{
if (m_Conn != NULL)
m_Conn->Close();
}
catch (...)
{

}
}

CString CConnection::GetConnectString()
{
return m_strConnectString;
}

BOOL CConnection::Connect()
{
BOOL bRet = FALSE;
CString str;

try
{
m_Conn = _ConnectionPtr(__uuidof( Connection ));

_bstr_t bstrConn(GetConnectString());

_bstr_t n;
if (SUCCEEDED(m_Conn->Open(bstrConn,n,n,0)))
{
bRet = TRUE;
}
else
{

CString str;
str.Format("%s Connection Failed",bstrConn);
AfxMessageBox(str);
}

}
catch (_com_error& e)
{

}

m_bConnect = bRet;

return bRet;

}

BOOL CConnection::IsConnected()
{
return m_bConnect;

}

//////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////
CAdoCmd::CAdoCmd()
{
m_pConnection = NULL;
m_bParamSet = false;
}

CAdoCmd::CAdoCmd(const CString& strSP, CConnection* pConnection)
{
m_bParamSet = false;

m_pConnection = pConnection;
ASSERT(pConnection != NULL);
ASSERT(m_pConnection->m_Conn != NULL);

m_cmd = _CommandPtr(__uuidof(Command));
ASSERT(m_cmd != NULL);

m_cmd->ActiveConnection = m_pConnection->m_Conn;
m_cmd->CommandText = _bstr_t(strSP);
m_cmd->CommandType = adCmdStoredProc;
m_cmd->CommandTimeout = 15;
}

void CAdoCmd::SetProcedureName(const CString& strSP, CConnection* pConnection)
{
m_pConnection = pConnection;

ASSERT(pConnection != NULL);
ASSERT(m_pConnection->m_Conn != NULL);

m_strSP = strSP;

m_cmd = _CommandPtr(__uuidof(Command));
ASSERT(m_cmd != NULL);

m_cmd->ActiveConnection = m_pConnection->m_Conn;
m_cmd->CommandText = _bstr_t(strSP);
m_cmd->CommandType = adCmdStoredProc;
m_cmd->CommandTimeout = 15;
}

BOOL CAdoCmd::CreateParameter(DataTypeEnum dtEnum, ParameterDirectionEnum pdEnum, int nSize)
{
_ParameterPtr pParam = _ParameterPtr(__uuidof(Parameter));
pParam = m_cmd->CreateParameter("", dtEnum, pdEnum, nSize);
m_cmd->Parameters->Append(pParam);

m_unkArray.Add(pParam);

m_bParamSet = true;

return TRUE;
}

BOOL CAdoCmd::CreateReturnParameter(DataTypeEnum dtEnum, int nSize)
{
// Return Parameter MUST be create first
ASSERT(m_bParamSet == 0);

if (m_bParamSet)
return FALSE;

m_pRetParam = _ParameterPtr(__uuidof(Parameter));
ASSERT(m_pRetParam != NULL);

m_pRetParam = m_cmd->CreateParameter("", dtEnum, adParamReturnValue, nSize);
m_cmd->Parameters->Append(m_pRetParam);

return TRUE;
}

BOOL CAdoCmd::Execute()
{
BOOL b = TRUE;
try
{
m_cmd->Execute(NULL, NULL, 0);
}
catch (_com_error& e)
{

ASSERT(0);
b = FALSE;
}

return b;
}

_variant_t CAdoCmd::GetReturnValue()
{
return m_pRetParam->Value;
}

_variant_t CAdoCmd::GetParamValue(int nParam)
{
_ParameterPtr pParam = m_unkArray.GetAt(nParam);
_variant_t v = pParam->Value;

if (v.vt == VT_NULL)
v = "";

return v;
}

void CAdoCmd::SetParamValue(int nParam, _variant_t val)
{
_ParameterPtr pParam = m_unkArray.GetAt(nParam);
pParam->Value = val;
}

void CAdoCmd::SetParamValue(int nParam, _bstr_t val)
{
_ParameterPtr pParam = m_unkArray.GetAt(nParam);
pParam->Value = val;
}

//////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////

Normski. - the next bit of code is self modifying ... jmp 0xCODE

Set my window to wndTopMost. HOWTO?

BlackSmith7-Sep-02 3:08

BlackSmith

7-Sep-02 3:08

My window (CWnd derived) is created by <font color=blue>CWnd</font>::CreateEx(WS_EX_TOPMOST,..., WS_POPUP, hwndParent).
hwndParent has WS_CHILD style, for it's the only way I could find to create my window without taskbar icon (My wnd is a tooltip-like).

I also used:
<font color=blue>CWnd</font>::SetWindowPos(&wndTopMost,0,0,0,0,SWP_NOSIZE | SWP_NOMOVE);

My window couldn't top the taskbar Unsure | :~

. Very funky...

Any ideas why this occurs? Any at all?

--BlackSmith--
/*The roof is on fire, we don't need no water, let the MF burn*/. BHG.

Re: Set my window to wndTopMost. HOWTO?

Joaquín M López Muñoz7-Sep-02 9:19

Joaquín M López Muñoz

7-Sep-02 9:19

In a previous post, I sugested setting the desktop as the parent of your pop-up with Cwnd::SetParent. Didn't this work? (just curious)

Joaquín M López Muñoz
Telefónica, Investigación y Desarrollo

Re: Set my window to wndTopMost. HOWTO?

Anonymous8-Sep-02 21:21

Anonymous

8-Sep-02 21:21

use this code

::SetWindowPos (m_hWnd , m_Options_AlwaysOnTop ? HWND_TOPMOST :HWND_NOTOPMOST,
0, 0, 0, 0,
SWP_NOMOVE | SWP_NOSIZE | SWP_NOACTIVATE) ; Big Grin | :-D

In win98 CreateCompatibleBitmap return 0

code_cold7-Sep-02 2:18

code_cold

7-Sep-02 2:18

I write following code In Win98

CClientDC dc(this);

CBitmap bmpTemp;
BOOl bRes = bmpTemp.CreateCompatibleBitmap(&dc, 4000, 2000);
ASSERT(bRes != 0); // It failed in Win98, But in Win2k it's OK !!!

When I changed it to:
"BOOl bRes = bmpTemp.CreateCompatibleBitmap(&dc, 4000, 1000);"
It's OK

I want to know:
What's biggest size bitmap in Win98 can create ??

It's me, code_cold

Re: In win98 CreateCompatibleBitmap return 0

NormDroid7-Sep-02 3:23

NormDroid

7-Sep-02 3:23

Windows 95/98/Me: The created bitmap cannot exceed 16MB in size.

Normski. - the next bit of code is self modifying ... jmp 0xCODE

Re: In win98 CreateCompatibleBitmap return 0

code_cold7-Sep-02 4:13

code_cold

7-Sep-02 4:13

You are right

Then, How can I create a more than 16M bitmap
I need this bitmap to buffer a bitmap file

It's me, code_cold

Re: In win98 CreateCompatibleBitmap return 0

code_cold7-Sep-02 10:15

code_cold

7-Sep-02 10:15

Does the CreateBitmap has the same limitation as CreateCompatibleBitmap(No more than 16M size bitmap create) ??

It's me, code_cold

Another Caret in the CEdit

Eugene Pustovoyt7-Sep-02 1:16

Eugene Pustovoyt

7-Sep-02 1:16

Whether it is possible to change the caret in CEdit with a vertical line to another (for example: blinking or solid rectangle)

Best regards,
Eugene Pustovoyt

Re: Another Caret in the CEdit

Stephane Rodriguez.7-Sep-02 1:32

Stephane Rodriguez.

7-Sep-02 1:32

// Changes the caret of the edit control in this dialog box
void CMyDlg::OnChangeCaret() 
{
   CBitmap* pBitmap = new CBitmap;
   pBitmap->LoadBitmap(IDB_HAPPY_BITMAP);
   m_editCtrl.CreateCaret(pBitmap);
   m_editCtrl.ShowCaret();
}

Re: Another Caret in the CEdit

Eugene Pustovoyt7-Sep-02 7:25

Eugene Pustovoyt

7-Sep-02 7:25

Yes in such a way will change the caret, but before the first click the mouse in the CEdit. After that the kind of the caret comes back to a vertical line.

Best regards,
Eugene Pustovoyt

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