Click here to Skip to main content
15,909,953 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
Questionsplitter thickness Pin
Alex_Y29-Nov-05 9:55
Alex_Y29-Nov-05 9:55 
AnswerRe: splitter thickness Pin
Shog929-Nov-05 11:30
sitebuilderShog929-Nov-05 11:30 
GeneralRe: splitter thickness Pin
Alex_Y29-Nov-05 15:02
Alex_Y29-Nov-05 15:02 
QuestionMultimedia Timers - recommendations Pin
ddmcr29-Nov-05 9:00
ddmcr29-Nov-05 9:00 
AnswerRe: Multimedia Timers - recommendations Pin
David Crow29-Nov-05 9:19
David Crow29-Nov-05 9:19 
GeneralRe: Multimedia Timers - recommendations Pin
ddmcr29-Nov-05 9:28
ddmcr29-Nov-05 9:28 
AnswerRe: Multimedia Timers - recommendations Pin
Alex_Y29-Nov-05 10:40
Alex_Y29-Nov-05 10:40 
QuestionADO Recordset Open method error Pin
flyflyfly29-Nov-05 8:14
flyflyfly29-Nov-05 8:14 
Hello

I seriously need help on this. Please take time listen to my problem.

We have a SQL 2000 database running for a year. the main table called 'datatable' has grown to 1.8GB. Now we want to change the old database name to a different name without losing all the data in it. We made full backup of the old database and create a new empty database and restore the old database to it.

After I done that the program that populates the "datatable" in the newly restored database always give me error (IDispatch error #3121: [Microsoft][ODBC SQL Server Driver]Timeout expired :Microsoft OLE DB Provider for ODBC Drivers)
when rs->Open("DataTable", _variant_t((IDispatch *)conn,true), adOpenKeyset, adLockOptimistic,adCmdTable); excuted.

I have tried to recreate table index. It still doesn't work.
The datatable has first column "ID" as integer AutoNumber.

If I truncate the table, the program works fine. If I delete most of the data
for example only keep last a few hundred rows, the program also works.
If I don't use rs->open and rs->addNew() method to insert data, instead of using a simple insert SQL query, it works fine.

I believe the problem is that when we do restore something got messed up, but
how? If the datatable is too big and need more time to process when we call rs->open, but why the old database doesn't have this problem. The same program are running on those two databases. Any ideas?

Please help me out.









QuestionGDI & Clipping Regions Pin
GDI_novice29-Nov-05 7:50
GDI_novice29-Nov-05 7:50 
QuestionCross-compiling in VC++ Pin
Raphael Amorim29-Nov-05 7:01
professionalRaphael Amorim29-Nov-05 7:01 
QuestionDialog from a dialog problem Pin
Jader8929-Nov-05 6:38
Jader8929-Nov-05 6:38 
AnswerRe: Dialog from a dialog problem Pin
toxcct29-Nov-05 6:46
toxcct29-Nov-05 6:46 
GeneralRe: Dialog from a dialog problem Pin
Maximilien29-Nov-05 7:09
Maximilien29-Nov-05 7:09 
GeneralRe: Dialog from a dialog problem Pin
Jader8929-Nov-05 7:27
Jader8929-Nov-05 7:27 
GeneralRe: Dialog from a dialog problem Pin
ddmcr29-Nov-05 9:02
ddmcr29-Nov-05 9:02 
GeneralRe: Dialog from a dialog problem Pin
Jader8929-Nov-05 9:06
Jader8929-Nov-05 9:06 
GeneralRe: Dialog from a dialog problem Pin
ddmcr29-Nov-05 9:32
ddmcr29-Nov-05 9:32 
GeneralRe: Dialog from a dialog problem Pin
Jader8929-Nov-05 9:38
Jader8929-Nov-05 9:38 
QuestionCombo Boxes Pin
TUMB29-Nov-05 6:33
TUMB29-Nov-05 6:33 
AnswerRe: Combo Boxes Pin
toxcct29-Nov-05 6:37
toxcct29-Nov-05 6:37 
AnswerRe: Combo Boxes Pin
normanS29-Nov-05 18:33
normanS29-Nov-05 18:33 
GeneralRe: Combo Boxes Pin
TUMB30-Nov-05 1:51
TUMB30-Nov-05 1:51 
QuestionProblem with CRichEditCtrl and formatrange Pin
AnTri29-Nov-05 6:20
AnTri29-Nov-05 6:20 
QuestionPopulate a random __int64 Pin
Cedric Moonen29-Nov-05 5:11
Cedric Moonen29-Nov-05 5:11 
AnswerRe: Populate a random __int64 Pin
Chris Losinger29-Nov-05 7:44
professionalChris Losinger29-Nov-05 7:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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