Re: D3 ODBC Problem



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


.



Relevant Pages

  • Re: D3 ODBC Problem
    ... Error messages from WinSQL are usually fairly accurate. ... data, it's probably invalid. ... Poster said they scanned the data and there's no non-numeric data and that ...
    (comp.databases.pick)
  • Re: D3 ODBC Problem
    ... "Tony Gravagno" wrote in ... Error messages from WinSQL are usually fairly accurate. ... If it says invalid data, ...
    (comp.databases.pick)
  • Re: IE and Outlook Express Crashing After Update KB834707
    ... I copied 5 error messages below. ... > MSIMN caused an invalid page fault in ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Boot.Ini and recovery Console
    ... Invalid Boot.INI then it goes on the open windows without a problem. ... I have tried several times to get to and install the recovery console but it ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Invalid BOOT.INI File
    ... "Invalid Boot.ini" or "Windows could not start" error messages ... Windows XP - Shell/User ... "Mick Diddams" wrote: ...
    (microsoft.public.windowsxp.general)