C / C++ / MFC

31-Oct-04 8:08

Dear All,

I am developing a Win32 Application in Windows API VC6.0, I need to use an MS Access 2000 Database to connect to. Reading some of the Articles on codeproject site, but could not decide what is the best to use:
ADO
COM
DAO
ODBC
My Appliction need to run smootly on Windows 9x, 2k and XP?
=======================
Just reading the Article: Express OLE DB Library: An ideal data access solution for C++ By Ghanshyam Naik, I decided to use ODBC for my project.

Any help is appreciate to connect to MS ACCESS using ODBC (NOT MFC) or using MFC Classes in Win32 and Win API Programming.

WinAPILaerner

David Crow1-Nov-04 6:27

1-Nov-04 6:27

WinAPILearner wrote:
...but could not decide what is the best to use:

"Best" is a subjective term. It all depends on what you are after as to what technology you would use. How big is the database? How many connections are you expecting to support? Can the database be accessed by more than one connection at a time? How many transactions-per-second do you expect? Does the database need to be backed up while in use? This is not an all-inclusive list of questions.

WinAPILearner wrote:
Any help is appreciate to connect to MS ACCESS using ODBC (NOT MFC) or using MFC...

You want to connect to an Access database without using MFC, but you want help with MFC. Is that correct?

"Opinions are neither right nor wrong. I cannot change your opinion of me. I can, however, change what influences your opinion." - David Crow

WinAPILearner1-Nov-04 21:34

1-Nov-04 21:34

Dear David Crow,

I would like to use ODBC, Win API in a Win32 Application, my Database is just a catalog. Select ProductID in listbox and then Show Other Information in a Static text windows.

I found this Interesting Article but it is MFC, I want the same thing in Win API.
href="http://www.codeproject.com/database/readdb.asp#xx467253xx">
Using the CDatabase class to read an Access databases

I posted my code to the author, I will appreciate if you have a look at.

Thanks

David Crow2-Nov-04 2:30

2-Nov-04 2:30

WinAPILearner wrote:
I would like to use ODBC, Win API in a Win32 Application,

Check out functions like, but not limited to:

SQLGetData
SQLExecDirect
SQLFetch
SQLPutData
SQLConnect
SQLSetParam
...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcodbc_api_reference.asp

"Opinions are neither right nor wrong. I cannot change your opinion of me. I can, however, change what influences your opinion." - David Crow

David Crow2-Nov-04 7:48

2-Nov-04 7:48

With all of the examples available on MSDN and Google, what specifically is giving you grief?

"Opinions are neither right nor wrong. I cannot change your opinion of me. I can, however, change what influences your opinion." - David Crow

David Crow2-Nov-04 8:04

2-Nov-04 8:04

Did you look at these examples:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqlconnect.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqlbindcol.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqlgetdata.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcconnecting_with_sqlconnect.asp

http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/ad/samples/cli/s-dbmcon-c.htm

"Opinions are neither right nor wrong. I cannot change your opinion of me. I can, however, change what influences your opinion." - David Crow

WinAPILearner2-Nov-04 10:09

2-Nov-04 10:09

Under the odbcsqlconnect.asp I copied this sample code, but it give me 9 Errors. Some others do not have samples. I get a lot of errors including any SQLxx.h files.

SQLHENV henv;
SQLHDBC hdbc;
SQLHSTMT hstmt;
SQLRETURN retcode;

/*Allocate environment handle */
retcode = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);

if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
/* Set the ODBC version environment attribute */
retcode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0);

if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
/* Allocate connection handle */
retcode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);

if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
/* Set login timeout to 5 seconds. */
SQLSetConnectAttr(hdbc, (void*)SQL_LOGIN_TIMEOUT, 5, 0);

/* Connect to data source */
retcode = SQLConnect(hdbc, (SQLCHAR*) "TEST", SQL_NTS,
(SQLCHAR*) "tUser", SQL_NTS,
(SQLCHAR*) "tPass", SQL_NTS);

if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO){
/* Allocate statement handle */
retcode = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);

if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
/* Process data */
// ;
// ;
// ;
//
SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
}
SQLDisconnect(hdbc);
}
SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
}
}
SQLFreeHandle(SQL_HANDLE_ENV, henv);
}

