tag:help.appveyor.com,2012-11-13:/discussions/questions/3836-odbc-version-for-sql-serverAppVeyor: Discussion 2018-10-19T08:18:20Ztag:help.appveyor.com,2012-11-13:Comment/425257322017-05-09T18:07:58Z2017-05-09T18:07:58Zodbc version for SQL Server<div><p>Hello,</p>
<p>File <a href="https://github.com/appveyor/ci/issues/1540">this</a> issue.</p>
<p>Please use this script as temporary workaround:<br></p>
<pre>
<code>Write-Host "Installing ODBC driver..." -ForegroundColor Cyan
Write-Host "Downloading..."
$msiPath = "$($env:USERPROFILE)\msodbcsql.msi"
(New-Object Net.WebClient).DownloadFile('https://download.microsoft.com/download/D/5/E/D5EEF288-A277-45C8-855B-8E2CB7E25B96/x64/msodbcsql.msi', $msiPath)
Write-Host "Installing..."
cmd /c start /wait msiexec /i "$msiPath" /q
del $msiPath</code>
</pre>
<p>Please let us know if this workaround works for you.</p>
<p>Ilya.</p></div>Ilya Finkelshteyntag:help.appveyor.com,2012-11-13:Comment/425257322017-05-09T19:10:07Z2017-05-09T19:10:10Zodbc version for SQL Server<div><p>Thanks Ilya for your prompt response. Good news is that it works for 64 bit environment! Unfortunately, this doesn't seem to affect the 32 bit one. Also, I need to hardcode the path to that msi file (which is totally fine actually):</p>
<p>This is the extract of the appveyor.yml</p>
<ul>
<li>ps: >- If ($env:BUILD_PLATFORM -Match "x64") { (new-object net.webclient).DownloadFile('<a href="https://download.microsoft.com/download/D/5/E/D5EEF288-A277-45C8-855B-8E2CB7E25B96/x64/msodbcsql.msi">https://download.microsoft.com/download/D/5/E/D5EEF288-A277-45C8-85...</a>', 'c:\projects\msodbcsql.msi') } Else { (new-object net.webclient).DownloadFile('<a href="https://download.microsoft.com/download/D/5/E/D5EEF288-A277-45C8-855B-8E2CB7E25B96/x86/msodbcsql.msi">https://download.microsoft.com/download/D/5/E/D5EEF288-A277-45C8-85...</a>', 'c:\projects\msodbcsql.msi') }<br>
<ul>
<li>cmd /c start /wait msiexec /i "c:\projects\msodbcsql.msi" /q</li>
</ul>
</li>
</ul></div>yitamtag:help.appveyor.com,2012-11-13:Comment/425257322017-05-09T21:35:05Z2017-05-09T21:35:05Zodbc version for SQL Server<div><p>Oh, this is because AppVeyor build works are x64 VMs and 32-bit ODBC driver cannot be installed on it. If you try to install 32-bit ODBC driver manually you will see 'Unsupported operation system' error.</p>
<p>I think that there are some misunderstanding about <code>platform</code> setting in AppVeyor. It is <code>msbuild</code> target, not OS bitness.</p>
<p>Ilya.</p></div>Ilya Finkelshteyntag:help.appveyor.com,2012-11-13:Comment/425257322017-05-09T21:51:34Z2017-05-09T21:51:35Zodbc version for SQL Server<div><p>Wonderful! It works now, thanks a lot, Ilya!</p></div>yitam