Re: Embedding SQL in C - C / C++ / MFC Discussion Boards

Re: USB-to-COM problem in WinXP Home Edition

tctan13-Jul-06 23:08

tctan

13-Jul-06 23:08

It is in RELEASE mode.

Thanks.

Create ActiveX from dialog used other ActiveX

majco33313-Jul-06 21:53

majco333

13-Jul-06 21:53

Hi,

I need create ActiveX control. I know to create ActiveX control from dialog, but
now I have dialog which use other ActiveX and I don't know how do it.

Please help me somebody. Thanks

Re: Create ActiveX from dialog used other ActiveX

NiceNaidu13-Jul-06 22:49

NiceNaidu

13-Jul-06 22:49

majco333 wrote:
I have dialog which use other ActiveX and I don't know how do it

First u need to register the OCX.

Follow these steps to register:

1.On the Taskbar, select Start > Run.
2.In the Open field, type regsvr32 "<path>\Strip.OCX", where <path> is the directory where the file is located on your computer and NameOfFile.extension is the name of the file. For example:
regsvr32 "C:\Windows\System32\Strip.OCX"

To insert the registered ActiveX into your current project:

1.Projects->Add to Project->Components and Controls->Registered ActiveX controsl and select that particular ActiveX control.

Appu..
"If you judge people, you have no time to love them."

Re: Create ActiveX from dialog used other ActiveX

majco33313-Jul-06 22:58

majco333

13-Jul-06 22:58

I knew this.. By the create Dialog is error:

CDialog->Create(IDD_DIALOG,this);

this dialog own other ActiveX, I think that because is error by the create of dialog..

I don't know to solve this problem..

Re: Create ActiveX from dialog used other ActiveX

NiceNaidu13-Jul-06 23:04

NiceNaidu

13-Jul-06 23:04

majco333 wrote:
CDialog->Create(IDD_DIALOG,this);

this dialog own other ActiveX, I think that because is error by the create of dialog..

What does this mean ?? I do not understand.

Appu..
"If you judge people, you have no time to love them."

Re: Create ActiveX from dialog used other ActiveX

majco33313-Jul-06 23:27

majco333

13-Jul-06 23:27

I make usage dialog for the ePad, which use ActiveX control for the ePad..
And now I need rebuild this dialog on the ActiveX control because it is necessary for the
adition to main application.. This application will be used this dialog..

Embedding SQL in C [modified]

Rajiya13-Jul-06 21:46

Rajiya

13-Jul-06 21:46

Hi,
I am trying to run an embeded SQL code using C in the VC++ environment.
I wanted to knw how to bind the DSN with the IP addres so that i can get connected to a remote server.Following is the code: What value should i write for the Data Source?

#include<windows.h>
#include<sqlext.h>
#include<stdio.h>
#include<string.h>
int main(void)
{
HENV hEnv = NULL; // Env Handle from SQLAllocEnv()
HDBC hDBC = NULL; // Connection handle
HSTMT hStmt = NULL;// Statement handle
UCHAR szDSN[SQL_MAX_DSN_LENGTH] = "Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=Northwind;Data Source=10.11.50.15 ";// Data Source Name buffer
UCHAR szUID[10] = "sa";// User ID buffer
UCHAR szPasswd[10] = "mis";// Password buffer

UCHAR szModel[128];// Model buffer
SDWORD cbModel;// Model buffer bytes recieved

char buff[9] = "fgddg";
UCHAR szSqlStr[150]= "INSERT into JON(branch_name, balance)Values ('fgddg',3)" ;

RETCODE retcode;

//sprintf((char*)szSqlStr,"INSERT into (Tablename)(Columname) Values ('%s')",buff);
// Allocate memory for ODBC Environment handle
SQLAllocEnv (&hEnv);

// Allocate memory for the connection handle
SQLAllocConnect (hEnv, &hDBC);

// Connect to the data source "test" using userid and password.
retcode = SQLConnect (hDBC, szDSN, SQL_NTS, szUID, SQL_NTS, szPasswd, SQL_NTS);

if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
{
// Allocate memory for the statement handle
retcode = SQLAllocStmt (hDBC, &hStmt);

// Prepare the SQL statement by assigning it to the statement handle
retcode = SQLPrepare (hStmt, szSqlStr, sizeof (szSqlStr));

// Execute the SQL statement handle
retcode = SQLExecute (hStmt);

// Project only column 1 which is the models
SQLBindCol (hStmt, 1, SQL_C_CHAR, szModel, sizeof(szModel), &cbModel);

SQLBindCol (hStmt, 2, SQL_C_FLOAT, szModel, sizeof(szModel), &cbModel);
// Get row of data from the result set defined above in the statement
retcode = SQLFetch (hStmt);

// Free the allocated statement handle
SQLFreeStmt (hStmt, SQL_DROP);

// Disconnect from datasource
SQLDisconnect (hDBC);
}

printf("Done");
// Free the allocated connection handle
SQLFreeConnect (hDBC);

// Free the allocated ODBC environment handle
SQLFreeEnv (hEnv);

return 0;
}

