ODBC connection generates incorrect data types

Hello, When creating new database connection in Sage CRM i am using ODBC database driver which uses Microsoft Visual FoxPro Driver. This ODBC connection is then used for linking to a table from Visual FoxPro database. Sage CRM then generates a view model of this table where some data types and sizes of the fields are interpreted incorrectly. The worst thing about this is that i cant change the size nor the data type to correct format within Sage CRM. Is it possible to somehow change these data types or the way they are generated within Sage? Any comments or suggestion are welcome.# Thank you.