The server class MSSODBC is used to access Microsoft SQL Server through one of its ODBC drivers.
Versions of Microsoft SQL Server ODBC drivers that have been used are:
Microsoft SQL Server ODBC Driver Version 06.01.7601
Microsoft SQL Server Native Client Version 10.00.1600
The following is an example for Microsoft SQL Server:
CREATE SERVER mysqlserver CLASS 'MSSODBC' USING 'DSN=MSSODBC_cli'; CREATE EXISTING TABLE accounts AT 'mysqlserver.master.dbo.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.
When you execute a CREATE TABLE statement, SAP Sybase IQ automatically converts the data types to the corresponding Microsoft SQL Server data types using the following data type conversions.
| SAP Sybase IQ data type | Microsoft SQL Server default data type |
|---|---|
| BIT | bit |
| VARBIT(n) | if (n <= 255) varbinary(n) else image |
| LONG VARBIT | image |
| TINYINT | tinyint |
| SMALLINT | smallint |
| INTEGER | int |
| BIGINT | numeric(20,0) |
| UNSIGNED TINYINT | tinyint |
| UNSIGNED SMALLINT | int |
| UNSIGNED INTEGER | numeric(11,0) |
| UNSIGNED BIGINT | numeric(20,0) |
| CHAR(n) | if (n <= 255) char(n) else text |
| VARCHAR(n) | if (n <= 255) varchar(n) else text |
| LONG VARCHAR | text |
| NCHAR(n) | if (n <= 4000) nchar(n) else ntext |
| NVARCHAR(n) | if (n <= 4000) nvarchar(n) else ntext |
| LONG NVARCHAR | ntext |
| BINARY(n) | if (n <= 255) binary(n) else image |
| VARBINARY(n) | if (n <= 255) varbinary(n) else image |
| LONG BINARY | image |
| DECIMAL(precision, scale) | decimal(precision, scale) |
| NUMERIC(precision, scale) | numeric(precision, scale) |
| SMALLMONEY | smallmoney |
| MONEY | money |
| REAL | real |
| DOUBLE | float |
| FLOAT(n) | float(n) |
| DATE | datetime |
| TIME | datetime |
| SMALLDATETIME | smalldatetime |
| DATETIME | datetime |
| TIMESTAMP | datetime |
| TIMESTAMP WITH TIMEZONE | varchar(254) |
| XML | xml |
| ST_GEOMETRY | image |
| UNIQUEIDENTIFIER | binary(16) |