C / C++ / MFC Discussion Boards

John M. Drescher22-Apr-04 3:02

22-Apr-04 3:02

I am not exactly sure what your problem is. I do use ADO and MS-SQL server all the time without problems. Here is a link to a very good class that makes ADO a lot easier to use:

http://www.codeproject.com/database/caaadoclass1.asp[^]

Wait a minute, I think I have found the problem.

ptrConn->Open(L"Provider=MSDASQL.1;Data Source=data", L"user", L"password", adConnectUnspecified);

I beleive there are two problems with this line as you do not specify the server or the database you want to use.

Here is the connection string that I use to connect to one of my databases:

CString strConnect("Provider=sqloledb;Data Source=(local);Initial Catalog=MageeMammoSQL;User Id=XX; Password=XX;");
hr = connection->Open(
			_bstr_t(strConnect),
			_bstr_t(L""),
			_bstr_t(L""),NULL);

In my case the server is (local) meaning the current pc. And the database on the server is MageeMammoSQL

John

Re: MS-SQL and C++

RChin22-Apr-04 3:15

RChin

22-Apr-04 3:15

If your program works in the JET engine (MS Access), but not in SQL Server, then that suggest a difference in the SQL statement between the two systems.

andysmurfen wrote:
sql = "INSERT INTO opc (datamaskin, server, gruppe, tagnavn) VALUES ('" + nnavn + "', '" + snavn + "', '" + gruppe + "', '" + navn + "')";

for example:
By default the string qualifier for SQL Server is ', not a ", as it is in Access.

try using this for your SQL Server connection and see if it works

I Dream of Absolute Zero

DrawState (CDC) problem

YaronNir22-Apr-04 2:13

YaronNir

22-Apr-04 2:13

Hello,

how can i draw an image that would be transparent? which means will get the background of where it is drawn....

this is the code i use to draw the image:

HBITMAP hBmp = pDlgInf->GetBmp();
CPoint pnt(rc.left + SPACE_WIDTH / 5,rcText.top);
CSize  size(IMAGE_DIMENTIONS,IMAGE_DIMENTIONS);
pDC->DrawState(pnt,size,hBmp,DST_BITMAP);

i see the image fine, but it is not transparent...the transparent color (0,128,128) is shown there...

can any1 help?

thanks in advanced
Yaron

Ask not what your application can do for you,
Ask what you can do for your application

Re: DrawState (CDC) problem

YoSilver22-Apr-04 3:13

YoSilver

22-Apr-04 3:13

DrawState can draw transparent icons only. To draw a transparent bitmap, use the ::TransparentBlt function.

Re: DrawState (CDC) problem

YaronNir22-Apr-04 4:50

YaronNir

22-Apr-04 4:50

Thanks for the reply,

i tried to use TransparentBlt, and i saw the image as transparent, but i got an other problem , if i moved the dialog outside the screen boundaries and then drag it back in, the image was fundged....it didn't appear well.

can u help?

thanks again

Yaron

Ask not what your application can do for you,
Ask what you can do for your application

Re: DrawState (CDC) problem

YoSilver26-Apr-04 10:02

YoSilver

26-Apr-04 10:02

Well... all I think is that you should redraw your bitmap properly, that is, first clear the background and then blitting an image. Use clipping information in PAINTSTRUCT for proper paiting. And try to use double buffering.

How to make CDateTimeCtrl not editable, without arrows ?

vgrigor22-Apr-04 2:11

vgrigor

22-Apr-04 2:11

I need to make CDateTimeCtrl not editable, without arrows ?

<br />
        m_Planer.m_Current_Date .ModifyStyle(0,    DTS_SHORTDATEFORMAT);<br />
        m_Planer.m_Current_Time    .ModifyStyle(0,    DTS_TIMEFORMAT);<br />
//works<br />

not works:

<br />
    m_Planer.m_Current_Date .ModifyStyle(DTS_UPDOWN | DTS_APPCANPARSE ,0 );<br />

How to do subject?

thanks

Re: How to make CDateTimeCtrl not editable, without arrows ?