David Crow2-Nov-04 10:24

2-Nov-04 10:24

WinAPILearner wrote:
...but it give me 9 Errors.

And those errors would be?

WinAPILearner wrote:
Some others do not have samples.

All of the links I provided have examples.

WinAPILearner wrote:
I get a lot of errors including any SQLxx.h files.

What are they?

How are you using this code snippet? What other .h files have you included?

"Opinions are neither right nor wrong. I cannot change your opinion of me. I can, however, change what influences your opinion." - David Crow

WinAPILearner2-Nov-04 20:12

2-Nov-04 20:12

following is my implimentation
#include <windows.h>
#include <odbcinst.h>
#include <sqldb.h>
............ Other codes
void FillListBox (HWND hwndList)
{
SQLHENV henv;
SQLHDBC hdbc;
SQLHSTMT hstmt;
SQLRETURN retcode;
/*Allocate environment handle */
retcode = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
/* Set the ODBC version environment attribute */
retcode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0);
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
/* Allocate connection handle */
retcode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
/* Set login timeout to 5 seconds. */
SQLSetConnectAttr(hdbc, (void*)SQL_LOGIN_TIMEOUT, 5, 0);
/* Connect to data source */
retcode = SQLConnect(hdbc, (SQLCHAR*) "TEST", SQL_NTS,
(SQLCHAR*) "tUser", SQL_NTS,
(SQLCHAR*) "tPass", SQL_NTS);
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO){
/* Allocate statement handle */
retcode = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
/* Process data */
//SendMessage (hwndList, LB_ADDSTRING, 0, (LPARAM) "TEST") ;
SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
}
SQLDisconnect(hdbc);
}
SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
}
}
SQLFreeHandle(SQL_HANDLE_ENV, henv);
}

:\program files\microsoft visual studio\vc98\include\sqldb.h(56) : error C2143: syntax error : missing ')' before '*'
e:\program files\microsoft visual studio\vc98\include\sqldb.h(56) : error C2143: syntax error : missing ';' before '*'
e:\program files\microsoft visual studio\vc98\include\sqldb.h(56) : error C2059: syntax error : ')'
e:\program files\microsoft visual studio\vc98\include\sqldb.h(56) : error C2061: syntax error : identifier 'PDBPROCESS'
e:\program files\microsoft visual studio\vc98\include\sqldb.h(56) : error C2501: 'DBERRHANDLE_PROC' : missing storage-class or type specifiers
e:\program files\microsoft visual studio\vc98\include\sqldb.h(57) : error C2226: syntax error : unexpected type 'SQLAPI'
e:\program files\microsoft visual studio\vc98\include\sqldb.h(59) : error C2146: syntax error : missing ';' before identifier 'SQLAPI'
e:\program files\microsoft visual studio\vc98\include\sqldb.h(59) : error C2373: 'DBERRHANDLE_PROC' : redefinition; different type modifiers
e:\program files\microsoft visual studio\vc98\include\sqldb.h(56) : see declaration of 'DBERRHANDLE_PROC'
e:\program files\microsoft visual studio\vc98\include\sqldb.h(59) : fatal error C1004: unexpected end of file found
Error execu

David Crow3-Nov-04 2:31

3-Nov-04 2:31

You must include sqlfront.h before sqldb.h.

"Opinions are neither right nor wrong. I cannot change your opinion of me. I can, however, change what influences your opinion." - David Crow

WinAPILearner3-Nov-04 7:42

3-Nov-04 7:42

e:\program files\microsoft visual studio\vc98\include\sqlfront.h(126) : error C2146: syntax error : missing ';' before identifier 'LPINT'
e:\program files\microsoft visual studio\vc98\include\sqlfront.h(126) : error C2040: 'PTR' : 'int' differs in levels of indirection from 'void *'
e:\program files\microsoft visual studio\vc98\include\sqlfront.h(126) : fatal error C1004: unexpected end of file found

Now geting 3 Errors in sqlfront.h

David Crow3-Nov-04 9:41

Console Threading Problem

3-Nov-04 9:41

