You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server.md
+1-1Lines changed: 1 addition & 1 deletion
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -30,7 +30,7 @@ Version 9.2 is the latest general availability (GA) version. It supports Java 8,
30
30
When you download the driver, there are multiple JAR files. The name of the JAR file indicates the version of Java that it supports.
31
31
32
32
> [!Note]
33
-
> If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please visit the [US-English version of the site](). You can download different languages from the US-English version site by selecting [available languages](#available-languages).
33
+
> If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please visit the [US-English version of the site](https://aka.ms/downloadmssqljdbcenglish). You can download different languages from the US-English version site by selecting [available languages](#available-languages).
Copy file name to clipboardExpand all lines: docs/connect/odbc/download-odbc-driver-for-sql-server.md
+6-6Lines changed: 6 additions & 6 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -14,7 +14,7 @@ ms.author: v-daenge
14
14
15
15
# Download ODBC Driver for SQL Server
16
16
17
-
[!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
17
+
[!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
18
18
19
19
Microsoft ODBC Driver for SQL Server is a single dynamic-link library (DLL) containing run-time support for applications using native-code APIs to connect to SQL Server. Use Microsoft ODBC Driver 17 for SQL Server to create new applications or enhance existing applications that need to take advantage of newer SQL Server features.
20
20
@@ -33,7 +33,7 @@ Version 17.7.2 is the latest general availability (GA) version. If you have a pr
33
33
- Released: March 10, 2021
34
34
35
35
> [!Note]
36
-
> If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please visit the [US-English version of the site](). You can download different languages from the US-English version site by selecting [available languages](#available-languages).
36
+
> If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please visit the [US-English version of the site](https://aka.ms/downloadmsodbcsqlenglish). You can download different languages from the US-English version site by selecting [available languages](#available-languages).
37
37
38
38
## Available languages
39
39
@@ -80,11 +80,11 @@ If you need to download the packages for offline installation, all versions are
Each of these packages in turn has their own dependencies, which may or may not be present on the system. For a general solution to this issue, refer to your distribution's package manager documentation: [Redhat](https://wiki.centos.org/HowTos/CreateLocalRepos), [Ubuntu](https://unix.stackexchange.com/questions/87130/how-to-quickly-create-a-local-apt-repository-for-random-packages-using-a-debian), and [SUSE](https://en.opensuse.org/Portal:Zypper)
419
+
Each of these packages in turn has their own dependencies, which may or may not be present on the system. For a general solution to this issue, refer to your distribution's package manager documentation: [Red Hat](https://wiki.centos.org/HowTos/CreateLocalRepos), [Ubuntu](https://unix.stackexchange.com/questions/87130/how-to-quickly-create-a-local-apt-repository-for-random-packages-using-a-debian), and [SUSE](https://en.opensuse.org/Portal:Zypper)
420
420
421
421
It is also common to manually download all the dependent packages and place them together on the installation computer, then manually install each package in turn, finishing with the [!INCLUDE[msCoName](../../../includes/msconame_md.md)] ODBC Driver 13 package.
422
422
423
-
#### Redhat Linux Enterprise Server 7
423
+
#### Red Hat Linux Enterprise Server 7
424
424
425
425
- Download the latest `msodbcsql``.rpm` from [https://packages.microsoft.com/rhel/7/prod/](https://packages.microsoft.com/rhel/7/prod/).
Copy file name to clipboardExpand all lines: docs/connect/odbc/linux-mac/release-notes-odbc-sql-server-linux-mac.md
+1-1Lines changed: 1 addition & 1 deletion
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -178,7 +178,7 @@ ODBC Driver 13.1 for [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)
178
178
OS X 10.11 and macOS 10.12 are supported in the first release of the ODBC Driver on macOS. Ubuntu 16.10 is now also supported, along with Red Hat 6, 7, and SUSE 12. Each platform has a platform-relevant package (RPM or DEB) to ease installation and configuration. For more information, see the ODBC driver installation instructions for [Linux](../../../connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server.md)
179
179
and [macOS](../../../connect/odbc/linux-mac/install-microsoft-odbc-driver-sql-server-macos.md).
180
180
181
-
**unixODBC Driver Manager 2.3.1 Support Changes**: The ODBC driver no longer depends on custom packaging for the unixODBC driver manager (except on RedHat 6), and instead relies on the distribution package manager to resolve the UnixODBC dependency from the distribution's repositories.
181
+
**unixODBC Driver Manager 2.3.1 Support Changes**: The ODBC driver no longer depends on custom packaging for the unixODBC driver manager (except on Red Hat 6), and instead relies on the distribution package manager to resolve the UnixODBC dependency from the distribution's repositories.
182
182
183
183
**BCP API Support**: The Linux and macOS ODBC driver now supports the use of the [BCP API functions (**bcp_init**, etc.)](../../../relational-databases/native-client-odbc-extensions-bulk-copy-functions/sql-server-driver-extensions-bulk-copy-functions.md)
Copy file name to clipboardExpand all lines: docs/connect/oledb/download-oledb-driver-for-sql-server.md
+1-1Lines changed: 1 addition & 1 deletion
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -29,7 +29,7 @@ Microsoft OLE DB Driver 18.5 for SQL Server is the latest general availability (
29
29
- Released: December 1, 2020
30
30
31
31
> [!Note]
32
-
> If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please visit the [US-English version of the site](). You can download different languages from the US-English version site by selecting [available languages](#available-languages).
32
+
> If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please visit the [US-English version of the site](https://aka.ms/downloadmsoledbsqlusenglish). You can download different languages from the US-English version site by selecting [available languages](#available-languages).
Copy file name to clipboardExpand all lines: docs/connect/php/installation-tutorial-linux-mac.md
+24-20Lines changed: 24 additions & 20 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -14,25 +14,17 @@ manager: v-mabarw
14
14
15
15
# Linux and macOS Installation Tutorial for the Microsoft Drivers for PHP for SQL Server
16
16
17
-
The following instructions assume a clean environment and show how to install PHP 8.0, the Microsoft ODBC driver, the Apache web server, and the Microsoft Drivers for PHP for SQL Server on Ubuntu 16.04, 18.04, and 20.04, RedHat 7 and 8, Debian 9 and 10, Suse 12 and 15, Alpine 3.11 and 3.12, and macOS 10.14, 10.15, and 11.0. These instructions advise installing the drivers using PECL, but you can also download the prebuilt binaries from the [Microsoft Drivers for PHP for SQL Server](https://github.com/Microsoft/msphpsql/releases) GitHub project page and install them following the instructions in [Loading the Microsoft Drivers for PHP for SQL Server](../../connect/php/loading-the-php-sql-driver.md). For an explanation of extension loading and why we do not add the extensions to php.ini, see the section on [loading the drivers](../../connect/php/loading-the-php-sql-driver.md#loading-the-driver-at-php-startup).
17
+
The following instructions assume a clean environment and show how to install PHP 8.0, the Microsoft ODBC driver, the Apache web server, and the Microsoft Drivers for PHP for SQL Server on Ubuntu, Red Hat, Debian, Suse, Alpine, and macOS. These instructions advise installing the drivers using PECL, but you can also download the prebuilt binaries from the [Microsoft Drivers for PHP for SQL Server](https://github.com/Microsoft/msphpsql/releases) GitHub project page and install them following the instructions in [Loading the Microsoft Drivers for PHP for SQL Server](../../connect/php/loading-the-php-sql-driver.md). For an explanation of extension loading and why we do not add the extensions to php.ini, see the section on [loading the drivers](../../connect/php/loading-the-php-sql-driver.md#loading-the-driver-at-php-startup).
18
18
19
19
The following instructions install PHP 8.0 by default using `pecl install`, if the PHP 8.0 packages are available. You may need to run `pecl channel-update pecl.php.net` first. Some supported Linux distros default to PHP 7.1 or earlier, which is not supported for the latest version of the PHP drivers for SQL Server. See the notes at the beginning of each section to install PHP 7.4 or 7.3 instead.
20
20
21
21
Also included are instructions for installing the PHP FastCGI Process Manager, PHP-FPM, on Ubuntu. PHP-FPM is needed if you're using the nginx web server instead of Apache.
22
22
23
23
While these instructions contain commands to install both SQLSRV and PDO_SQLSRV drivers, the drivers can be installed and function independently. Users comfortable with customizing their configuration can adjust these instructions to be specific to SQLSRV or PDO_SQLSRV. Both drivers have the same dependencies except where noted below.
24
24
25
-
## Contents of this page
25
+
## Installing on Ubuntu
26
26
27
-
-[Installing the drivers on Ubuntu 16.04, 18.04, and 20.04](#installing-the-drivers-on-ubuntu-1604-1804-and-2004)
28
-
-[Installing the drivers with PHP-FPM on Ubuntu](#installing-the-drivers-with-php-fpm-on-ubuntu)
29
-
-[Installing the drivers on Red Hat 7 and 8](#installing-the-drivers-on-red-hat-7-and-8)
30
-
-[Installing the drivers on Debian 9 and 10](#installing-the-drivers-on-debian-9-and-10)
31
-
-[Installing the drivers on Suse 12 and 15](#installing-the-drivers-on-suse-12-and-15)
32
-
-[Installing the drivers on Alpine 3.11 and 3.12](#installing-the-drivers-on-alpine-311-and-312)
33
-
-[Installing the drivers on macOS Mojave, Catalina and Big Sur](#installing-the-drivers-on-macos-mojave-catalina-and-big-sur)
34
-
35
-
## Installing the drivers on Ubuntu 16.04, 18.04, and 20.04
27
+
Ubuntu versions 16.04, 18.04, and 20.04 are supported.
36
28
37
29
> [!NOTE]
38
30
> To install PHP 7.4 or 7.3, replace 8.0 with 7.4 or 7.3 in the following commands.
@@ -83,7 +75,9 @@ sudo service apache2 restart
83
75
84
76
To test your installation, see [Testing your installation](#testing-your-installation) at the end of this document.
85
77
86
-
## Installing the drivers with PHP-FPM on Ubuntu
78
+
## Installing on Ubuntu with PHP-FPM
79
+
80
+
Ubuntu versions 16.04, 18.04, and 20.04 are supported.
87
81
88
82
> [!NOTE]
89
83
> To install PHP 7.4 or 7.3, replace 8.0 with 7.4 or 7.3 in the following commands.
@@ -144,14 +138,14 @@ sudo systemctl status nginx
144
138
145
139
To configure nginx, you must edit the `/etc/nginx/sites-available/default` file. Add `index.php` to the list below the section that says `# Add index.php to the list if you are using PHP`:
146
140
147
-
```
141
+
```config
148
142
# Add index.php to the list if you are using PHP
149
143
index index.html index.htm index.nginx-debian.html index.php;
150
144
```
151
145
152
146
Next, uncomment, and modify the section following `# pass PHP scripts to FastCGI server` as follows:
To test your installation, see [Testing your installation](#testing-your-installation) at the end of this document.
170
164
171
-
## Installing the drivers on Red Hat 7 and 8
165
+
## Installing on Red Hat
166
+
167
+
Red Hat versions 7 and 8 are supported.
172
168
173
169
### Step 1. Install PHP (Red Hat)
174
170
@@ -246,7 +242,9 @@ sudo apachectl restart
246
242
247
243
To test your installation, see [Testing your installation](#testing-your-installation) at the end of this document.
248
244
249
-
## Installing the drivers on Debian 9 and 10
245
+
## Installing on Debian
246
+
247
+
Debian versions 9 and 10 are supported.
250
248
251
249
> [!NOTE]
252
250
> To install PHP 7.4 or 7.3, replace 8.0 in the following commands with 7.4 or 7.3.
@@ -308,7 +306,9 @@ sudo service apache2 restart
308
306
309
307
To test your installation, see [Testing your installation](#testing-your-installation) at the end of this document.
310
308
311
-
## Installing the drivers on Suse 12 and 15
309
+
## Installing on Suse
310
+
311
+
Suse Enterprise Linux versions 12 and 15 are supported.
312
312
313
313
> [!NOTE]
314
314
> In the following instructions, replace `<SuseVersion>` with your version of Suse. If you are using Suse Enterprise Linux 15, it will be SLE_15_SP1 or SLE_15_SP2. For Suse 12, use SLE_12_SP4 (or above if applicable). Not all versions of PHP are available for all versions of Suse Linux. Refer to `http://download.opensuse.org/repositories/devel:/languages:/php` to see which versions of Suse have the default version of PHP available, or check `http://download.opensuse.org/repositories/devel:/languages:/php:/` to see which other versions of PHP are available for which versions of Suse.
To test your installation, see [Testing your installation](#testing-your-installation) at the end of this document.
366
366
367
-
## Installing the drivers on Alpine 3.11 and 3.12
367
+
## Installing on Alpine
368
+
369
+
Alpine versions 3.11 and 3.12 are supported.
368
370
369
371
> [!NOTE]
370
372
> The default version of PHP is 7.3. PHP 7.4 or above may be available from testing or edge repositories for Alpine. You can instead compile PHP from source.
To test your installation, see [Testing your installation](#testing-your-installation) at the end of this document.
416
418
417
-
## Installing the drivers on macOS Mojave, Catalina and Big Sur
419
+
## Installing on macOS
420
+
421
+
MacOS versions 10.14 (Mojave), 10.15 (Catalina), and 11.0 (Big Sur) are supported.
418
422
419
423
If you do not already have it, install brew as follows:
420
424
@@ -485,7 +489,7 @@ To test your installation, see [Testing your installation](#testing-your-install
485
489
486
490
## Testing Your Installation
487
491
488
-
To test this sample script, create a file called testsql.php in your system's document root. This path is `/var/www/html/` on Ubuntu, Debian, and Redhat, `/srv/www/htdocs` on SUSE, `/var/www/localhost/htdocs` on Alpine, or `/usr/local/var/www` on macOS. Copy the following script to it, replacing the server, database, username, and password as appropriate.
492
+
To test this sample script, create a file called testsql.php in your system's document root. This path is `/var/www/html/` on Ubuntu, Debian, and Red Hat, `/srv/www/htdocs` on SUSE, `/var/www/localhost/htdocs` on Alpine, or `/usr/local/var/www` on macOS. Copy the following script to it, replacing the server, database, username, and password as appropriate.
0 commit comments