SQLConfigDataSource() & string problem - C / C++ / MFC Discussion Boards

Gerry24-Jul-01 3:53

24-Jul-01 3:53

How can I change the colour of the text in a button @ run-time.

I tried to override the onctlcolor method:-

HBRUSH CTestDlg::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor)
{
HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
if (nCtlColor == CTLCOLOR_BTN)
{
pDC->SetTextColor(RGB(255,0,0));//set red
return (HBRUSH) m_Brush.GetSafeHandle();
};
return hbr;
}

m_Brush is a member brush & in OnInitDialog method, I create it with a solid brush.
m_Brush.CreateSolidBrush(RGB(129,129,129));

Thanks

Gerry.

a quastion

24-Jul-01 3:45

Hello all

how do i add TollBar and StatusBar to a dialog window?
thanks

Re: a quastion

Tomasz Sowinski24-Jul-01 3:52

Tomasz Sowinski

24-Jul-01 3:52

MFC sample DLGCBAR32 does exactly that.

Tomasz Sowinski -- http://www.shooltz.com

Making A CFont Go Bold

AJ12324-Jul-01 3:26

AJ123

24-Jul-01 3:26

I am trying to make the text bold in a CStatic. I wrote the following code, Can anyone see where i am going wrong.

CFont *M_titleFont is a member varible.

Code Snippet, from oninitdialog:

LOGFONT lf;
m_titleFont->GetLogFont(&lf);
lf.lfWeight = 700; //Set Bold

m_titleFont->CreateFontIndirect(&lf);

Cheers

Rich

Re: Making A CFont Go Bold

Tomasz Sowinski24-Jul-01 3:40

Tomasz Sowinski

24-Jul-01 3:40

How do you initialize m_titleFont?

Tomasz Sowinski -- http://www.shooltz.com

Re: Making A CFont Go Bold

AJ12324-Jul-01 6:00

AJ123

24-Jul-01 6:00

Oops Missed That Bit Out!

m_titleFont= GetDlgItem(IDC_TITLE)->GetFont();

Thanks Again
Rich

Re: Making A CFont Go Bold

fantastic_mr_fox24-Jul-01 6:26

fantastic_mr_fox

24-Jul-01 6:26

I found I had problems using CreateFontIndirect() with an existing font. But it was easier to create a new font instead.

LOGFONT lf;
m_titleFont->GetLogFont(&lf);
lf.lfWeight = 700; //Set Bold

CFont boldFont;
bolFont.CreateFontIndirect(&lf);

// continue to use boldFont

Hope this helps. =)

=)

SQLConfigDataSource() & string problem

Derek Price24-Jul-01 3:11

Derek Price

24-Jul-01 3:11

Hello,

I am having a trouble using the SQLConfigDataSource() method. I can call it successfully with the code below:

CString sDriver;
sDriver.LoadString(IDS_SYBASE_DRIVER);
bSuccess = SQLConfigDataSource(NULL,ODBC_ADD_DSN,sDriver,
    "DSN=123\0"
    "DatabaseName=123\0"
    "DatabaseFile=E:\\junk.db\0"
    );

But when I try to put the connection string into a CString or the string table, the string gets reduced to "DSN=123" due to the required '\0' value separator. I would like to create a format string like "DSN=%s\0DatabaseName=%s\0DatabaseFile=%s\0" so can create a custom ODBC database.

Any ideas on how to do this?

Thanks in advance!
Derek

Re: SQLConfigDataSource() & string problem

Michael Dunn24-Jul-01 3:22

Michael Dunn

24-Jul-01 3:22

I would like to create a format string like "DSN=%s\0DatabaseName=%s\0DatabaseFile=%s\0"

This doesn't work because the first \0 is interpreted as the end of the format string. AFAIK neither the C string APIs nor CString support embedded null characters. BSTRs do support them, but working with plain BSTRs is a hassle, and CComBSTR doesn't handle embedded nulls well.

What I usually do is use some other unique separator like '|' when building the string, then loop thru the string and replace '|' with '\0'.

--Mike--
http://home.inreach.com/mdunn/
"Make sure that if you are using a blow torch that you don't set anything on fire."
-- Chris Maunder

Re: SQLConfigDataSource() & string problem

Derek Price24-Jul-01 3:35

Derek Price

24-Jul-01 3:35

I understand what you mean by looping through to replace the temporary separator ('|') with the required separator ('\0'), but what do you use to hold the connection string? If I use a '|'-delimited CString and then loop through and replace them with '\0', aren't I in the same boat I was before? Won't the CString still cut the string at the first NULL?

Re: SQLConfigDataSource() & string problem

Michael Dunn24-Jul-01 3:42

Michael Dunn

24-Jul-01 3:42

Won't the CString still cut the string at the first NULL?

hmm... If you absolutely must have your string in a CString, that might be tricky. C-style strings (and thus CStrings) just don't allow embedded nulls, so forcing yourself into using CString is just going to make headaches for you. Is there some specific reason you want to use CString?

