Ako PoIS pristupa preko ODBCa SQL Serveru 2005, na svakom klijentu mora biti instaliran SQL Native Client. I ODBC konekcija na SQL server se pravi preko ovog ODBC drajvera. SQL Nativ Client nije instaliran na operativnom sistemu Windows XP i starijim Windows operativnim sistemima tako da morate preuzeti programe (čije linkove za preuzimanje imate ispod) i instalirati na svaki klijentski računar, zatim formirati ODBC (koristeci SQL Nativ Client) za pristup Microsoft SQL Serveru 2005.Kako instalirati Microsoft SQL Native Client:
2 коментара:
SQL Native Client (ODBC)
ODBC is a standard definition of an application programming interface (API) used to access data in relational or indexed sequential access method (ISAM) databases. SQL Server supports ODBC, via the SQL Native Client ODBC driver, as one of the native APIs for writing C, C++, and Microsoft Visual Basic® applications that communicate with SQL Server.
SQL Server programs that are written using the SQL Native Client ODBC driver communicate with SQL Server through C function calls. The SQL Server-specific versions of the ODBC functions are implemented in the SQL Native Client ODBC driver. The driver passes SQL statements to SQL Server and returns the results of the statements to the application. The SQL Native Client driver supports connecting to SQL 7.0 and later.
The SQL Native Client ODBC driver complies with the Microsoft Win32® ODBC 3.51 specification. The driver supports applications written using earlier versions of ODBC in the manner defined in the ODBC 3.51 specification.
What is SQL Native Client?
Microsoft SQL Server Native Client (SQL Native Client) contains the SQL ODBC driver and SQL OLE DB provider in one native dynamic link library (DLL) supporting applications using native-code APIs (ODBC, OLE DB and ADO) to Microsoft SQL Server. SQL Native Client was introduced in Microsoft SQL Server 2005 to provide new functionality above and beyond that supplied by the Microsoft Data Access Components (MDAC). SQL Native Client should be used to create new applications or enhance existing applications that want to take advantage of new SQL Server 2005 features such as database mirroring, multiple active result sets (MARS), query notifications, snapshot isolation, and XML data type support. For more information, about the new features supported by SQL Native Client, see Features of SQL Native Client and Native API for SQL Server 2005 FAQ.
Постави коментар