|
|
Have a look at MSDE, Microsoft's cut down version of SQL Server 2000. I'm not sure on it's maximum specs but it is a lot cheaper than investing in the full version SQL Server.
You'll find details about it on the Microsoft web-site.
Michael
Look, try and use your intelligence, man, even if you are a politician. - The Doctor
|
|
|
|
|
MSDE is limited to 2GB too. clickety
Is mysql an option?
bibamus, edamus, cras moriemur [eat, drink, for tomorrow we die]
|
|
|
|
|
As far as stand-alone databases MS Access is probably you're best bet. Unfortunantely, there is a 2gb limit.
One idea: split the DB into multiple MDB files and LINK the tables into a master database. Basically with this configuration you can still have a single view of the DB but have the data from the various tables spread out. This will not work, though, if you have 1 table that exceeds your 2gb limit.
Another idea: most access databases are not designed well (I'm not saying yours is poorly designed, just that this is what i've seen.) You should look at the size of the columns in your tables and see if they can be shrunk. Many DB's I've seen use the default size for text columns which is 50 characters. Often this leaves alot of unused space. Also, look for redundant data and consider normalizing the database a little. (Normalizing has the unfortunante side effect of causing you to modify your code, though.)
|
|
|
|
|
In Platform SDK of MSDN, about PeekMessage function: it says we can use PM_QS_PAINT or some other values to specify that only certain message should be processed. But when I use this value, I got complie error:'PM_QS_PAINT' : undeclared identifier. I'm sure I include Windows.h.
The other problem I got is I can use SetForegroundWindow()function, but not AllowSetForegroundWindow()function in the same file. I got compile warning:'AllowSetForegroundWindow' undefined.
Anyone knows how to fix those. Thx.
mIchAel Liu
|
|
|
|
|
Michael Liu wrote:
PM_QS_PAINT or some other values to specify that only certain message should be processed.
Never heard of it. Are you sure it's not an example of a user defined message ?
Michael Liu wrote:
I got compile warning:'AllowSetForegroundWindow' undefined
I have never heard of this either. MSDN says it's defined for Windows ME and 2000 only ( I presume XP has it as well ). This means that any code that uses it will not run on W95/98/98SE/NT and also means you'll need to download the platform SDK ( about 500 MB, also available on CD ) in order to use it.
Christian
I am completely intolerant of stupidity. Stupidity is, of course, anything that doesn't conform to my way of thinking. - Jamie Hale - 29/05/2002
|
|
|
|
|
PM_QS_PAINT :
MSDN give us four values to specify that only certain message should be processed. Do you know how to specify those values?
1. PM_QS_INPUT Windows 98/Me, Windows 2000/XP: Process mouse and keyboard messages.
2. PM_QS_PAINT Windows 98/Me, Windows 2000/XP: Process paint messages.
3. PM_QS_POSTMESSAGE Windows 98/Me, Windows 2000/XP: Process all posted messages, including timers and hotkeys.
4. PM_QS_SENDMESSAGE Windows 98/Me, Windows 2000/XP: Process all sent messages.
AllowSetForegroundWindow():
But I can use SetForegroundWindow(). This function needs the same requirements as AllowSetForegroundWindow().
Thx.
mIchAel Liu
|
|
|
|
|
Michael Liu wrote:
PM_QS_PAINT
Ah.. I did not know about it because I've never used it. Apart from GDI+ and transparent windows, I don't think I've ever used anything that requires the SDK. Look at the requirements you just posted and you'll realise I've answered your question. You need the SDK.
Michael Liu wrote:
But I can use SetForegroundWindow(). This function needs the same requirements as AllowSetForegroundWindow().
Not true. "Minimum operating systems Included in Windows 95, Windows NT 3. "
Christian
I am completely intolerant of stupidity. Stupidity is, of course, anything that doesn't conform to my way of thinking. - Jamie Hale - 29/05/2002
|
|
|
|
|
|
I've installed the latest SDK. How can I use the latest SDK with VC6? Thx.
mIchAel Liu
|
|
|
|
|
Wow - you must have an MSDN subscription. The SDK should set up it's paths so that it is automatically integrated with VC.
Christian
I am completely intolerant of stupidity. Stupidity is, of course, anything that doesn't conform to my way of thinking. - Jamie Hale - 29/05/2002
|
|
|
|
|
Michael Liu wrote:
AllowSetForegroundWindow():
But I can use SetForegroundWindow(). This function needs the same requirements as AllowSetForegroundWindow().
It looks like AllowSetForegroundWindow is a newer function. Have you got the latest platform SDK or are you still using the headers that came with VC6?
Michael
Look, try and use your intelligence, man, even if you are a politician. - The Doctor
|
|
|
|
|
I'm using the headers that comes with VC6(sp5). I have MSDN(Jan. 2002). Is the SDK in that CD? Thx.
mIchAel Liu
|
|
|
|
|
If you have an MSDN subscription other than the Library, you should have a CD with the platform SDK. If you only have a library subscription you'll need to obtain the platform SDK from the MSDN site.
Michael
Look, try and use your intelligence, man, even if you are a politician. - The Doctor
|
|
|
|
|
|
I've installed the latest SDK, how can I updated the vc6 include file? Just copy those files? Thx.
mIchAel Liu
|
|
|
|
|
I feel like I'm missing something - I just try to load a text file into an Multiline EDIT, modify it, and save it again as text file. (should match notepad's behavior of hard line breaks)
Issue: just taking the file size and loading does not work because of the \n <--> \r\n conversion. For saving, it seems to double the line breaks, so it's bad again.
All I came up was either reading line-by-line, or reading as binary and do the replacements on my own. Which sounds a bit awkward.
Any suggestions?
TIA
Peter
We are ugly but we have the music Leonhard Cohen [sighist]
|
|
|
|
|
1) I tried putting the following:
CNewDialog cDlgNoOk;
cDlgNoOk.m_edit1.SetFocus();
Got a debug assert when it ran.
2) Then I tried putting it in the constructor- still asserts:
CNewDialog::CNewDialog(CWnd* pParent /*=NULL*/)
: CDialog(CNewDialog::IDD, pParent)
{
//{{AFX_DATA_INIT(CNewDialog)
none = NULL; // NOTE: the ClassWizard will add member initialization here
//}}AFX_DATA_INIT
m_edit1.SetFocus();
}
3)Finally I put it in :
BOOL CNewDialog::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
m_edit1.SetFocus();
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
It ran without asserting but the editbox didnt get the focus.....
Any suggestion on how to set the focus?
Thanks,
ns
|
|
|
|
|
please read:
>>
m_edit1.SetFocus();
return TRUE; // return TRUE unless you set the focus to a control
<<
We are ugly but we have the music Leonhard Cohen [sighist]
|
|
|
|
|
I'm going to start reading the comments from now on! THanks so much for pointing me to it...
ns
|
|
|
|
|
Hi all.
Since we have written our own web server, our setup has to detect if there is already a application listening on port 80, so we can notify the user about the conflict. How can I get this information?
Regards
Thomas
Sonork id: 100.10453 Thömmi
Disclaimer: Because of heavy processing requirements, we are currently using some of your unused brain capacity for backup processing. Please ignore any hallucinations, voices or unusual dreams you may experience. Please avoid concentration-intensive tasks until further notice. Thank you.
|
|
|
|
|
try bind()ing to the port and if the call fails then something is already on that port. u can however set a socket option to reuse it
bibamus, edamus, cras moriemur [eat, drink, for tomorrow we die]
|
|
|
|
|
Brian Azzopardi wrote:
try bind()ing to the port and if the call fails then something is already on that port. u can however set a socket option to reuse it
I already know this. But I want to know the process which uses this port. Thank you anyway
Regards
Thomas
Sonork id: 100.10453 Thömmi
Disclaimer: Because of heavy processing requirements, we are currently using some of your unused brain capacity for backup processing. Please ignore any hallucinations, voices or unusual dreams you may experience. Please avoid concentration-intensive tasks until further notice. Thank you.
|
|
|
|
|
I also would like to learn how to do it. I am trying to show the ports in use and which processes are using them.
Orcun Colak
|
|
|
|
|
I've only found a solution for Windows XP: AllocateAndGetTcpExTableFromStack in iphlpapi.dll (found in the sources of Netstatp at Sysinternals)
Regards
Thomas
Sonork id: 100.10453 Thömmi
Disclaimer: Because of heavy processing requirements, we are currently using some of your unused brain capacity for backup processing. Please ignore any hallucinations, voices or unusual dreams you may experience. Please avoid concentration-intensive tasks until further notice. Thank you.
|
|
|
|