ravjak22-Apr-04 4:32

ravjak

22-Apr-04 4:32

Hey! You can subclass this control and listen for WM_KEYDOWN message
codes of arrows
VK_LEFT (25)
LEFT ARROW key

VK_UP (26)
UP ARROW key

VK_RIGHT (27)
RIGHT ARROW key

VK_DOWN (28)
DOWN ARROW key

<br />
switch (uiMsg)<br />
	{<br />
case WM_KEYDOWN:<br />
		{<br />
			if(wParam>= VK_LEFT && wParam<=VK_RIGHT)<br />
return 0;<br />
}<br />
<br />
}<br />

try to read something on subclusing on msdn
and probably in this article you will find usefull info

Pain is a weakness living the body

serial comm in w2k

фил22-Apr-04 1:56

фил

22-Apr-04 1:56

i need help with my timeouts. i can get my program to read/write single bytes, but the problem is a function related with the hardware i'm using.

you send the command and the hardware will enter a loop sending you each 3ms 7 bytes.

i can't set the timeouts properly in order to receive all those bytes (the most important thing is that i don't loose any bytes!)...

can anybody please help me??

thank you in advance...

Я люблю русский языкь!

Problem with CStdioFile

Stojan7822-Apr-04 1:36

Stojan78

22-Apr-04 1:36

Hello all

I'm pretty new on C++ and I have a problem. The thing is that I want to write a CString to a CStdioFile and be able to read the string from the file. All I have done so far is a little testprogram, just to se if it worked. It did not! Problem: I get a lot of junk text in my file and when I read from the file. Here is the code, I would be very greatful if anyone could help me a bit.

CStdioFile file;
CString filnamn = "Temp.txt";
CFileException fileException;
char buf1[] = "Hej hej\n";
char buf2[] = "Jag heter henrik\n";
CString rad = "";
CString rad1 = "Hej hej";
CString rad2 = "Jag heter henrik";

if (!file.Open(filnamn, CFile::modeCreate | CFile::modeReadWrite, &fileException))
{
TRACE("Can't open file %s, error = %u\n",
filnamn, fileException.m_cause);
}

file.WriteString(rad1 + '\n');
file.WriteString(rad2 + '\n');
file.ReadString(rad);
printf(rad, "%s");
file.Close();

Re: Problem with CStdioFile

Steve S22-Apr-04 1:53

Steve S

22-Apr-04 1:53

