ANSI - character data is represented as dtWideString.Ĭontrols the extended description of the query result sets:.
Choose - lets FireDAC automatically detect the character data encoding - ANSI or Unicode.A string value is returned as a string with original encoding, numbers in binary format, and so on. Binary - values are represented as dtByteString with raw data presentation.A string value is returned as a hex string, numbers as strings, and so on. String - values are represented as dtWideString.0 specifies an infinite wait (default value).Ĭontrols the SQL_VARIANT data type representation: This is the default value.Ĭontrols the amount of time, in seconds, before an application times out while attempting to establish a connection. When connecting to a SQL Server with multiple languages, Language specifies which set of messages are used for the connection. If specified, this value is stored in the column hostname and is returned by sp_who and the Transact-SQL HOST_NAME function. Typically, this is the network name of the computer on which the application resides (optional). Note that enabling the MARS feature might result in performance degradation.įor information about MARS, see: Using Multiple Active Result Sets (MARS) MARS is a feature supported by SQL 2005 and later, or by SQL Azure. Yes - MARS is enabled for a connection.Address is usually the network name of the server, but can be other names, such as a pipe, or a TCP/IP port and socket address.Ĭontrols the MARS (multiple active result sets) support in a connection: Network address of the server running an instance of SQL Server. The name does not need to include the path and must not include the. Name of a network library dynamic-link library. The symptom of this issue is the error message "Incorrect Syntax near to ' are not supported. Note: SQL Server Native Client 10.0 (SQL Server 2008) may fail to call a stored procedure, when it is connected to SQL Server 2000. SQL Server Native Client 11.0 as the connectivity for LocalDB.See Microsoft SQL Server 2008 Native Client. We strongly recommend that you have SQL Server Native Client NN.N installed, if your application has to work with SQL Server 2008, 2012, or SQL Azure. SQL Server Native Client NN.N as the connectivity for SQL Server 2000, 2005, 2008, 2012, and SQL Azure.We strongly recommend that you have SQL Native Client installed, if your application has to work with SQL Server 2005. SQL Native Client as the connectivity for SQL Server 20.Most likely, the ODBC driver is already installed on your workstation. SQL Server ODBC driver as the connectivity for SQL Server 2000.For a description of how to connect to Microsoft SQL Server Compact Edition, see Connect to Microsoft SQL Server Compact Edition.įireDAC requires one of the Microsoft SQL Server x86 or 圆4 ODBC drivers to be installed on the workstation: The FireDAC native driver supports Microsoft SQL Server Standard and Express editions version 2000 and later, and Microsoft SQL Azure.