Originally posted by: avar
How to Display Multiple View, Like (in VB Form1,Form2..)
ie) How to Display Multiple Tables in Different Window,
How to Convert CDialog to CFormView
ReplyOriginally posted by: Chris Wills
NTDLL! 77f7f570()
NTDLL! 77fac6ec()
NTDLL! 77f8cf62()
NTDLL! 77f5e449()
MSVCRT! 77c2ab2e()
operator delete(void * 0x025d2ac0) line 349 + 10 bytes
CString::Release(CString * const 0x77f5b6dd {""}) line 157
CString::operator=(CString * const 0x77f5b6dd {""}, const CString & {"Microsoft.JET.OLEDB.4.0"}) line 335
CSypODLConnection::SetProvider(CString {"Microsoft.JET.OLEDB.4.0"}) line 69 + 72 bytes
Can anyone clue me into what this could possible be?
Thanks...
- Chris
I am going through another dll so that might be the cause of some of my pain. Anyway, when SetProvider is called, the whole thing comes to a halt. My stack looks like this...
CString::FreeData(CStringData * 0x77f5b6dd) line 143 + 5 bytes
InitApplication() line 90
Originally posted by: Henry
I can see that u have make OLEDB as easy as ADO. I have an unexpected result:
If I move a table recordset by MoveFirst
then MovePrev
I get hr returned as S_OK but the data in the accessor is still the same as the first record from MoveFirst
Hence, the BOF is not set to true.
If I do MovePrev again, I get the second last record, just like I have move pass the first record.
I found that is the intrinsic problem of OLEDB, does anybody know the reason and :
How can I know that I have backup pass the first record in OLEDB rowsets??
ReplyOriginally posted by: Erhan Kaluc
_variant_t vtEmpty;
_bstr_t tmp, tmp1;
//This part creates a run time COM error and make me crazy
//This similar part works nice
I really need to take field names depending to field count.
Many Thanks
my explanation is not good enough so here comes part of my code:
myRecordSet.CreateInstance ( __uuidof( Recordset) );
myRecordSet = myConnection->Execute( bstrQuery,
&vtEmpty, adCmdUnknown);
tmp = myRecordSet->GetFields()->GetItem[0].Value;
tmp1 = myRecordSet->GetFields()->GetItem[0].Name;
tmp = myRecordSet->GetFields()->GetItem["Field1"].Value;
tmp1 = myRecordSet->GetFields()->GetItem["Field1"].Name;
//********************************************************
I'll be very pleased if anyone can tell me why I can't use numeric index values with "GetItem" function.
Originally posted by: Ludovic Balsan
Your library is very developper-friendly,
and I could get and set data into Access, MS SQL Server and MySQL databases.
I could handle blob columns on Access, but I couldn't
do it neither with SQL Server nor with MySQL.
With MySQL the Recordset couldn't be opened.
With SQL Server I only succeeded in writting data in a TEXT column with a CSypODLChunk, but I never could read that column after.
Could you tell me how to get and set blob data on MySQL and/or SQLServer please...
Thank you
Ludovic Balsan
Reply
Originally posted by: Alex
No comments:-)Very raw , without source library.
ReplyOriginally posted by: Seppo Laukkanen
I followed the step-by-step instrctions for my single-document MFC program in test purpose, but I can't open database - it claims: Debug Error! Abnormal program termination.
The line that causest this is:
m_Conn.Open("TESTDB", "Admin", "");
What could be wrong? Can anyone help?
-Seppo
ReplyOriginally posted by: Dan
Both these procedures were giving me blank variables entered into the stored procedure for SQL Server when I was doing a SQL Server Trace. I noticed after long hours of testing that if the variables I entered matched the size of the variables in my stored procedure then some sort of variable overrun must have been enacted and it was sending a blank variable instead of the one I entered. I even was sending hard coded literals (ex. "hello") and this was happening.
If I increased the size of my variables in my stored procedure by three characters I no longer had this problem. Note all my variables for the stored proc I was using were defined as char() -all of varying sizes.
Also the OUTPUT parameters are never found when you call them by name or by the name the sql trace says they are when this product is sending them in. I had to use its index value instead of its name or it would not work.
Just thought I would send this out in case other people have problems they don't have to spend days of trial and error to find out what the heck is going on.
Dan
ReplyOriginally posted by: Andreas
Can anybody give me an example how to search in my database in any border, and how I get the result of the complete column? I only search for strings. I have the prob because I don't understand how it works the sample AddrBook only shows how to find with numbers I don't understand it? Can anybody help me?
Andreas
ReplyOriginally posted by: Mike Bujak
I am using WindowsNT, Visual c++ 6.0. I cannot seem to connect to a database, I get an Assertion error. Here is the code I try:
try
{
m_conn.SetProvider("Microsoft.OLEDB.Jet.4.0");
m_conn.Open("C:\\TempDb\\test.mdb", "Admin", "");
}
catch(CSypODLException& e)
{
e.DisplayError();
}
The I get an assertion error: (from the assertion message box).
Expression: _CtrlsValidHeapPointer(pUserData)
If I hit debug (by pressing "Retry")it brings me to the following line in the c:\..\VC98\SRC\DBGHEAP.C:
/*
* If this ASSERT fails, a bad pointer has been passed in. It may be totally bogus, or it may have been allocated from another heap.
* The pointer MUST come from the 'local' heap.
*/
-----> _ASSERTE(_CrtIsValidHeapPointer(pUserData));
What do I have to do to fix this?
Mike Bujak