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?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
rdoConnection via ODBC
- Thread starter veebee
- Start date
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?<br>
<br>
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.<br>
<br>
Mike<br>
---<br>
Mike_Lacey@Cargill.Com<br>
<br>
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.<br>
<br>
Mike<br>
---<br>
Mike_Lacey@Cargill.Com<br>
- Status
Similar threads
