SQL server data types????

[muwanda at my-deja.com]

hi


this is the TEST SUITE...

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
Test suite:
 Connecting to the database.
 Connected to DBMS: Microsoft SQL Server; Version: 07.00.0623
              ODBC driver: SQLSRV32.DLL 03.70.0820; ODBC Version: 03.51

 BIGINT column type with 64bits              : type not supported
 BINARY column type                          : not supported
 BIT column type                             : supported
 BLOB column type with binary data           : type not supported
 BLOBs with >32kB text data                  : type not supported
 CHAR column type                            : supported
 CHAR column type with binary data           : supported
 CHAR padding (with spaces)                  : supported
 DATE column type                            : type not supported
 DATETIME column type                        : supported
 DATETIME with string values                 : not supported [column 0
of row 0: input data: '1999-03-02 11:48:03.00' (type=string,len=?),
output data: <DateTime object for '1999-03-02 11:48:03.00' at b27828>
(type=DateTime,len=?), output - input: ?]
 DECIMAL column type                         : supported
 DOUBLE column type                          : type not supported
 FLOAT column type                           : supported
 IMAGE column type                           : supported
 INT column type                             : supported
 INT column type using array processing      : supported
 LONG BYTE column type                       : type not supported
 LONG BYTE with >32kB text data              : type not supported
 LONG column type                            : type not supported
 LONGBINARY column type (binary data)        : type not supported
 LONGTEXT column type (text data)            : type not supported
 LONGs with >32kB text data                  : type not supported
 LONGs with binary data                      : type not supported
 MEMO column type                            : type not supported
 MEMOs with >32kB text data                  : type not supported
 MEMOs with binary data                      : type not supported
 NULLable columns                            : supported
 TEXT column type                            : supported
 TIME column type                            : type not supported
 TIMESTAMP column type                       : unexpected database
error [mxODBC.IntegrityError: ('23000', 273, '[Microsoft][ODBC SQL
Server Driver][SQL Server]Cannot insert a non-null value into a
timestamp column. Use INSERT with a column list or with a default of
NULL for the timestamp column.', 3176)]
 TIMESTAMP data having fractions             : unexpected database
error [mxODBC.IntegrityError: ('23000', 273, '[Microsoft][ODBC SQL
Server Driver][SQL Server]Cannot insert a non-null value into a
timestamp column. Use INSERT with a column list or with a default of
NULL for the timestamp column.', 3176)]
 Transactions                                : supported
 VARBINARY column type                       : supported
 VARCHAR column type                         : supported
 VARCHAR column type with binary data        : supported
 Variable Bind Method                        : SQL Type

&&&&&&&&&&&&&&&&&&&&

and if I have in a table (SQL server) a datatype nvarchar, Python shell
send the follow error:

InterfaceError: SQL type (code -9) not implemented

To solve this erro, i need make a cast, but it's so hard, because I
have a lot a fields nvarhcar....

I need Help???
thanks


Sent via Deja.com http://www.deja.com/
Before you buy.