Problem with bigint of MS SQL Server 2000

[rolf]

Hi,

I'm trying to import database tables (SQL Server 2000) into
EA. All data types are ok except "bigint" which is converted
into "varchar(255)".
  I tried to adapt the types (Reference -> Database Types)
in some manner, but I've no exact plan how these things
work.

- Which product scheme will be taken from the list of
 available databases? How is the selection controlled?
- What could I do to make the things work?

I'm using
- EA 3.10 (502) and
- ODBC driver SQLServer (2000.80.194.00)

Thanks for any help
Rolf

[sparks]

Hello,

By default EA only supports SQLServer7 and because bigint is a new datatype for SQLServer2000 it is not recognised by EA's ODBC import process.  Unfortunately adding the bigint definition to the Reference -> Database datatypes will not change the import process, and EA will still import bigint as varchar (because this is the default).  We are currently reviewing the way the import process works in EA, so that the application does not need to be changed to support new products. ie the data contained in the Database Datatypes reference screen will control the mapping to the  ODBC datatype.   Sorry we couldn't couldn't be of more help at this stage.

Paul Mathers

[rolf]

Thanks for your reply.

Rolf