Riz

-- modified at 3:53 Friday 14th July, 2006

Re: Embedding SQL in C

David Crow14-Jul-06 2:47

David Crow

14-Jul-06 2:47

The DSN is what contains the host name or IP address of the machine hosting the database. SQLConnect() should simply be referencing that DSN. It looks as though you might be mixing a DSN and a DSN-less connection.

"Money talks. When my money starts to talk, I get a bill to shut it up." - Frank

"Judge not by the eye but by the heart." - Native American Proverb

Win32 API

Kuroro Rucilful13-Jul-06 21:35

Kuroro Rucilful

13-Jul-06 21:35

hello everyone,

I've written a simple application that has a class(Class_A) called by WinMain's Controller class under function "Command(int cmd)" specifically IDM_RUN_PROG. The code compiles but it throws an "Access Violation" error when run. Also debugging it produced this message "DAMAGE: after Normal block(#50) at 0x008651C0"

I've declared a new pointer of Class_A within the Command(int cmd) function under Controller class. Confused | :confused:

"You have to be in a situation where you see just how fast things fail to make you take it seriously, I guess. " Bruce Eckel

Re: Win32 API

NiceNaidu13-Jul-06 21:40

NiceNaidu

13-Jul-06 21:40

Can you post the code,where you u r getting the error.

Appu..
"If you judge people, you have no time to love them."

Re: Win32 API

KarstenK13-Jul-06 22:09

KarstenK

13-Jul-06 22:09

A typical pointer problem. In your programm you are using a pointer with a bad target or are writing after end.
ie: char sz[5];
sz[7] = 0;//DAMAGE !!!!

Do single line debugging an check when there is access to the damaged memory.

Greetings from Germany

Re: Win32 API

Hamid_RT14-Jul-06 2:14

Hamid_RT

14-Jul-06 2:14

Can you be more specific

whitesky

Enable screen jumping(with condition applied) concepts

Ting Li Che13-Jul-06 21:31

Ting Li Che

13-Jul-06 21:31

Dear all,

Currently, I would like to add on a message box on each dialog in the project and enable user to just key in the numbers and then the current screen will jump to the desired screen, provided that the screen is not tied to any previous screen(if so, then it will then choose to jump to the first screen of the series. eg: if you wanna access C from A, then if you key in C, then it will then redirect to the B page first because it need to go through B before reaching C).

Please give any concepts or methods on how to handle this screen jumping at all existing screen in a project.

Thank you very much. Cool | :cool:

menu item with image

Amit Agarrwal13-Jul-06 20:40

Amit Agarrwal

13-Jul-06 20:40

hello
when i make menu..we usually write text for the menu item.but i want insert image along with the menu item.
how can i do it.
thanx

Re: menu item with image

*Dreamz13-Jul-06 20:55

*Dreamz

13-Jul-06 20:55

Check this.

CP - Menus section you can find many articles on this.

Re: menu item with image

_AnsHUMAN_ 13-Jul-06 20:55

_AnsHUMAN_

13-Jul-06 20:55

See Here[^]

Somethings seem HARD to do, until we know how to do them.
Wink | ;-)

_AnShUmAn_

Re: menu item with image

Hamid_RT14-Jul-06 1:49

Hamid_RT

14-Jul-06 1:49

See Here[^] and Here[^]

whitesky

Re: menu item with image

Amit Agarrwal13-Jul-06 21:20

Amit Agarrwal

13-Jul-06 21:20

hi

thanx for replying but my application is a Dialog Based Application and i hav menu in dialog.and images can be individual images.

plz clear my doubt.

thanx

Re: menu item with image

*Dreamz13-Jul-06 21:27

*Dreamz

13-Jul-06 21:27

I think the link that i provided itself has a dialog based sample..

how to show other language in list box???

mimimimilaw13-Jul-06 20:27

mimimimilaw

13-Jul-06 20:27

In my list box , I input some chinese texts. However, it slow "&d2" to replace the words. How can i solve this problem?

Re: how to show other language in list box???

NiceNaidu13-Jul-06 21:38

NiceNaidu

13-Jul-06 21:38

Try writing the application using unicode.

Appu..
"If you judge people, you have no time to love them."

Re: how to show other language in list box??? [modified]

