|
I am using an MS Access (97) database and linking to it using ODBC. The application runs through all the records and adds them to various customised list ctrls. I am also using an Outlook-style menu component with a 3-way split screen - the main screen switches between different CFormViews depending on what is selected from the "Outlook" bar.
I have other applications which link to Access databases over a network just fine.
David Osborn
|
|
|
|
|
Are your list controls filled OK, and after that program crashes? Or it happens in the middle of operation?
BTW: why are you using ODBC for Access? Aren't MFC DAO classes enough?
Tomasz Sowinski -- http://www.shooltz.com.pl
|
|
|
|
|
It is not consistent. It just runs really slowly - sometimes it freezes while trying to fill the first list and sometimes it fills the lists but then if I try anything (even just bringing a dialog box up) it goes really slowly until it just stops responding. As I said it runs fine locally.
I am using ODBC because the application will be running on a client/server environment, eventually running with SQL Server.
David Osborn
|
|
|
|
|
When it stops responding, use Break command in the debugger. You'll be able to see which routine hangs your app. I'd also look search Knowledge Base for BUG-style articles related to ODBC/Access - there's a chance that you hit some ODBC problem.
Tomasz Sowinski -- http://www.shooltz.com.pl
|
|
|
|
|
If you copy a file from one pc to another, the speed of transference of the file is good?
The problem can be that the network is slow.
Carlos Antollini.
|
|
|
|
|
There is no problem with the network. Files copy okay and as I said we have other similar applications which run very quickly over a network. It is something to do with the application.
David Osborn
|
|
|
|
|
This is a bug with Microsoft Data Access Components versions 2.1, 2.5, 2.6
an excessive amount of network packet activity occurs, even when the ODBC connection is idle
It is caused by wrong interpetation of the timout value.
since it is expecting to be in miliseconds and you set it to seconds.
Also, if you create a new ODBC data source with the MDAC 2.1 or later version of the Access ODBC Driver, the driver incorrectly uses a default value of 5 for PageTimeout. The correct default value should be 5000 with the MDAC 2.1 version of the driver.
See MSDN for The resolution:
[SNIP]
"
The recommended setting for PageTimeout with the MDAC 2.1 or later version of the Microsoft Access ODBC driver is 5000. To change this value, click Options in the ODBC data source and modify the PageTimeout value.
You can also add this to your ODBC connection string. For example, here is an ODBC connection string that uses a DSN as well as adds the PageTimeout setting:
"DSN=MyODBCDataSource;PageTimeout=5000;"
Here is an example ODBC connection string that uses a DSN-less connection as well as adds the PageTimeout setting:
"Driver=Microsoft Access Driver (*.mdb);PageTimeout=5000;DBQ=C:\MyFile.doc;"
[/SNIP]
Click here for article
Cheers
Alfadhly
/*
It is Illogical to define an inventor by his invention
*/
|
|
|
|
|
Thanks, this sorted the problem.
David Osborn
|
|
|
|
|
Hi all,
I've written a library and I would like to specify in the source code additionnal include and library path to avoid specify in the Project/Settings in each project I've made...
I know that we can specify libray to include to the linker in this way:
#pragma comment(lib,"test.lib")
...and that work correctly. I've seen on MSDN that we can set some linker options like this:
#pragma comment(linker, "LIBPATH :\lib")
...but it seems to do nothing and we can't specify additionnal include directories... 
Thx in advance...
|
|
|
|
|
Just a guess: change d:\lib to d:\\lib.
Tomasz Sowinski -- http://www.shooltz.com.pl
|
|
|
|
|
Sorry, I've done an error in my example...  It is "d:/lib" not "d:\lib"
|
|
|
|
|
I am reading field values from records which then i convert to CString
_Recordset rs;
variant_t var = rs->Fields->GetItem (variant_t ("name"))->Value;
then i try to convert to CString var:
var.ChangeType (VT_BSTR);
CString strName = var.bstrVal;
whenever field has NULL i got error of access violation
please help
|
|
|
|
|
would
CString name;
if (var.bstrName)
name = var.bstrVal;
else
// go home
work ?
Christian
#include "std_disclaimer.h"
People who love sausage and respect the law should never watch either one being made.
The things that come to those who wait are usually the things left by those who got there first.
|
|
|
|
|
it did not or I made something wrong:
variant_t vGroupID = rsMenu->Fields->GetItem (_variant_t ("group_id"))->Value;
vGroupID.ChangeType (VT_BSTR);
if (vGroupID.bstrVal)
{
sGroupID = vGroupID.bstrVal;
}
else
sGroupID = "NULL";
i got the same error
|
|
|
|
|
try checking var.vt for VT_NULL (and VT_EMPTY possibly)
maXallion "Is there any Tea on this Spaceship?"
- Arthur Dent
Home of The Code Devil
|
|
|
|
|
it works, but probably what i have done is NOT the best coding example
CString sGroupID;
variant_t vTest;
variant_t vGroupID;
vTest.ChangeType (VT_NULL);
vGroupID = rsMenu->Fields->GetItem (_variant_t ("group_id"))->Value;
if (vGroupID != vTest)
{
vGroupID.ChangeType (VT_BSTR);
sGroupID = vGroupID.bstrVal;
}
else
sGroupID = "NULL";
thank you
|
|
|
|
|
that should do the job:
CString sGroupID;
_variant_t vGroupID;
vGroupID = rsMenu->Fields->GetItem (_variant_t ("group_id"))->Value;
if (vGroupID.vt != VT_NULL)
sGroupID = (LPCTSTR)_bstr_t(vGroupID);
else
sGroupID = "NULL";
maXallion "Is there any Tea on this Spaceship?"
- Arthur Dent
Home of The Code Devil
|
|
|
|
|
I wanna run exe file from another software that i code in VC++...I can run int using WinExec.......But i need to know how to use CreateProcess or ShellExcute function...
Plz someone....
THANX
|
|
|
|
|
Here's some sample code, perhaps it helps:
(havn't tested it, though)
STARTUPINFO supi;
PROCESS_INFORMATION proci;
GetStartupInfo (&supi); supi.lpDesktop = "";
CString strCmd = "notepad.exe";
BOOL bOK = CreateProcess(NULL,strCmd.LockBuffer(),NULL,NULL,
FALSE,CREATE_DEFAULT_ERROR_MODE | NORMAL_PRIORITY_CLASS,
NULL,NULL,&supi,&proci);
WaitForSingleObject(m_hProcess,INFINITE); //wait until the program is closed
maXallion "Is there any Tea on this Spaceship?"
- Arthur Dent
Home of The Code Devil
|
|
|
|
|
thanx u very much......I need to know how WaitForSingleObject works.......When i include this function, there is no difference...
|
|
|
|
|
thanx u very much......I need to know how WaitForSingleObject works.......When i include this function, there is no difference...
|
|
|
|
|
How can i check whether user can pree ctrl key
Dinesh Asanka
|
|
|
|
|
Do you mean can they press it, or have they pressed it ? If the latter, GetASyncKeyState(VK_CONTROL)
Christian
#include "std_disclaimer.h"
People who love sausage and respect the law should never watch either one being made.
The things that come to those who wait are usually the things left by those who got there first.
|
|
|
|
|
Do you mean can they press it, or have they pressed it ? If the latter, GetASyncKeyState(VK_CONTROL)
Christian
#include "std_disclaimer.h"
People who love sausage and respect the law should never watch either one being made.
The things that come to those who wait are usually the things left by those who got there first.
|
|
|
|
|
I'm trying to use the grid control in a CFormView-based class, by inserting a custom control in the dialog. My application fails with "Failed to create empty document" message at startup, the trace information from a debug run is as follows:
WndProc: hwnd=0x4C03D6, msg = WM_GETMINMAXINFO (0x0000, 0x0012F9FC)
WndProc: hwnd=0x4C03D6, msg = WM_NCCREATE (0x0000, 0x0012F9D0)
WndProc: hwnd=0x4C03D6, msg = WM_NCCALCSIZE (0x0000, 0x0012FA1C)
WndProc: hwnd=0x4C03D6, msg = WM_CREATE (0x0000, 0x0012F9BC)
WndProc: hwnd=0x2D02FE, msg = WM_NCCREATE (0x0000, 0x0012F394)
WndProc: hwnd=0x2D02FE, msg = WM_NCCALCSIZE (0x0000, 0x0012F3C4)
WndProc: hwnd=0x2D02FE, msg = WM_CREATE (0x0000, 0x0012F394)
WndProc: hwnd=0x2D02FE, msg = WM_SIZE (0x0000, 0x014501E0)
WndProc: hwnd=0x4C03D6, msg = 0x0368 (0x0000, 0x0012F0E4)
WndProc: hwnd=0x2D02FE, msg = WM_MOVE (0x0000, 0x00000000)
WndProc: hwnd=0x4C03D6, msg = WM_PARENTNOTIFY (0x0001, 0x002D02FE)
WndProc: hwnd=0x2D02FE, msg = WM_SETFONT (0x500A043F, 0x00000000)
WndProc: hwnd=0x4C03D6, msg = WM_PARENTNOTIFY (0x0002, 0x002D02FE)
WndProc: hwnd=0x2D02FE, msg = WM_DESTROY (0x0000, 0x00000000)
WndProc: hwnd=0x2D02FE, msg = WM_NCDESTROY (0x0000, 0x00000000)
Warning: could not create view for frame.
Failed to create client pane/view for frame.
WndProc: hwnd=0x4C03D6, msg = WM_DESTROY (0x0000, 0x00000000)
WndProc: hwnd=0x4C03D6, msg = WM_NCDESTROY (0x0000, 0x00000000)
Warning: Window creation failed: GetLastError returns 0x00000000
Warning: failed to create CFrameWnd.
Warning: CDocTemplate couldn't create a frame.
The thread 0x4C4 has exited with code 0 (0x0).
The program 'D:\TEMP\gctest\Debug\gctest.exe' has exited with code 0 (0x0).
The first warning is caused by ::CreateDialogIndirect() failing when the CMainFrame is being created. Then everything else fails because there is no main window.
Any idea why the window creation fails? Is some additional initialization needed?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
