Server class mssodbc

A server with server class mssodbc is Microsoft SQL Server version 6.5, Service Pack 4.

Notes

Sybase certifies the use of Microsoft SQL Server version 3.60.0319 ODBC driver (included in the MDAC 2.0 release). Configure and test your ODBC configuration using the instructions for that product.

The following is an example of a CREATE EXISTING TABLE statement for a Microsoft SQL Server named mymssql:

CREATE EXISTING TABLE accounts,
AT 'mymssql.database.owner.accounts';

The local setting of the quoted_identifier option controls the use of quoted identifiers for Microsoft SQL Server. For example, if you set the quoted_identifier option to Off locally, then quoted identifiers are turned off for Microsoft SQL Server.

Data type conversions: Microsoft SQL Server

When you execute a CREATE TABLE statement, SQL Anywhere automatically converts the data types to the corresponding Microsoft SQL Server data types using the following data type conversions.

SQL Anywhere data type	Microsoft SQL Server default data type
BIT	bit
TINYINT	tinyint
SMALLINT	smallint
INT	int
BIGINT	numeric(20,0)
DECIMAL [defaults p=30, s=6]	decimal(prec, scale)
NUMERIC [defaults p=30 s=6]	numeric(prec, scale)
FLOAT	if (prec) float(prec) else float
REAL	real
SMALLMONEY	smallmoney
MONEY	money
DATE	datetime
TIME	datetime
TIMESTAMP	datetime
SMALLDATETIME	datetime
DATETIME	datetime
CHAR(n)	if (length > 255) text else varchar(length)
CHARACTER(n)	char(n)
VARCHAR(n)	if (length > 255) text else varchar(length)
LONG VARCHAR	text
BINARY(n)	if (length > 255) image else binary(length)
LONG BINARY	image
DOUBLE	float
UNIQUEIDENTIFIERSTR	uniqueidentifier

Discuss this page in DocCommentXchange.