Click here to Skip to main content
11,706,799 members (53,502 online)
   

Database

 
AnswerRe: On Strategies to Spell Check the Structure of a Database. Pin
Simon_Whale14-Dec-12 4:52
memberSimon_Whale14-Dec-12 4:52 
AnswerRe: On Strategies to Spell Check the Structure of a Database. Pin
Mycroft Holmes14-Dec-12 13:12
memberMycroft Holmes14-Dec-12 13:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 16:36
memberBrady Kelly14-Dec-12 16:36 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Mycroft Holmes14-Dec-12 16:57
memberMycroft Holmes14-Dec-12 16:57 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 17:12
memberBrady Kelly14-Dec-12 17:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Mycroft Holmes14-Dec-12 21:13
memberMycroft Holmes14-Dec-12 21:13 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 21:25
memberBrady Kelly14-Dec-12 21:25 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
PIEBALDconsult15-Dec-12 8:49
memberPIEBALDconsult15-Dec-12 8:49 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly15-Dec-12 18:12
memberBrady Kelly15-Dec-12 18:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
PIEBALDconsult18-Dec-12 10:47
memberPIEBALDconsult18-Dec-12 10:47 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly18-Dec-12 11:01
memberBrady Kelly18-Dec-12 11:01 
Questionsending images from a SQL database to a user's email as attachment Pin
Member 946798213-Dec-12 2:16
memberMember 946798213-Dec-12 2:16 
QuestionRe: sending images from a SQL database to a user's email as attachment Pin
Eddy Vluggen13-Dec-12 2:29
memberEddy Vluggen13-Dec-12 2:29 
QuestionODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 5:23
memberGenJerDan12-Dec-12 5: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 Pin
Chris Meech12-Dec-12 5:50
memberChris Meech12-Dec-12 5:50 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 6:20
memberGenJerDan12-Dec-12 6:20 
GeneralRe: ODBC Returns Wrong Data Pin
Chris Meech12-Dec-12 6:28
memberChris Meech12-Dec-12 6:28 
AnswerRe: ODBC Returns Wrong Data Pin
PIEBALDconsult12-Dec-12 6:28
memberPIEBALDconsult12-Dec-12 6:28 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 7:18
memberGenJerDan12-Dec-12 7:18 
GeneralRe: ODBC Returns Wrong Data Pin
PIEBALDconsult12-Dec-12 8:51
memberPIEBALDconsult12-Dec-12 8:51 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 8:54
memberGenJerDan12-Dec-12 8:54 
AnswerRe: ODBC Returns Wrong Data Pin
jschell12-Dec-12 9:05
memberjschell12-Dec-12 9:05 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 9:14
memberGenJerDan12-Dec-12 9:14 
GeneralRe: ODBC Returns Wrong Data Pin
jschell14-Dec-12 12:38
memberjschell14-Dec-12 12:38 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan14-Dec-12 13:24
memberGenJerDan14-Dec-12 13:24 
AnswerRe: ODBC Returns Wrong Data Pin
Mycroft Holmes12-Dec-12 12:01
memberMycroft Holmes12-Dec-12 12:01 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan13-Dec-12 3:05
memberGenJerDan13-Dec-12 3:05 
QuestionRe: ODBC Returns Wrong Data Pin
Eddy Vluggen13-Dec-12 4:24
memberEddy Vluggen13-Dec-12 4:24 
QuestionUsing .Net and SMO on multiple SQL versions Pin
EricCiz11-Dec-12 23:45
memberEricCiz11-Dec-12 23:45 
AnswerRe: Using .Net and SMO on multiple SQL versions Pin
Eddy Vluggen12-Dec-12 3:10
memberEddy Vluggen12-Dec-12 3:10 
QuestionSelecting issue in SQl Server Pin
rakeshs31211-Dec-12 23:06
memberrakeshs31211-Dec-12 23:06 
AnswerRe: Selecting issue in SQl Server Pin
Eddy Vluggen12-Dec-12 3:07
memberEddy Vluggen12-Dec-12 3:07 
QuestionGenerating Code in Dept-001/Fin.Year Format Pin
Vinay Meka11-Dec-12 22:41
memberVinay Meka11-Dec-12 22:41 
QuestionRe: Generating Code in Dept-001/Fin.Year Format Pin
Eddy Vluggen12-Dec-12 3:06
memberEddy Vluggen12-Dec-12 3:06 
AnswerRe: Generating Code in Dept-001/Fin.Year Format Pin
Mycroft Holmes12-Dec-12 11:53
memberMycroft Holmes12-Dec-12 11:53 
QuestionHow to print an SSRS Report in PDF Format from my asp.net page Pin
Vinay Meka11-Dec-12 17:55
memberVinay Meka11-Dec-12 17:55 
AnswerRe: How to print an SSRS Report in PDF Format from my asp.net page - Crosspost Pin
Richard MacCutchan11-Dec-12 21:30
mvpRichard MacCutchan11-Dec-12 21:30 
Questionreading individual files in a database backup set Pin
Dan_K10-Dec-12 22:44
memberDan_K10-Dec-12 22:44 
AnswerRe: reading individual files in a database backup set Pin
djj5511-Dec-12 3:58
memberdjj5511-Dec-12 3:58 
QuestionJava Struts2 Framework Pin
Maheshwari Anand10-Dec-12 2:46
memberMaheshwari Anand10-Dec-12 2:46 
AnswerRe: Java Struts2 Framework Pin
Mycroft Holmes10-Dec-12 18:39
memberMycroft Holmes10-Dec-12 18:39 
AnswerRe: Java Struts2 Framework Pin
Richard MacCutchan10-Dec-12 21:39
mvpRichard MacCutchan10-Dec-12 21:39 
QuestionSQL Query To select result for monthly Pin
VishwaKL9-Dec-12 22:43
memberVishwaKL9-Dec-12 22:43 
AnswerRe: SQL Query To select result for monthly Pin
Eddy Vluggen9-Dec-12 23:12
memberEddy Vluggen9-Dec-12 23:12 
GeneralRe: SQL Query To select result for monthly Pin
VishwaKL9-Dec-12 23:15
memberVishwaKL9-Dec-12 23:15 
GeneralRe: SQL Query To select result for monthly Pin
Eddy Vluggen9-Dec-12 23:18
memberEddy Vluggen9-Dec-12 23:18 
GeneralRe: SQL Query To select result for monthly Pin
VishwaKL9-Dec-12 23:20
memberVishwaKL9-Dec-12 23:20 
GeneralRe: SQL Query To select result for monthly Pin
Eddy Vluggen9-Dec-12 23:24
memberEddy Vluggen9-Dec-12 23:24 
GeneralRe: SQL Query To select result for monthly Pin
VishwaKL9-Dec-12 23:27
memberVishwaKL9-Dec-12 23:27 
AnswerRe: SQL Query To select result for monthly Pin
David Mujica10-Dec-12 3:16
memberDavid Mujica10-Dec-12 3:16 

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
Web04 | 2.8.150819.1 | Last Updated 26 Aug 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid