|
I dont know how to connect with SQL server 2000 and retrive the data?
i belive that u can help me.
thanks in advance
JAYARAJ
|
|
|
|
|
To retrieve data from SQL SERVER, make first an Accessor.Do that in your project workspace:
Click on Insert -> New ATL Object; in catégories choice Data Access->Consumer from here enter the name of your database; password;choice command and click on ok after choice the table you want to access, click in ok again.
Here a Class Accessor is generate.
Now in your event write this code :
bool bsavevalidation = true;
CWnd::UpdateData(bsavevalidation);
HRESULT hr;
CDataSource db;
CDBPropSet dbinit(DBPROPSET_DBINIT);
CString strItem;
int k = 0;
CSession session;
CString strCommand,strSql;
dbinit.AddProperty(DBPROP_AUTH_PASSWORD, OLESTR("yhwha"));
dbinit.AddProperty(DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO, false);
dbinit.AddProperty(DBPROP_AUTH_USERID, OLESTR("sa"));
dbinit.AddProperty(DBPROP_INIT_CATALOG, OLESTR("STOCK"));
dbinit.AddProperty(DBPROP_INIT_DATASOURCE, databas);
dbinit.AddProperty(DBPROP_INIT_LCID, (long)1036);
dbinit.AddProperty(DBPROP_INIT_PROMPT, (short)4);
hr = db.Open(_T("SQLOLEDB.1"), &dbinit);
if (FAILED(hr))
{
AfxMessageBox("impossible d'ouvrir la baseo");
}
else
{
hr = session.Open(db);
if (FAILED(hr))
{
AfxMessageBox("session non Ouverte");
}
else
{
CDBPropSet propset(DBPROPSET_ROWSET);
propset.AddProperty(DBPROP_CANFETCHBACKWARDS, true);
propset.AddProperty(DBPROP_IRowsetScroll, true);
propset.AddProperty(DBPROP_IRowsetChange, true);
propset.AddProperty(DBPROP_UPDATABILITY, DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE );
bool bsavevalidation = true;
CWnd::UpdateData(bsavevalidation);
CCommand<caccessor<cdbotabcmdeaccessor> >cmde ;
CCommand<caccessor<cdborequisitionaccessor> >req ;
CCommand<caccessor<cdbodemprixaccessor> >dem ;
CCommand<caccessor<cdbodetcmde2accessor> >det ;
CCommand<caccessor<cdbodetlivaccessor> >liv ;
CString str1,str2,str3,str4,str5,str6,str7,str8,str9,str0 = "";
int i = 0;
strCommand = "select * from detcmde where numreq = '%s'";
strSql.Format(strCommand,m_numcmde);
hr = det.Open(session, strSql,NULL);
if (det.MoveFirst() != S_OK)
{
|
|
|
|
|
i got error as
error C2065: databas: undeclared identifier in
dbinit.AddProperty(DBPROP_INIT_DATASOURCE, databas);
may i know why thise error occur?
JAYARAJ
|
|
|
|
|
It's true that you have this error because databas is a CString variable that contain the path of the database for example
CString databas = "SEM1" .
If you point mouse on the sql server Icon at bottom of the screen, you will see like this :Running- \\SEM1 MSSQLSERVER
SEM1 is the name of my database path.
In my second pc i have this Running- \\sem2\sem1 and here the path name is
"SEM2\\SEM1":
you can declare CString databas = CString "SEM2\\SEM1";
You will be happy
|
|
|
|
|
it is true;
I have declare this before :
CString databas = CString("SEM1"); It's the name of the databas path. You will the name of databas when you point the mouse on the icon of sql server on the bottom of the screen I see Running- \\SEM1 MSSQLSERVER
In the second pc i have Running- \\SEM2\SEM1 and in this condition the name of the path is "SEM2\\SEM1"
You will be happy
|
|
|
|
|
hello mikobi,
i like to display the table in my text area on clicking ok button.
my database server is in ist17
my database name is IstEncoder
my table is user_details
is my path is correct ?
what modificaton i should do in your code.
thanks in advance
=============================================================================void CDatabaseDlg::OnOK()
{
// TODO: Add extra validation here
bool bsavevalidation = true;
CWnd::UpdateData(bsavevalidation);
HRESULT hr;
CDataSource db;
CDBPropSet dbinit(DBPROPSET_DBINIT);
CString databas = "ist17";
CString strItem;
int k = 0;
CSession session;
CString strCommand,strSql;
dbinit.AddProperty(DBPROP_AUTH_PASSWORD, OLESTR("yhwha"));
dbinit.AddProperty(DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO, false);
dbinit.AddProperty(DBPROP_AUTH_USERID, OLESTR("sa"));
dbinit.AddProperty(DBPROP_INIT_CATALOG, OLESTR("STOCK"));
dbinit.AddProperty(DBPROP_INIT_DATASOURCE, databas);
dbinit.AddProperty(DBPROP_INIT_LCID, (long)1036);
dbinit.AddProperty(DBPROP_INIT_PROMPT, (short)4);
hr = db.Open(_T("SQLOLEDB.1"), &dbinit);
if (FAILED(hr))
{
AfxMessageBox("impossible d'ouvrir la baseo");
}
else
{
hr = session.Open(db);
if (FAILED(hr))
{
AfxMessageBox("session non Ouverte");
}
else
{
CDBPropSet propset(DBPROPSET_ROWSET);
propset.AddProperty(DBPROP_CANFETCHBACKWARDS, true);
propset.AddProperty(DBPROP_IRowsetScroll, true);
propset.AddProperty(DBPROP_IRowsetChange, true);
propset.AddProperty(DBPROP_UPDATABILITY, DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE );
bool bsavevalidation = true;
CWnd::UpdateData(bsavevalidation);
CCommand >cmde ;
CCommand >req ;
CCommand >dem ;
CCommand >det ;
CCommand >liv ;
CString str1,str2,str3,str4,str5,str6,str7,str8,str9,str0 = "";
int i = 0;
strCommand = "select * from detcmde where numreq = '%s'";
strSql.Format(strCommand,m_numcmde);
}
CDialog::OnOK();
}
}
=============================================================================
My Error -------------------------------------------------------------------------------------------------------------------------------------------------
error C2143: syntax error : missing ';' before '>'
error C2143: syntax error : missing ';' before '>'
error C2143: syntax error : missing ';' before '>'
error C2143: syntax error : missing ';' before '>'
error C2143: syntax error : missing ';' before '>'
error C2143: syntax error : missing ';' before '>'
error C2143: syntax error : missing ';' before '>'
error C2143: syntax error : missing ';' before '>'
error C2143: syntax error : missing ';' before '>'
error C2143: syntax error : missing ';' before '>'
error C2065: 'm_numcmde' : undeclared identifier
JAYARAJ
|
|
|
|
|
hi friends,
can anyone help me or guide me to create installable packages for the projects which i do in Visual c++ or visual basic.
i need to know what are the files to be packed with the execultable file and how to pack them.
Vasanth.
|
|
|
|
|
Hi,
For Visual Basic you can use the package and deployment tool to create installable package.
For Visual C++ - try InstallShield or free installer InnoSetup
InnoSetup[^]
These installers provide good wizards and take care most of the packaging operations.
Bye,
Cool Ju 
Dream Ur Destiny
|
|
|
|
|
hi
i have created a dialog based MFC application.
But when i compile i get the following error
fatal error C1189: #error : WINDOWS.H already included. MFC apps must not #include <windows.h>
this is due to the following code in AFXV_W32.H (which ships with VC6)
#ifdef _WINDOWS_
#error WINDOWS.H already included. MFC apps must not #include <windows.h>
#endif
how to fix it?i didn't define _WINDOWS_ anywhere in my code but it still throws up the error
"Every morning I go through Forbes list of 40 richest people in the world. If my name is not in there, I go to work..!!!"
-- modified at 0:48 Wednesday 1st March, 2006
|
|
|
|
|
QuickDeveloper wrote: fatal error C1189: #error : WINDOWS.H already included. MFC apps must not #include <windows.h>
MFC Applications should not include windows.h as MFC includes it internally.
Nibu thomas
Software Developer
|
|
|
|
|
i did not include windows.h anywhere,even then it throws the error
"Every morning I go through Forbes list of 40 richest people in the world. If my name is not in there, I go to work..!!!"
|
|
|
|
|
What are the headers that you have included?
Nibu thomas
Software Developer
|
|
|
|
|
i included the following files in stdafx.h.i did the application by reading this article
http://www.codeproject.com/com/clientserverwithdcom.asp[^]
//the following files are included in stdafx.h which is in dialog based Client Application.
#import "..//DCOMServer/DCOMServer.tlb" //here DCOMServer is the name of service created using Appwizard.
#include "afxctl.h"
#include "objbase.h"
#include "initguid.h"
"Every morning I go through Forbes list of 40 richest people in the world. If my name is not in there, I go to work..!!!"
-- modified at 1:34 Wednesday 1st March, 2006
|
|
|
|
|
This is how windows.h is included in MFC...
afxwin.h
--afx.h
---afxver_.h
----afxv_w32.h
-----windows.h
Nibu thomas
Software Developer
|
|
|
|
|
In the output window, what .cpp file is being compiled when the C1189 error is produced? What other #include statements do you have besides those in stdafx.h?
"Let us be thankful for the fools. But for them the rest of us could not succeed." - Mark Twain
"There is no death, only a change of worlds." - Native American Proverb
|
|
|
|
|
|
Hello. I want to call the DrawGLScene() function inside an opengl window found on one of my dialog boxes. The fucntion is supposed to draw a terrain inside the window but all im getting is a black screen. when i integrate a simple opengl code, like one for drawing a triangle, it works (i.e. the triangle is displayed in the window). if we create a separate opengl window for diaplaying the terrain, it works perfectly. my problem is to integrate the terrain code inside a window found inside my dialog box. please help!! 
dila
|
|
|
|
|
How to implement List View Control in MFC 
Myhthili
|
|
|
|
|
Use CListView?
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"
|
|
|
|
|
Hi
How I copy a file from my local machine to a webserver. How can i create a new folder in the web server on a particular Virtual directory? Please share code to copy/write file in web directory using a URL as destination folder?
the target location to copy file is like "http://www.abc.com/DestFolder/" n Some cases i need to create new folder in the DestFolder also..
Please help
|
|
|
|
|
Within my WM_INITIDIALOG I initialize a class and open several files which causes a 3-5 second delay with opening my exe. There is nothing I can do about this. At the moment I display a splash screen while the files are being processed. I want to do away with the splash and display a progress bar on the main exe window instead.
The problem is, the main window does not get shown until after WM_INITDIALOG has been finished with. If I try forcing it to display using a ShowWindow() The window is shown but without any of the contols. I'm not really sure what I should do here? I guess initialing the file-parsing-class in another place would be the best solution, but where exactly should I do this?
|
|
|
|
|
Dear ,
u can do Your Heavy Processing in differnt thread...
Just Create Worker thread from OnInitDialog() , and put all code in a thread.
Regards
Jignesh
|
|
|
|
|
Sorry I didn't mention that I'm not using MFC. what do you mean by "worker thread"?
Thanks
|
|
|
|
|
I still don't really understand the meaning of "worker thread", if anybody would like to enlighten me I would be grateful.
I managed to solve my problem with a little help from my best buddy 'Google'. So for anybody with a similar problem here is what I did. (I hate it when people ask but don't update with their result. We wouldn't need to keep asking the same questions if people just posted the solution to their question)
In WM_INITDIALOG Post a message back to your dialog box in the form of a WM_USER i.e. Postmessage(dlghwnd,WM_USER+0x0100,0,0). Initdialog will proceed with loading the dialog and there will be a new message waiting on the que.
process the WM_USER+0x0100: and initialize your class, or do any of those lengthy operations you wanted to do within Initdialog.
Hope this helps somebody.
|
|
|
|
|
waldermort wrote: meaning of "worker thread"
Worker thread[^]
Nibu thomas
Software Developer
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
