Click here to Skip to main content
12,757,627 members (37,202 online)
   

Database

 
AnswerRe: ODBC Returns Wrong Data Pin
Chris Meech12-Dec-12 6:50
memberChris Meech12-Dec-12 6:50 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 7:20
memberGenJerDan12-Dec-12 7:20 
GeneralRe: ODBC Returns Wrong Data Pin
Chris Meech12-Dec-12 7:28
memberChris Meech12-Dec-12 7:28 
AnswerRe: ODBC Returns Wrong Data Pin
PIEBALDconsult12-Dec-12 7:28
memberPIEBALDconsult12-Dec-12 7:28 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 8:18
memberGenJerDan12-Dec-12 8:18 
GeneralRe: ODBC Returns Wrong Data Pin
PIEBALDconsult12-Dec-12 9:51
memberPIEBALDconsult12-Dec-12 9:51 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 9:54
memberGenJerDan12-Dec-12 9:54 
AnswerRe: ODBC Returns Wrong Data Pin
jschell12-Dec-12 10:05
memberjschell12-Dec-12 10:05 
GenJerDan wrote:
The other 10% of the time, it returns the wrong data for one of the columns (a
LONGVARCHAR column)


Try two queries.

One that gets everything but the blob. The second that gets only the blob.

And given the connection problems presumably this is already a data migration process rather than a processing process. If so a second query for the blob could be used to verify.
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 10:14
memberGenJerDan12-Dec-12 10:14 
GeneralRe: ODBC Returns Wrong Data Pin
jschell14-Dec-12 13:38
memberjschell14-Dec-12 13:38 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan14-Dec-12 14:24
memberGenJerDan14-Dec-12 14:24 
AnswerRe: ODBC Returns Wrong Data Pin
Mycroft Holmes12-Dec-12 13:01
memberMycroft Holmes12-Dec-12 13:01 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan13-Dec-12 4:05
memberGenJerDan13-Dec-12 4:05 
QuestionRe: ODBC Returns Wrong Data Pin
Eddy Vluggen13-Dec-12 5:24
memberEddy Vluggen13-Dec-12 5:24 
QuestionUsing .Net and SMO on multiple SQL versions Pin
EricCiz12-Dec-12 0:45
memberEricCiz12-Dec-12 0:45 
AnswerRe: Using .Net and SMO on multiple SQL versions Pin
Eddy Vluggen12-Dec-12 4:10
memberEddy Vluggen12-Dec-12 4:10 
QuestionSelecting issue in SQl Server Pin
rakeshs31212-Dec-12 0:06
memberrakeshs31212-Dec-12 0:06 
AnswerRe: Selecting issue in SQl Server Pin
Eddy Vluggen12-Dec-12 4:07
memberEddy Vluggen12-Dec-12 4:07 
QuestionGenerating Code in Dept-001/Fin.Year Format Pin
Vinay Meka11-Dec-12 23:41
memberVinay Meka11-Dec-12 23:41 
QuestionRe: Generating Code in Dept-001/Fin.Year Format Pin
Eddy Vluggen12-Dec-12 4:06
memberEddy Vluggen12-Dec-12 4:06 
AnswerRe: Generating Code in Dept-001/Fin.Year Format Pin
Mycroft Holmes12-Dec-12 12:53
memberMycroft Holmes12-Dec-12 12:53 
QuestionHow to print an SSRS Report in PDF Format from my asp.net page Pin
Vinay Meka11-Dec-12 18:55
memberVinay Meka11-Dec-12 18:55 
AnswerRe: How to print an SSRS Report in PDF Format from my asp.net page - Crosspost Pin
Richard MacCutchan11-Dec-12 22:30
mvpRichard MacCutchan11-Dec-12 22:30 
Questionreading individual files in a database backup set Pin
Dan_K10-Dec-12 23:44
memberDan_K10-Dec-12 23:44 
AnswerRe: reading individual files in a database backup set Pin
djj5511-Dec-12 4:58
memberdjj5511-Dec-12 4:58 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.170217.1 | Last Updated 24 Feb 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid