A server with server class mssodbc is Microsoft SQL Server version 6.5, Service Pack 4.
Sybase certifies the use of version 3.60.0319 of Microsoft SQL Server's 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_identifiers option controls the use of quoted identifiers for Microsoft SQL Server. For example, if you set the quoted_identifiers option to Off locally, then quoted identifiers are turned off for Microsoft SQL Server.
When you issue 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. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |