Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Jun 2006 @ 19:11:06 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Microsoft Access, ODBC, finfotype error
 
From:   Dempsey, Mike

The message refers to an InfoType of 0.

Assuming the InfoType is the ODBC data type, that indicates that the ODBC driver is unable to identify the column type. The type should be 1 for a character column. Zero means 'Unavailable or Unknown'.

When you say 'text' do you specifically mean the MSAccess 'Text' type (a 1 to 255 character string) or might you be refering to a 'Memo' (in Access) field. The 'Memo' is actually a CLOB (Type is -1) and is used to store any string larger than 255 bytes.

It is quite likely that Access will have a problem loading CLOB data - especially if it tries to load it to a CHAR(2200000000) field rather than a CLOB or a CHAR(64000). [CLOBs are handled differently by different vendors, and have different limits - as do CHAR fields - so I dont know how well Access handles them.]

(If you are working with Unicode strings the data types would be -8 and -10 rather than 1 and -1. Access itself stores all strings in Unicode in the 2000 version.)

Not sure if this really helps you but I thought some background might help.


Mike Dempsey
Teradata Client Tools



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023