Re: D3 ODBC Problem
- From: "GlenB" <batchelg.removeit@xxxxxxxxxxxxx>
- Date: Sat, 26 Jul 2008 12:07:29 -0400
Which version of D3 and which O/S? I use D3 ODBC from D3/Linux 7.4.2 and
only have occasional data-oriented hiccups. For the most part it works fine
for me.
Glen
"SteveS" <srs@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:bd831f3c-ad0e-4a77-92f4-299b18a42707@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Jul 25, 5:07 pm, "Mark Brown" <Mark_Br...@xxxxxxxxxxxxx> wrote:
"Tony Gravagno" <address.is.in.po...@xxxxxxxxxxxxxxxxxxxxxx> wrote in
messagenews:fcck84hesns7f8ge13rfarmof6h098ep68@xxxxxxxxxx
Two comments.
And I did write a program to comb the data and the data is clean.
removepleaseNebula-RnD.com/freeware/FIND.BAD.CHAR.TXT
D3 ODBC sucks
If I had said that, all hell would break loose. Suffice to say, you
know the solution I would propose.
T
Error messages from WinSQL are usually fairly accurate. If it says invalid
data, it's probably invalid.
Poster said they scanned the data and there's no non-numeric data and that
the field is normalized correctly in the SQL-CREATE-TABLE.
Next question is, what IS the data, exactly? Just because it's numeric,
doesn't mean it's valid. If it's > 32K, then depending on which version of
Windows O/S and which version of the SQL query, it may think an integer is
16bits and the data is invalid because of overflow.
--
Mark Brown
Sr. Software Engineer
Cancer Survivor
Drexel Management Svc Inc.
Created a support call with TL. They could not find a problem with the
data either. They now have my data and are trying to reproduce at
their facility.
Will let u know the outcome.
Steve
.
- References:
- D3 ODBC Problem
- From: SteveS
- Re: D3 ODBC Problem
- From: Frank Winans
- Re: D3 ODBC Problem
- From: SteveS
- Re: D3 ODBC Problem
- From: Tony Gravagno
- Re: D3 ODBC Problem
- From: Mark Brown
- Re: D3 ODBC Problem
- From: SteveS
- D3 ODBC Problem
- Prev by Date: Re: D3 ODBC Problem
- Next by Date: Re: D3 ODBC Problem
- Previous by thread: Re: D3 ODBC Problem
- Next by thread: Re: D3 ODBC Problem
- Index(es):
Relevant Pages
|