|
Hi,
I would like to connect do a DSN (data source name) through my code in C++, but I don't want to write the UserName and Password in my code: how can I do??
Here it is my code:
static bool IsSubscribed(SQLCHAR Account[], bool& subscription, bool& warning)
{
SQLHENV henv = NULL;
SQLHDBC hdbc = NULL;
SQLHSTMT hstmt = NULL;
SQLRETURN sRet;
PTSTR szDataSource = _T("DSN_NAME");
PTSTR szUID = _T("UserName");
PTSTR szPWD = _T("Password");
// Initialize the ODBC environment.
if (SQLAllocHandle(SQL_HANDLE_ENV, NULL, &henv) == SQL_ERROR)
{
WriteIntoFile("ERRORE Initialize the ODBC environment");
return false;
}
SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (void*) SQL_OV_ODBC3,SQL_IS_INTEGER);
// Allocate a connection handle and connect to the data source.
if (SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc) == SQL_ERROR)
{
WriteIntoFile("ERRORE Allocate a connection handle");
return false;
}
if (SQLConnect(hdbc, (SQLTCHAR*) szDataSource, SQL_NTS,
(SQLTCHAR*) szUID, SQL_NTS, (SQLTCHAR*) szPWD, SQL_NTS) == SQL_ERROR)
{
WriteIntoFile("ERRORE Connect to the DataSource");
return false;
}
// Get a statement handle and execute a Transact-SQL SELECT statement
if (SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt) == SQL_ERROR)
{
WriteIntoFile("ERRORE Get a statement handle and execute a Trans-SQL");
return false;
}
SQLINTEGER cbAccount = SQL_NTS;
// ? marks the input parameter.
sRet = SQLPrepare(hstmt, (SQLCHAR*) "{call spIsSubscribed(?)}", SQL_NTS);
// Bind the input parameter.
sRet = SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_CHAR,
SQL_CHAR, 20, 0, Account, 0, &cbAccount);
if( (SQLExecute(hstmt)) == SQL_ERROR)
{
WriteIntoFile("ERRORE Execute");
return false;
}
bool sub;
SQLINTEGER cbSub;
bool warn;
SQLINTEGER cbWarning;
// Retrieve data from row set.
SQLBindCol(hstmt, 1, SQL_C_BIT, (SQLPOINTER) &sub, 0, &cbSub);
SQLBindCol(hstmt, 2, SQL_C_BIT, (SQLPOINTER) &warn, 0, &cbWarning);
sRet = SQLFetch(hstmt);
if(sRet != SQL_SUCCESS && sRet != SQL_SUCCESS_WITH_INFO)
{
WriteIntoFile("ERRORE Fetch");
return false;
}
subscription = sub;
warning = warn;
/* Clean up.*/
SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
SQLDisconnect(hdbc);
SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
SQLFreeHandle(SQL_HANDLE_ENV, henv);
return true;
}
|
|
|
|
|
Hi..
I don't have much time to see your code but
One thing u can do is supply coneection string...
that's very easy...
Use class CDatabase
CRecordset
or drive class from CRecordset & supply all information at creation time...
I'm in hurry...
so see..u later..
bye..
---Sumit Kapoor--- sumit_kapoor1980@hotmail.com
|
|
|
|
|
Why not wrap all of that ODBC nastiness into a class? I have been using the same ODBC classes for about 8 years now, and never had a problem. If you want the classes, shoot me an email.
onwards and upwards...
|
|
|
|
|
Hello,
I have class defined somethig like this :
class CAaa
{
...
CString m_str;
void Set();
}
CAaa::Set()
{
CString tmp;
m_str = tmp;
}
It's more complicated class, but this is the most important part.
Destructor of CAaa will crash the application in CString destructer,
which shows ASSERT in debug mode that it can't free the memory, because it's not valid memory block.
I found out that this won't happend when i use
m_str = (LPCSTR)tmp;
insead of
m_str = tmp;
Why the second thing is not working ? I know that there's only reference increment in second case, and copying of all data in first case,
but why doesn't the reference counting work correctly ?
Is this bad practice to assign member CString value of local CString in function ?
Thanks
rrrado
|
|
|
|
|
How is the CAaa object being created, and Set() being called.
"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen
|
|
|
|
|
Thanks for reply !
I don't know whether this is important, but there's list oc Caa :
typedef CArray<CAaa,CAaa&> CAaaArray
class anotherClass
{
void SomeFunc();
CAaaArray m_array;
}
CAaa::SomeFunc()
{
CAaa *aaa;
for (int i=0; i<m_array->GetSize(); i++)
{
aaa = &m_array->GetAt(i);
....
aaa->Set();
}
}
Another weird thing is that for each item in this loop also destructor of CAaa is called, but it's probably because od GetAt returning temporary object created with default copy constructor, which is destroyed at the end of the loop ... I'll have to figure out whether creating of temporary CAaa object isn't problem ....
rrrado
|
|
|
|
|
Sorry
typedef CArray<CAaa,CAaa&> CAaaArray;
rrrado
|
|
|
|
|
I assume you typed these code snippets in rather than copying/pasting them directory from your project. I had to make some changes just to get them to compile.  Here is what I have that produces no errors:
class CAaa
{
CString m_str;
public:
CAaa();
~CAaa();
void Set();
};
void CAaa::Set()
{
CString tmp;
m_str = tmp;
}
typedef CArray<CAaa *, CAaa *> CAaaArray;
class anotherClass
{
CAaaArray m_array;
public:
anotherClass();
~anotherClass()
{
CAaa *aaa;
for (int i = 0; i < m_array.GetSize(); i++)
{
aaa = m_array.GetAt(i);
delete aaa;
}
}
void SomeFunc();
void add();
};
void anotherClass::add()
{
CAaa *aaa = new CAaa;
m_array.Add(aaa);
}
void anotherClass::SomeFunc()
{
CAaa *aaa;
for (int i = 0; i < m_array.GetSize(); i++)
{
aaa = m_array.GetAt(i);
aaa->Set();
}
}
...
anotherClass ac;
ac.add();
ac.SomeFunc();How does it compare to what you have?
"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen
|
|
|
|
|
Yes it would be too big to paste here original classes.
You've used array of pointers, I used array of objects.
So there is different constructing/destructing objkects in array,
it's maybe the biggest difference.
I've posted original array typedef in previous message
rrrado
|
|
|
|
|
ok I've created new project where this also happend
http://rrrado.szm.sk/aaa.zip
just compile and click twice at the button1
Thank you !
rrrado
|
|
|
|
|
This works
for (i=0; i<20; i++)
{
(m_array.GetAt(0)).Set();
}
Papa
while (TRUE)
Papa.WillLove ( Bebe ) ;
|
|
|
|
|
Did you mean (m_array.GetAt(i)).Set();?
/ravi
My new year's resolution: 2048 x 1536
Home | Articles | Freeware | Music
ravib@ravib.com
|
|
|
|
|
No Check the code
Papa
while (TRUE)
Papa.WillLove ( Bebe ) ;
|
|
|
|
|
Technically, yes, but 0 was used in the example so it just propagated to the reply. In any case, whether 0 or i was used was not the cause of the problem.
"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen
|
|
|
|
|
It depends on the application, maybe he just wanted to call Set on the first object 20 time.
That's why i suggested that he checks the code.
Papa
while (TRUE)
Papa.WillLove ( Bebe ) ;
|
|
|
|
|
Since you are adding a CEmail reference to the CEmailArray, you need to do the same thing (i.e., you can't use a pointer, unless new was called first) when accessing the array. So just change the call to GetAt() to:
CEmail eml;
...
eml = m_array.GetAt(0);
"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen
|
|
|
|
|
Thank you all, guys !
GetAt(0) was typo, it had to be (i) but it's not important.
I'm curious, why my solution did not work. Maybe temporary object
returned from GetAt was destroyed before I called Set().
But anyway, I found GetAt() unusable, since I need to change objects in array,
not some temporary object returned by GetAt().
I don't understand why GetAt is designed to return copy of the object instead of reference/pointer to object in the array,
I had to use this :
for (i=0; i<20; i++)
{
m_array[i].Set();
}
AfxMessageBox(m_array.GetAt(0).m_data);
The dialog in GetAt case shows "aaa", in operator[] case returns correct result "hello"
But operator[] is also defined like returning reference, or constant, returning copy, I don't have a clue which type the compiler will choose,
I'm happy that correct type was choosen in my code.
Thanks !
rrrado
|
|
|
|
|
Hi
I have created a class (class A) that manages a number of image. The images' pixel values are stored as unsigned char *. These images are destroyed using delete[] in A's destructor. Another class, class B, in turn manages a number of A objects, and each A object is assigned a unique ID. At first I was planning to declare something like:
std::map<unsigned int, A> m_mA;
in B. My concern is, when I insert a new element to m_mA using:
std::pair<unsigned int, A> pTmp(A_UNIQUE_ID, AN_A_OBJECT);
m_mA.insert(pTmp);
a copy of AN_A_OBJECT will be created and destroyed, invalidating AN_A_OBJECT's pointer to the pixel values. Is this correct?
If it's correct, one possible solution may be defining a copy constructor and assigment operator for A that take care of this issue, although I'm not sure whether this is the most elegant solution. Another possible solution, although I find it very_very strange, is to use 2D vector instead of unsigned char* to store the pixel values. Could someone tell me how I can overcome this? Hopefully the solution does not require me to use classical arrays....
Thanks!
|
|
|
|
|
Yes, a temporary A object will be created (pTmp), and the m_mA.insert will make a copy of this - you will have two objects constructed, with pTmp being destructed once it goes out of scope. Depending how you obtain the pixel data in class A (you didnt provide details of this), then the destruction of pTmp may, or may not, invalidate the A that was inserted into m_mA.
You could define a copy constructor, but it will be tricky to ensure that the memory is deallocated at the appropriate time. A better solution would be to use something like Boost shared_ptr[^], and dynamically allocate the A objects and get the SmartPtr to handle deallocation.
<br />
typedef boost::shared_ptr<A> APtr;<br />
typedef std::map<int,APtr> MyMap;<br />
<br />
m_mA[id] = APtr (new A);<br />
This way there is no copying of objects, only of pointers. Not only will it be more efficient, but the SmartPtr will ensure that the class is destroyed once it is no longer used.
|
|
|
|
|
Hi
Thanks for the reply. The pixel data are allocated by class A with the new[] operator upon A's instantiation, and deallocated (using delete[]) in A's destructor. In this case, I think pTmp's destruction will invalidate A's pixel data, won't it? And will converting the pixel data to 2d vector get rid of this problem?
Thanks!
|
|
|
|
|
We can Enable/Disable the hibernation support by follow procedure :
1. Open Control Panel.
2. Select Power Options.
3. Click Hibernation.
4. Check/Uncheck Enable Hibernation.
How to implement this function in VC++ ?
Jesa
|
|
|
|
|
Hi guys
How can I change my cursor whem I'm over a precise region of a CStatic control?
I've tried Setcursor(...) inside OnMouseMove but without succes (debugging the code enters but the cursor doesn't change).
What exactly I have to use? (any example?)
Best Regards
Doc
|
|
|
|
|
You'll want to do it in OnMouseMove with SetCursor, as you have already tested, but you'll also have to do a SetCursor in OnSetCursor (a handler for the WM_SETCURSOR-message).
|
|
|
|
|
- hi all, I want to find all folders which are shared fully in my drive and list them on. But i don't know how.
hope you help me 
thanks
|
|
|
|
|
I also want to know this.
I want to find all the shared folders on the computer in same LAN.
Please help me regarding this.
Thanks and Regards,
Shri
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
