C / C++ / MFC

13-May-09 1:02

I have created a win32 resource dll which has only string table, also i have included \NOENTRY in linker options in-order to make it as resource only dll

Now I am loading the dll in MFC application and loads fine but when I am try to get the string from the string table it doens't load. Here is my code:

     HINSTANCE hinsttance = ::LoadLibrary("SampleEN.dll");
DWORD dwError = GetLastError();

if (!hinsttance)
{
    AfxMessageBox("Failed to load");
}
else
{
    HINSTANCE hInstResourceClient = AfxGetResourceHandle();

    // Use DLL's instance handle
    AfxSetResourceHandle(hinsttance);

    LPCTSTR lpszName = MAKEINTRESOURCE(1); //IDC_STATIC_TOP has been defined as 1 in the dll
    HRSRC hrsrc = FindResource(m_hinstLib, lpszName, RT_STRING);

    if (hrsrc)
    {
        TCHAR szTemp[256];
        LoadString(m_hinstLib, IDC_STATIC_TOP, szTemp, 255);
    }

    AfxSetResourceHandle(hInstResourceClient);
}

what could be the problem???

«_Superman_»13-May-09 1:09

«_Superman_»

13-May-09 1:09

Super Hornet wrote:
HRSRC hrsrc = FindResource(m_hinstLib, lpszName, RT_STRING);

What is m_hinstLib?
It should be hinsttance.

Then use the handle returned by FindResource in a call to LoadResource.
To access the actual resource call LockResource on the handle returned by LoadResource.

«_Superman_»
I love work. It gives me something to do between weekends.

Super Hornet13-May-09 1:16

13-May-09 1:16

Actually it's - hinsttance, mistakenly written here as m_hinstLib

«_Superman_»13-May-09 1:21

«_Superman_»

13-May-09 1:21

Where exactly does it fail?
Is it the FindResource that is failing or is it LoadString?

Try it without the AfxSetResourceHandle call.

«_Superman_»
I love work. It gives me something to do between weekends.

Super Hornet13-May-09 1:22

13-May-09 1:22

Modified code according to your suggestion:

HINSTANCE hinstance = ::LoadLibrary("SampleEN.dll");

if (!hinstance)
{
    AfxMessageBox("Failed to load");
}
else
{
    HINSTANCE hInstResourceClient = AfxGetResourceHandle();

    // Use DLL's instance handle
    AfxSetResourceHandle(hinstance);

    LPCTSTR lpszName = MAKEINTRESOURCE(1); //IDC_STATIC_TOP has been defined as 1 in the dll
    HRSRC hrsrc = FindResource(hinstance, lpszName, RT_STRING);
    if (hrsrc)
    {
        HGLOBAL hglobal = LoadResource(hinstance, hrsrc);
        LockResource(hglobal);

        TCHAR szTemp[256];
        LoadString(hinstance, IDC_STATIC_TOP, szTemp, 255);
    }

    AfxSetResourceHandle(hInstResourceClient);
}

even now the string is empty. I get the error code: 1814 - which says resource couldn't be found. But I have re-verfied that the ID exists in the string table

Super Hornet13-May-09 1:29

13-May-09 1:29

I have tried commenting the statement
AfxSetResourceHandle(hinstance); but the same error

The error code 1814 comes after LaodString call

Super Hornet13-May-09 2:21

13-May-09 2:21

Now I am able to get the correct value's

The problem is with resource id's, I haven't defined same resource id in dll and in mfc application.

Stuart Dootson13-May-09 1:10

Stuart Dootson

13-May-09 1:10

Super Hornet wrote:
m_hinstLib

What's that? Your resource DLL's handle is hinsttance ...

Super Hornet13-May-09 1:23

Not able to connect to the database

13-May-09 1:23

thank you for pointing the error

vital_parsley200013-May-09 0:34

vital_parsley2000

13-May-09 0:34

I m doing a database application.

in my OnNewDocument() i have the following code..