mimimimilaw13-Jul-06 21:41

mimimimilaw

13-Jul-06 21:41

but it can't using unicode....another methods?
and i try to using unicode...it can't

-- modified at 3:41 Friday 14th July, 2006

Probelm in linking my library to program

we3Guy13-Jul-06 20:11

we3Guy

13-Jul-06 20:11

i'm facing a problem, can someone help me with it? i do not know how come the window is unable to detect the location of the library files...
It goes like this:

//
// BioAPIClass.h
// Classes to simplify using the BioAPI from an application
//

#if ! defined (BIOAPICLASS_H)
#define BIOAPICLASS_H

// ../../../BioAPI/include/
// ../../../BioAPI/addins/maf
// ../../../BioAPI/imports/cdsa/v2_0/inc/

#if ! defined(USE_DEFAULT_PATHS) //FPC software structure

#include "bioapi_schema.h" // For data types etc
#include "port/bioapi_lock.h" // Needed for maf_collectn
#include "port/bioapi_port.h" // Needed for maf_collectn
#include "bioapi_err.h" // Needed for maf_collectn
#include "maf_collectn.h" // Needed for maf_util
#include "maf_util.h" // For App_Malloc, App_Free

#include "..\BioAPICommon\BioAPICommon.h" // Things common to application and BSP side
#include "..\BioAPICommon\FPCoreErrors.h" // FPC Specific error codes
#include "..\BioAPICommon\FPCoreConfig.h" // FPC specific additions
#include "..\CmnLibrary\CmnRegistry.h" // For registry access
#include "..\CmnLibrary\CmnDataStorage.h" // Data storage
#else //Default software structure
#include "..\..\..\BioAPI Consortium\BioAPI\source\include\bioapi_schema.h" // For data types etc
#include "..\..\..\BioAPI Consortium\BioAPI\source\include\port\bioapi_lock.h" // Needed for maf_collectn
#include "..\..\..\BioAPI Consortium\BioAPI\source\include\port\bioapi_port.h" // Needed for maf_collectn
#include "..\..\..\BioAPI Consortium\BioAPI\source\include\bioapi_err.h" // Needed for maf_collectn
#include "..\..\..\BioAPI Consortium\BioAPI\source\addins\maf\maf_collectn.h" // Needed for maf_util
#include "..\..\..\BioAPI Consortium\BioAPI\source\addins\maf\maf_util.h" // For App_Malloc, App_Free

#include "..\inc\BioAPICommon.h" // Things common to application and BSP side
#include "..\inc\FPCoreErrors.h" // FPC Specific error codes
#include "..\inc\FPCoreConfig.h" // FPC specific additions
#include "..\inc\CmnRegistry.h" // For registry access
#include "..\inc\CmnDataStorage.h" // Data storage
#endif

WHEN I COMPILE, IT SAYS:

Compiling...
FPCore Test.cpp
c:\documents and settings\student\desktop\research\fp\pc software\new folder\inc\bioapiclass.h(28) : fatal error C1083: Cannot open include file: '..\..\..\BioAPI Consortium\BioAPI\source\include\bioapi_schema.h': No such file or directory
FPCore TestDlg.cpp
c:\documents and settings\student\desktop\research\fp\pc software\new folder\inc\bioapiclass.h(28) : fatal error C1083: Cannot open include file: '..\..\..\BioAPI Consortium\BioAPI\source\include\bioapi_schema.h': No such file or directory
Error executing cl.exe.

FPCore TestD.exe - 2 error(s), 0 warning(s)

THIS IS WHERE MY LIBRARY FILES ARE KEPT:

C:\Documents and Settings\student\Desktop\research\FP\PC Software\New Folder\inc\

bioapi100.lib
bioapi_util.lib
BioAPIClasses.lib
BioAPIClassesD.lib
CmnLibrary.lib
CmnLibraryD.lib

PLESAE HELP ME WITH IT~ THANKS

Thanks & Regards

Re: Probelm in linking my library to program

NiceNaidu13-Jul-06 21:29

NiceNaidu

13-Jul-06 21:29

If u r using VC6,

Try this.

Go to Tools->Options->Directories and Include those all files and rebuild the application.

Appu..
"If you judge people, you have no time to love them."

Re: Probelm in linking my library to program

we3Guy13-Jul-06 21:59

we3Guy

13-Jul-06 21:59

C:\DOCUMENTS AND SETTINGS\STUDENT\DESKTOP\RESEARCH\FP\PC SOFTWARE\NEW FOLDER\INC

this is what i've included according to ur advise.. but still, the errors are still exists... hmmm... why is that so? Confused | :confused:

Please help... Thanks

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