You need to move the file pointer (where in the file you're reading/writing).

Try file.SeekToBegin() before trying to read...

Steve S

Re: Problem with CStdioFile

jmkhael22-Apr-04 1:53

jmkhael

22-Apr-04 1:53

And your printf is erronous

try a printf((LPCTSTR)rad);

Papa

while (TRUE)
Papa.WillLove ( Bebe ) ;

Re: Problem with CStdioFile

RChin22-Apr-04 1:53

RChin

22-Apr-04 1:53

Stojan78 wrote:
file.WriteString(rad1 + '\n');
file.WriteString(rad2 + '\n');
file.ReadString(rad);

Your problems lies with the above statement.
Try this:

<br />
file.WriteString(rad1 + '\n');<br />
file.WriteString(rad2 + '\n');<br />
file.SeekToBegin(); // move file pointer to begining of file.<br />
file.ReadString(rad);<br />

I Dream of Absolute Zero

Re: Problem with CStdioFile

Stojan7822-Apr-04 2:11

Stojan78

22-Apr-04 2:11

Thanks a lot all. It now works just fine...

graphics in c/c++

kcal22-Apr-04 1:36

kcal

22-Apr-04 1:36

i am using visual studio to make some histogram graphs and pie graphs of standered divation but the programme does not recognize the graphics.h header file. how should i make the graphs and please tell what should i do to this heard file (graphics)

graphics in c/c++

Re: graphics in c/c++

Ian Darling22-Apr-04 2:06

Ian Darling

22-Apr-04 2:06

Have a look at Windows GDI instead. You'll be most interested in the DrawLine function, I expect.

If you're on a suitably recent version of Windows, GDI+ (or System.Drawing in .NET) might be more suitable.

GDI:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/winprog/winprog/graphics_device_interface.asp[^]

GDI+:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/gdicpp/GDIPlus/GDIPlus.asp

Ian Darling
"If we've learned anything from history, it's that those who feed trolls are condemned to repetitive conversations. Or something like that." - Eric Lippert

Change Style subsequent on CSlideCtrl

AnTri22-Apr-04 1:13

AnTri

22-Apr-04 1:13

How can I change the Style of an CSlideCtrl subsequent? I need this, because some settings cannot be set on the dialog editor...!

Problem of setting size and position of scrollbar's thumb

bg2sc22-Apr-04 1:06

bg2sc

22-Apr-04 1:06

Thank you for reading this.
Now I want to keep the height and position of vertical scrollbar's thumb all
the time,so I used this Frown | :(

m_ctrlTree' is a TreeListView control)
----------------------------
const int nBar = SB_VERT;
SCROLLINFO si = {0};
si.cbSize = sizeof(si);
si.fMask = SIF_ALL;
m_ctrlTree.GetScrollInfo(nBar, &si);
si.nMax = si.nPage * 2;
si.nPos = (int)si.nPage/2;
m_ctrlTree.SetScrollInfo(nBar, &si, TRUE);
-----------------------------
I placed that block in the 'OnPrePaint' event of the tree control and it really works,but
problem is that when resizing the TreeListView window or expanding a
node, it scrolls madly,perhaps always scrolls to the last record,this is not what I
want.

Is the calculate method right?And where should I place the
SetScrollInfo(nBar, &si, TRUE)to control the Thumb?

Best reguards.
de BG2SC

How do i detect user inactivity ?

rallister22-Apr-04 1:02

rallister

22-Apr-04 1:02

Hi,
in an application that i'm developping, i need to know if there are some user activities at any given time, such as the mouse being moved or the keyboard being used.

Is there any other smarter way to know how, that there are no user activity on the system and how long he was not active. Such a behaviour is used by application for IM, when they set the "away" message !

Thanks in advance for any hints and best regards
Richard

Re: How do i detect user inactivity ?

jmkhael22-Apr-04 1:10

jmkhael

22-Apr-04 1:10

Check OnIdle( LONG lCount ); for MFC

Papa

while (TRUE)
Papa.WillLove ( Bebe ) ;

Re: How do i detect user inactivity ?

rallister22-Apr-04 1:18

rallister

22-Apr-04 1:18

Hi,
i'm not using mfc in my application ;o) !
So please provide a solution without mfc !
Thx in advance and best regards
Richard

Re: How do i detect user inactivity ?

jmkhael22-Apr-04 1:48

jmkhael

22-Apr-04 1:48

From MSDN about OnIdle

OnIdle is called in the default message loop when the application’s message queue is empty. Use your override to call your own background idle-handler tasks.

Why not do the "same" in your main loop?
When no messages are being treated treat Call an OnYourIdle Function

Papa

while (TRUE)
Papa.WillLove ( Bebe ) ;

Re: How do i detect user inactivity ?

David Crow22-Apr-04 2:19

David Crow

22-Apr-04 2:19

Check out GetLastInputInfo().

"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)

Re: How do i detect user inactivity ?

hasansheik22-Apr-04 3:21

hasansheik

22-Apr-04 3:21

If you are using MFC based application u can track it by overriding OnIdle method of CWinApp class.
for direct win32 application u can use WinProc method to track any message is posted on the message queue of the application.

One Best method is, Through Hook. write a WH_MESSAGE hook and do your work fine

I hope it will help you

thanks

Re: How do i detect user inactivity ?

V.22-Apr-04 3:28

22-Apr-04 3:28

Maybe one note on the onidle loop.
It will use a lot of cpu % usage!
You can solve this by setting a start time in your onidle (and then tell it to stop working) and starting a thread which will test this starttime against the currenttime. if a certain time has passed ... (take some action).
Put a Sleep in your thread to keep the cpu % usage down.

Have fun ...

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