HRESULT hr;
try
{
AfxMessageBox("Inside try executed.",NULL,MB_OK); //Excecuted
hr = m_pConnection.CreateInstance(__uuidof(Connection));
AfxMessageBox("Created instance executed.",NULL,MB_OK);
if(SUCCEEDED(hr))
{
AfxMessageBox("If hr succeeded.",NULL,MB_OK);//Not Executed
hr = m_pConnection->Open(_bstr_t(L"Provider=sqloledb;Data Source=C:\\Program Files\\Microsoft SQL Server\\MSSQL\\Data\\LibDB.mdf;"),_bstr_t(L""),_bstr_t(L""),adModeUnknown);
if(SUCCEEDED(hr))
{
AfxMessageBox("Open connection executed.",NULL,MB_OK); //not executed
m_pConnection=TRUE;
}
}
AfxMessageBox("out",NULL,MB_OK);
}
catch(_com_error &e)
{
_bstr_t bstrSource(e.Source());
_bstr_t bstrDescription(e.Description());
TRACE( "Exception thrown for classes generated by #import" );
TRACE( "\tCode = %08lx\n", e.Error());
TRACE( "\tCode meaning = %s\n", e.ErrorMessage());
TRACE( "\tSource = %s\n", (LPCTSTR) bstrSource);
TRACE( "\tDescription = %s\n", (LPCTSTR) bstrDescription);
}
catch(...)
{
TRACE( "*** Unhandled Exception ***" );
}
return TRUE;
}

In the above code the if(SUCCEEDED(hr)) block is not executed.What could be the reason ?

CPallini13-May-09 0:40

CPallini

13-May-09 0:40

An hint is given by the hr 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]

Madhu Nair13-May-09 0:44

13-May-09 0:44

vital_parsley2000 wrote:
if(SUCCEEDED(hr)) block is not executed.What could be the reason ?

Get the hr value and pass it to FormatMessage function. You will get the cause.

To convert an HRESULT to DWORD you can use the following code snippet!

BOOL WIN32_FROM_HRESULT(HRESULT hr, OUT DWORD *pdwWin32)
{
 if ((hr & 0xFFFF0000) == MAKE_HRESULT(SEVERITY_ERROR, FACILITY_WIN32)) {
  // Could have come from many values, but we choose this one
  *pdwWin32 = HRESULT_CODE(hr);
  return TRUE;
 }
 if (hr == S_OK) {
  *pdwWin32 = HRESULT_CODE(hr);
  return TRUE;
 }
 // otherwise, we got an impossible value
 return FALSE;
}

I found this from here

vital_parsley200013-May-09 5:19

vital_parsley2000

13-May-09 5:19

where do i insert this
code ?

Madhu Nair13-May-09 20:45

Re: Not able to connect to the database [modified]

13-May-09 20:45

vital_parsley2000 wrote:
where do i insert this code ?

In your source files, dear!

It is a function, you can either put it in your .cpp file or .h file in global scope or add as a member function in your class.

Am I missing something ?

Madhu Nair13-May-09 21:03

13-May-09 21:03

Another Tip:

Put the variable hr in the debug watch window, append ", hr" (without the quotes) to it to have Visual C++ translate it for you!

Or you can use pseudo variable $err as $err,hr in Watch window.The $err pseudo variable provides the value, and the hr format specifier tells the watch window to format it as an error code.

http://i.msdn.microsoft.com/dd252945.fig05_L(en-us).gif[^]

modified on Thursday, May 14, 2009 2:21 AM

Load data from database to BCG grid

David Crow13-May-09 4:17

David Crow

13-May-09 4:17

vital_parsley2000 wrote:
In the above code the if(SUCCEEDED(hr)) block is not executed.

Which one?

vital_parsley2000 wrote:
What could be the reason ?

CreateInstance() or Open() failed and control did not return to the subsequent if() statement.

"Old age is like a bank account. You withdraw later in life what you have deposited along the way." - Unknown

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

MrKBA12-May-09 22:56

MrKBA

12-May-09 22:56

Hi,
I'm developing an application and i would display data from database(access, sqlserver, oracle) in a bcg grid.
So can someone help me by a simple example of code or how can i do for this.

Thank you very much. Smile | :)

Madhu Nair12-May-09 23:14

12-May-09 23:14

khaliloenit wrote:
So can someone help me by a simple example of code

Using MS DataGrid control with ADO[^]

Also look at the DataGrid Control[^] MSDN

MrKBA12-May-09 23:27

MrKBA

12-May-09 23:27

is this solution will work with SqlServer and Oracle database ?

Rajesh R Subramanian12-May-09 23:32

Rajesh R Subramanian

12-May-09 23:32

khaliloenit wrote:
is this solution will work with SqlServer and Oracle database ?

Had you bothered to go through the links given to you, then you would have noticed the answer to your same exact question in the CP article:

"The sample has been tested with both MS Access and SQL Server, in theory you should be able to use it against all data sources that support OLE-DB."

It is a crappy thing, but it's life -^ Carlo Pallini