In what order do you have the #include statements?

"Opinions are neither right nor wrong. I cannot change your opinion of me. I can, however, change what influences your opinion." - David Crow

Joe_Sextus31-Oct-04 7:36

Joe_Sextus

31-Oct-04 7:36

I am writing a program that runs another program and prints the second program's output in first's console, but the second program's output is printed before output in the first program.

Here's my code

<br />
#include <windows.h><br />
#include <tchar.h><br />
#include <iostream.h><br />
<br />
void main(void)<br />
{<br />
  PROCESS_INFORMATION pi;<br />
  STARTUPINFO si;<br />
<br />
  ZeroMemory(&si,sizeof(STARTUPINFO));<br />
  si.cb = sizeof(STARTUPINFO);<br />
<br />
  cout << _T("Starting ver...\n");<br />
  <br />
  if(CreateProcess(NULL, _T("cmd /c ver"), NULL, NULL,<br />
                   TRUE, 0, NULL, NULL, &si, &pi))<br />
  {    <br />
    DWORD ExitCode = 0;<br />
    DWORD ErrorCode = 0;<br />
    <br />
    do<br />
    {<br />
      Sleep(100);<br />
      if(GetExitCodeProcess(pi.hProcess, &ExitCode) == 0)<br />
      {<br />
        cout << _T("GetExitCodeProcess Error: ");<br />
        cout << GetLastError() << endl;<br />
      }<br />
    }while(ExitCode == STILL_ACTIVE);<br />
    <br />
    CloseHandle(pi.hThread);<br />
  }  <br />
  cout << _T("Finsihed with ver\n");<br />
} //void main(void)<br />

and here is the program output

Microsoft Windows XP [Version 5.1.2600]
Starting ver...
Finsihed with ver

The program should output "Starting ver..." before it runs version. The output doen't change if I use printf instead of cout either.

Does anybody know of a solution? It has me stumped.

Thanks in advance.
-Joe

Re: Console Threading Problem

Ryan Binns31-Oct-04 17:57

Ryan Binns

31-Oct-04 17:57

cout buffers the data before it writes it to the screen. Try using cout.flush() before creating the process to force the buffer to be written to the screen immediately.

Ryan

"Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late" John Nichol "Point Of Impact"

Re: Console Threading Problem

Joe_Sextus31-Oct-04 18:31

Joe_Sextus

31-Oct-04 18:31

Thanks that fixed the problem.

Re: Operating System for Developers

Christian Graus31-Oct-04 9:07

Christian Graus

31-Oct-04 9:07

That is truly the stupidest thing I ever heard. If an OS is only for programmers, what programs will you write under it, and who will use them ? There's nothing so wrong with Windows ( or Linux for that matter ) that you and your team are likely to fix it. Your best bet would probably be to hack a linux distro to do what you and the 3 other people who will use it want from it.

Christian

I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

How to hook system API under windows 9x?

jedyking31-Oct-04 6:36

jedyking

31-Oct-04 6:36

I want to write a skinnable scrollbar, I need hook system scrollbar group API, how can I do that?

I can hook these API called from my process, bu if I process call comctl32.dll and comctl32.dll call these API, I can hook it? How can I hook these API called in comctl32.dll? any demo code will helpful.

User 665831-Oct-04 8:25

User 6658

31-Oct-04 8:25

http://www.codeproject.com/dll/apihijack.asp

I don't know if this works on 9x-based OS, though

modified 12-Sep-18 21:01pm.

jedyking1-Nov-04 5:28

jedyking

1-Nov-04 5:28

I want to hook COMCTL32.DLL's import function table or I want to replace the GetScrollBarInfo API 's enter address in user32.dll , because win98 share system DLL in the same address space and protect it, how can I do this??

==============================================
SkinMagic SDK Library for C/C++
The better solution for write skinnable application
http://www.appspeed.com
==============================================

ThatsAlok31-Oct-04 17:29

ThatsAlok

31-Oct-04 17:29

there is very good example in system section for system wide Hooks including 9x.i think this may help

-----------------------------
"I Think It Will Help"
-----------------------------
Alok Gupta
visit me at http://www.thisisalok.tk