Re: vb6/ADO 2.8/ DB2

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

OldVaxGuy wrote:
I need to clarify: the actual data returned is 98,99,100,101 but in

Forgive me, but this statement is still ambiguous. Do you mean "the actual
data that should be returned is ... "? Or do you mean that this is the data
you see in your recordset while debugging, indicating that this is a problem
with the way you are writing it to the textbox/whatever? Looking at the rest
of this paragraph, it is safe to assume the former interpretation, but
wonder why it is so hard to say "My database table in DB2 contains these
numbers in a numeric field: 98,99,100,101. When I retrieve them via a simple
sql statement, the recordset field contains 98,99,1,101 (confirmed via
debug.print during a loop). Why are those trailing zeroes in the 100 being
dropped?"

The answer probably lies in some obscure setting in whatever ODBC driver or
OLE DB provider you are using to connect to the database. Again, I have no
experience with DB2 (other than AS400 servers with which I have never
encountered this issue) so will be unable to provide specifics. Hopefully,
one of the other guys here will. If you get no help here, try one of the vb
groups (avoid the .Net groups: those groups all have the word "dotnet"
somewhere in their names), or look for a DB2 forum somewhere, I'm sure they
exist. In fact, IBM has a knowledge base containing lots of white papers and
redbooks about using the AS400 on their website. I'm sure similar must exist
for DB2.


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • [Full-disclosure] Details for BID 18428
    ... DB2 Universal Database is a popular database software package ... DB2 UDB server. ... handshake process with the server, causing the server process to crash. ... The first message used by a client when establishing a connection to the ...
    (Full-Disclosure)
  • [Full-disclosure] Team SHATTER Security Advisory: Multiple DoS in JAR files manipulation procedu
    ... Team SHATTER Security Advisory ... All versions of IBM DB2 Database Server on Windows platform. ... DB2 has multiple vulnerabilities which can lead to Denial of Service ... Vendor was contacted and a patch was released. ...
    (Full-Disclosure)
  • Team SHATTER Security Advisory: Multiple DoS in JAR files manipulation procedures
    ... Team SHATTER Security Advisory ... All versions of IBM DB2 Database Server on Windows platform. ... DB2 has multiple vulnerabilities which can lead to Denial of Service ... Vendor was contacted and a patch was released. ...
    (Bugtraq)
  • Re: Connection problem with Access
    ... CurrentDb.Name produced the path to db2). ... As far as permissions go I have given myself 'administer' rights on ... everything, including the database. ... almost every time I have seen documentation for the ...
    (microsoft.public.word.mailmerge.fields)
  • RE: DBD::DB2 question need an example
    ... list database directory ... LI0124E Invalid argument value. ... can you run the following commands from the DB2 CLP ... means that DB2 is not liking something about your $dsn. ...
    (perl.dbi.users)