Click here to Skip to main content
15,921,941 members
Home / Discussions / Database
   

Database

 
GeneralRe: Recordset Open method error IDispatch error #3121 Pin
flyflyfly1-Dec-05 6:24
flyflyfly1-Dec-05 6:24 
GeneralRe: Recordset Open method error IDispatch error #3121 Pin
Farhan Noor Qureshi1-Dec-05 7:17
Farhan Noor Qureshi1-Dec-05 7:17 
AnswerRe: Recordset Open method error IDispatch error #3121 Pin
S Douglas30-Nov-05 22:38
professionalS Douglas30-Nov-05 22:38 
GeneralRe: Recordset Open method error IDispatch error #3121 Pin
flyflyfly1-Dec-05 6:19
flyflyfly1-Dec-05 6:19 
GeneralRe: Recordset Open method error IDispatch error #3121 Pin
Farhan Noor Qureshi1-Dec-05 7:20
Farhan Noor Qureshi1-Dec-05 7:20 
GeneralRe: Recordset Open method error IDispatch error #3121 Pin
flyflyfly1-Dec-05 7:49
flyflyfly1-Dec-05 7:49 
GeneralRe: Recordset Open method error IDispatch error #3121 Pin
Farhan Noor Qureshi1-Dec-05 8:55
Farhan Noor Qureshi1-Dec-05 8:55 
QuestionFailed to compare Time portion of DateTime when read ACCESS database Pin
Roman Muntyanu29-Nov-05 8:35
Roman Muntyanu29-Nov-05 8:35 
Hi all,

I have datetime field in database. When I am getting records older than
specific date that I passed in parameter I can not get records that
differs only in Time part of the datetime value.
Looks like comparison of Time portion in query failed.

I am using ACCESS database and ADO OleDbCommand. When in debug in Visual Studio QuickWatch clearly can see that the record that am going to get is older than datetime in TimestampParam by 10 sec (for example). If I substract 1 day from the
database field value I am getting the record. It is definetly time
portion comparison failed.

These are some lines from my code to show how I am reading database
OleDbDataAdapter adapter = new OleDbDataAdapter();
myCommand.CommantText = "SELECT [NetLog].* FROM [NetLog] WHERE
Timestamp < TimestampParam"
adapter.SelectCommand = myCommand;
System.Data.DataSet dataSet = new System.Data.DataSet();
int iNumRows = adapter.Fill( dataSet );

I would appreciate any advice

Thanks,
Roman
QuestionMSDE and SQL SErver Express 2005 Pin
inphone29-Nov-05 4:52
inphone29-Nov-05 4:52 
AnswerRe: MSDE and SQL SErver Express 2005 Pin
Paul Conrad29-Nov-05 5:07
professionalPaul Conrad29-Nov-05 5:07 
QuestionInserting a record into a database with a front web form Pin
bhumber29-Nov-05 1:45
bhumber29-Nov-05 1:45 
AnswerRe: Inserting a record into a database with a front web form Pin
dwatkins@dirq.net29-Nov-05 11:06
dwatkins@dirq.net29-Nov-05 11:06 
QuestionWorking with only Time in Sql? Pin
majidbhutta29-Nov-05 1:00
majidbhutta29-Nov-05 1:00 
AnswerRe: Working with only Time in Sql? Pin
Farhan Noor Qureshi29-Nov-05 12:01
Farhan Noor Qureshi29-Nov-05 12:01 
QuestionSELECT @@IDENTITY doesn't work Pin
AndySummer28-Nov-05 22:27
AndySummer28-Nov-05 22:27 
AnswerRe: SELECT @@IDENTITY doesn't work Pin
Frank Kerrigan28-Nov-05 22:42
Frank Kerrigan28-Nov-05 22:42 
QuestionIs this Possible in sql? Pin
majidbhutta28-Nov-05 5:50
majidbhutta28-Nov-05 5:50 
AnswerRe: Is this Possible in sql? Pin
Farhan Noor Qureshi28-Nov-05 10:53
Farhan Noor Qureshi28-Nov-05 10:53 
QuestionWhich one is faster and recommended Pin
dabuskol28-Nov-05 1:12
dabuskol28-Nov-05 1:12 
AnswerRe: Which one is faster and recommended Pin
Farhan Noor Qureshi28-Nov-05 11:02
Farhan Noor Qureshi28-Nov-05 11:02 
QuestionAccess database - for website Pin
Rama Sharma28-Nov-05 1:11
Rama Sharma28-Nov-05 1:11 
AnswerRe: Access database - for website Pin
Farhan Noor Qureshi28-Nov-05 10:56
Farhan Noor Qureshi28-Nov-05 10:56 
GeneralRe: Access database - for website Pin
Paul Conrad28-Nov-05 11:37
professionalPaul Conrad28-Nov-05 11:37 
GeneralRe: Access database - for website Pin
Rama Sharma28-Nov-05 16:33
Rama Sharma28-Nov-05 16:33 
GeneralRe: Access database - for website Pin
Paul Conrad28-Nov-05 19:16
professionalPaul Conrad28-Nov-05 19:16 

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.