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) |