--Mike--
http://home.inreach.com/mdunn/
"Make sure that if you are using a blow torch that you don't set anything on fire."
-- Chris Maunder

Re: SQLConfigDataSource() & string problem

Derek Price24-Jul-01 3:46

Derek Price

24-Jul-01 3:46

Absolutely not. I'm just so used to its functionality that I always grab for it first. Smile | :)

It sounds like you've done this before. How did you do it?

Thanks again!

Re: SQLConfigDataSource() & string problem

Michael Dunn24-Jul-01 4:02

Michael Dunn

24-Jul-01 4:02

I just make a big char array and do the procedure I described earlier. Smile | :)

--Mike--
http://home.inreach.com/mdunn/
"Make sure that if you are using a blow torch that you don't set anything on fire."
-- Chris Maunder

Re: SQLConfigDataSource() & string problem

Derek Price24-Jul-01 4:35

Derek Price

24-Jul-01 4:35

I just wanted to thank you for all your help. I ended up using a

vector lt;chargt;

which worked great.

Thanks again!

Re: SQLConfigDataSource() & string problem

Derek Price24-Jul-01 4:33

Derek Price

24-Jul-01 4:33

I just wanted to thank you for all your help. I ended up using a vector<char> which worked great.

Thanks again!

Re: SQLConfigDataSource() & string problem

Mike Burston24-Jul-01 13:04

Mike Burston

24-Jul-01 13:04

You can also use std::string - one of the biggest differences between std::string and CString is that std::string does NOT interpret a '\0' as the end of string, so it fully supports strings containing embedded NULLs.

Re: SQLConfigDataSource() & string problem

Derek Price25-Jul-01 6:44

Derek Price

25-Jul-01 6:44

Just for the heck of it, I tried the std::string method. I had solved this using a vector<char>, but the string method looks a little cleaner. However, I couldn't get it to work with SQLConfigDataSource(). Here's the code:

CString sSybaseDriver,sSybaseConfig;
sSybaseDriver.LoadString(IDS_SYBASE_ODBC_DRIVER);
sSybaseConfig.Format(IDS_SYBASE_ODBC_ADD_DSN);
std::string sConfig(sSybaseConfig);
std::replace(sConfig.begin(),sConfig.end(),'|','\0');
BOOL bSuccess = SQLConfigDataSource(NULL,ODBC_ADD_DSN,sSybaseDriver,sConfig));

The compiler first complained that it couldn't convert a string to const char * for the last parameter in SQLConfigDataSource(). So I changed it to:

BOOL bSuccess = SQLConfigDataSource(NULL,ODBC_ADD_DSN,sSybaseDriver,sConfig.c_str()));

It compiled, but the call to SQLConfigDataSource() failed. The vector<char> is a little messy, but at least it works.

Any ideas on how to get the string version to work or should I just be happy that I found a solution? Smile | :)

Thanks,
Derek

Re: SQLConfigDataSource() & string problem

Carlos Antollini25-Jul-01 7:02

Carlos Antollini

25-Jul-01 7:02

Derek. The string sConfig must be the following format.

"DSN=Personnel Data\0UID=Smith\0PWD=Sesame\0DATABASE=Personnel\0\0"
With Double \0 in the finish. this is very important
Did you do that?

Cheers!!!!

Carlos Antollini.

Re: SQLConfigDataSource() & string problem

Derek Price25-Jul-01 7:08

Derek Price

25-Jul-01 7:08

That was it!!

Thanks for all the help!
Derek

A RichEdit poblem...

24-Jul-01 2:59

when i put (at design time) a RichEdit control on a dialog i cant see the while dialog when i build and run the project.
why? and how can i solve this?

Re: A RichEdit poblem...

Ernest Laurentin24-Jul-01 3:24

Ernest Laurentin

24-Jul-01 3:24

You must call AfxOleInit() and AfxInitRichEdit()
in InitInstance() of your CWinApp object.
Good luck

Thanks a lot!...

24-Jul-01 3:42

Getting Mouse Position

24-Jul-01 2:56

Hi,

I've implemented a system tray icon for my app and I want to have a popup menu for it. I have a message handler created to catch when the user right clicks my icon in the system tray. When this function runs, how should i determine where to place the pop up menu? I can't find a way of determining where the mouse pointer currently is?!?!

Thanks once again

Jay

Re: Getting Mouse Position

Tomasz Sowinski24-Jul-01 3:07

Tomasz Sowinski

24-Jul-01 3:07

Use GetCursorPos or GetMessagePos.

Tomasz Sowinski -- http://www.shooltz.com

Re: Getting Mouse Position

29-Aug-01 12:44

This should work for you.

CPoint point;

pPopUpMenu->TrackPopupMenu(TPM_LEFTALIGN | TPM_LEFTBUTTON,
point.x, point.y, AfxGetMainWnd());

Last Visit: 31-Dec-99 18:00 Last Update: 22-Jun-24 13:32

Refresh

ᐊ Prev 1...18154 18155 18156 181571815818159 18160 18161 18162 18163 Next ᐅ

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