Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

rdoConnection via ODBC

rdoConnection via ODBC

rdoConnection via ODBC

I am using a VB6 rdo connection to access files on a Sun Universe database via an ODBC connection. I can read records no problem, and manipulate the data. The problem occurs on the write back to disk on the Sun, when all the rdoColumns write back, but pad out the data with spaces to the length of the rdoColumn. ie. If the word 'RECORD' is written back, and the length of the rdoColumn is 10, what gets back to the Sun Universe system is 'RECORD '. I have trimmed the data and attempted to terminate all the strings with null but to no avail. The debug window confirms the data is leaving the program without the spaces, but a diagnostic product we have confirms that the spaces are present by the time the record gets to the ODBC connection. Has anybody any ideas to correct this?

RE: rdoConnection via ODBC

Somthing similar happens with Oracle. If you define a field as a CHAR(10) field it will be padded on the database. VARCHAR(10) allows the kind of field you want. Are you sure it isn't this kind of problem?

If you are sure - I would talk to the ODBC Driver vendor, ask them if it does that for some reason or if it's a known bug and they have a later release.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close