Click here to Skip to main content
   

Database

 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberBrady Kelly14-Dec-12 22:25 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberPIEBALDconsult15-Dec-12 9:49 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberBrady Kelly15-Dec-12 19:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberPIEBALDconsult18-Dec-12 11:47 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberBrady Kelly18-Dec-12 12:01 
Questionsending images from a SQL database to a user's email as attachment PinmemberMember 946798213-Dec-12 3:16 
QuestionRe: sending images from a SQL database to a user's email as attachment PinmemberEddy Vluggen13-Dec-12 3:29 
QuestionODBC Returns Wrong Data PinmemberGenJerDan12-Dec-12 6:23 
I've got a query going out to a Cache database via ODBC.
 
It almost always works (90% or so).
 
The other 10% of the time, it returns the wrong data for one of the columns (a LONGVARCHAR column)
 
By wrong, I mean the data is from another row.
 
At first, I though maybe there was too much text in the column and it was trashing a buffer or something, so I cahange my parameter from a VarChar to Text, but it made no difference. I just retried it again now without specifying the datatype at all, and it made no difference.
 
Further investigation showed that the correct data was only 1600 characters, so that isn't going to be the problem, anyway.
 
I've even cleared the parameters for each loop of the read and it still does it.
 
I just now tried to do a select specifically on one of the bad rows and it was still bad, so ti has to be something going on with ODBC or the remote server. Right?
 
Anyone ever see anything like this before?
No dogs or cats are in the classroom.
 
My Mu[sic], Films and Windows Programs, etc.

AnswerRe: ODBC Returns Wrong Data PinmemberChris Meech12-Dec-12 6:50 
GeneralRe: ODBC Returns Wrong Data PinmemberGenJerDan12-Dec-12 7:20 
GeneralRe: ODBC Returns Wrong Data PinmemberChris Meech12-Dec-12 7:28 
AnswerRe: ODBC Returns Wrong Data PinmemberPIEBALDconsult12-Dec-12 7:28 
GeneralRe: ODBC Returns Wrong Data PinmemberGenJerDan12-Dec-12 8:18 
GeneralRe: ODBC Returns Wrong Data PinmemberPIEBALDconsult12-Dec-12 9:51 
GeneralRe: ODBC Returns Wrong Data PinmemberGenJerDan12-Dec-12 9:54 
AnswerRe: ODBC Returns Wrong Data Pinmemberjschell12-Dec-12 10:05 
GeneralRe: ODBC Returns Wrong Data PinmemberGenJerDan12-Dec-12 10:14 
GeneralRe: ODBC Returns Wrong Data Pinmemberjschell14-Dec-12 13:38 
GeneralRe: ODBC Returns Wrong Data PinmemberGenJerDan14-Dec-12 14:24 
AnswerRe: ODBC Returns Wrong Data PinmemberMycroft Holmes12-Dec-12 13:01 
GeneralRe: ODBC Returns Wrong Data PinmemberGenJerDan13-Dec-12 4:05 
QuestionRe: ODBC Returns Wrong Data PinmemberEddy Vluggen13-Dec-12 5:24 
QuestionUsing .Net and SMO on multiple SQL versions PinmemberEricCiz12-Dec-12 0:45 
AnswerRe: Using .Net and SMO on multiple SQL versions PinmemberEddy Vluggen12-Dec-12 4:10 
QuestionSelecting issue in SQl Server Pinmemberrakeshs31212-Dec-12 0:06 

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

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


Advertise | Privacy | Mobile
Web02 | 2.8.150123.1 | Last Updated 26 Jan 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid