-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathodbc-driver-x64-x86.html
More file actions
139 lines (138 loc) · 15.4 KB
/
Copy pathodbc-driver-x64-x86.html
File metadata and controls
139 lines (138 loc) · 15.4 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8"><meta name="viewport" content="width=device-width,initial-scale=1">
<title>PostgreSQL ODBC Driver for Windows — psqlODBC x64 and x86 Setup Guide</title>
<meta name="description" content="Install and configure the PostgreSQL ODBC driver (psqlODBC) on Windows. x64 vs x86 choice, DSN setup in ODBC administrator, SSL options and troubleshooting.">
<link rel="canonical" href="https://postgre-sql.github.io/odbc-driver-x64-x86.html">
<meta name="last-modified" content="2026-06-08">
<meta property="og:title" content="PostgreSQL ODBC Driver for Windows — psqlODBC x64 and x86 Setup Guide">
<meta property="og:description" content="Install and configure the PostgreSQL ODBC driver (psqlODBC) on Windows. x64 vs x86 choice, DSN setup in ODBC administrator, SSL options and troubleshooting.">
<meta property="og:type" content="article">
<meta property="og:url" content="https://postgre-sql.github.io/odbc-driver-x64-x86.html">
<meta property="og:image" content="https://postgre-sql.github.io/og-image.svg">
<meta name="twitter:card" content="summary_large_image">
<link rel="icon" href="/favicon.svg">
<link rel="stylesheet" href="/style.css">
</head>
<body>
<nav class="site-nav"><div class="wrap"><div class="nav-inner">
<a href="/index.html" class="nav-logo"><div class="nav-logo-mark">Pg</div><span class="nav-logo-name">PostgreSQL</span><span class="nav-logo-sub">for Windows</span></a>
<div class="nav-links">
<a href="/index.html" id="nl-home">Home</a>
<a href="/download-windows.html" id="nl-dl">Download</a>
<a href="/offline-installer.html" id="nl-off">Offline</a>
<a href="/configure-windows-service.html" id="nl-svc">Service</a>
<a href="/fix-path-issues.html" id="nl-path">PATH fix</a>
<a href="/pgadmin-windows.html" id="nl-pgadmin">pgAdmin</a>
<a href="/postgresql-windows-faq.html" id="nl-faq">FAQ</a>
</div>
<a href="/download-windows.html" class="nav-cta"><svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2.5" stroke-linecap="round" stroke-linejoin="round"><path d="M21 15v4a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2v-4"/><polyline points="7 10 12 15 17 10"/><line x1="12" y1="15" x2="12" y2="3"/></svg> Download</a>
</div></div></nav>
<div class="page-hero"><div class="wrap">
<nav class="breadcrumb"><a href="/index.html">home</a> <span>/</span> <span>odbc-driver-x64-x86</span></nav>
<span class="page-tag">ODBC guide</span>
<h1>PostgreSQL ODBC driver for Windows — <span>psqlODBC x64 & x86 setup</span></h1>
<p class="page-lead">Install psqlODBC on Windows to connect Excel, Access, Power BI and other ODBC applications to PostgreSQL. Covers x64 vs x86 selection, DSN setup and common errors.</p>
</div></div>
<div class="wrap"><div class="content-layout">
<main><div class="section" aria-labelledby="what-h2"><span class="section-label">What is psqlODBC?</span><h2 id="what-h2">PostgreSQL ODBC driver for Windows — psqlODBC</h2>
<p>psqlODBC is the official ODBC driver for PostgreSQL. It allows Windows applications that use the ODBC API — such as Microsoft Excel, Access, Power BI, Tableau, and ODBC-capable programming languages — to connect to a PostgreSQL database. It is available in both x64 (64-bit) and x86 (32-bit) versions.</p>
</div>
<div class="section" aria-labelledby="which-h2"><span class="section-label">Choose the right version</span><h2 id="which-h2">x64 vs x86 — which to install?</h2>
<div class="tbl-wrap"><table><thead><tr><th>Scenario</th><th>Install</th></tr></thead><tbody>
<tr><td>64-bit applications (Excel 64-bit, Power BI, most modern apps)</td><td class="td-ok">psqlODBC x64</td></tr>
<tr><td>32-bit applications (older Excel, Access 32-bit, legacy apps)</td><td class="td-ok">psqlODBC x86</td></tr>
<tr><td>Both 32-bit and 64-bit apps on the same machine</td><td class="td-ok">Install both x64 and x86</td></tr>
<tr><td>Unsure which your app uses</td><td>Check Task Manager → Details → if app name shows *32, it is 32-bit</td></tr>
</tbody></table></div>
<div class="callout callout-info"><svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.8" stroke-linecap="round" stroke-linejoin="round"><circle cx="12" cy="12" r="9"/><line x1="12" y1="8" x2="12" y2="12"/><line x1="12" y1="16" x2="12.01" y2="16"/></svg><span>You can install both x64 and x86 versions side by side on Windows without conflict. They appear separately in ODBC Data Source Administrator.</span></div>
</div>
<div class="section" aria-labelledby="install-h2"><span class="section-label">Installation</span><h2 id="install-h2">Download and install psqlODBC</h2><ul class="steps">
<li class="step"><div class="step-n">1</div><div><h3>Download from the official source</h3><p>Get psqlODBC from <a href="https://www.postgresql.org/ftp/odbc/versions/msi/" rel="noopener">postgresql.org/ftp/odbc/versions/msi/</a>. Download the latest <code>psqlodbc_xx_xx_xxxx-x64.zip</code> for 64-bit or <code>psqlodbc_xx_xx_xxxx-x86.zip</code> for 32-bit.</p></div></li>
<li class="step"><div class="step-n">2</div><div><h3>Run the MSI installer</h3><p>Extract the ZIP and run the MSI file as Administrator. Follow the simple wizard — no configuration is needed during install.</p></div></li>
<li class="step"><div class="step-n">3</div><div><h3>Open ODBC Data Source Administrator</h3><p>Press Win+S → search <strong>ODBC</strong>. Open <strong>ODBC Data Sources (64-bit)</strong> for x64 or <strong>ODBC Data Sources (32-bit)</strong> for x86.</p></div></li>
<li class="step"><div class="step-n">4</div><div><h3>Add a new DSN</h3><p>Click <strong>Add</strong> → select <strong>PostgreSQL Unicode</strong> (or PostgreSQL ANSI for legacy apps) → fill in the connection details:</p>
<div class="term"><div class="term-bar"><div class="term-dot" style="background:#ff5f56"></div><div class="term-dot" style="background:#ffbd2e"></div><div class="term-dot" style="background:#27c93f"></div><span class="term-label">DSN configuration fields</span></div><div class="term-body"><div><span class="t-v">Data Source: MyPostgresDB</span></div><div><span class="t-v">Database: mydbname</span></div><div><span class="t-v">Server: localhost (or server IP)</span></div><div><span class="t-v">Port: 5432</span></div><div><span class="t-v">User Name: postgres</span></div><div><span class="t-v">Password: your_password</span></div></div></div>
</div></li>
<li class="step"><div class="step-n">5</div><div><h3>Test the connection</h3><p>Click <strong>Test</strong> in the DSN setup dialog. You should see <strong>Connection successful</strong>. Click Save.</p></div></li>
</ul></div>
<div class="section" aria-labelledby="dsn-h2"><span class="section-label">DSN types</span><h2 id="dsn-h2">System DSN vs User DSN vs File DSN</h2>
<div class="tbl-wrap"><table><thead><tr><th>DSN Type</th><th>Available to</th><th>Use when</th></tr></thead><tbody>
<tr><td><strong>User DSN</strong></td><td>Current user only</td><td>Personal use, development</td></tr>
<tr><td><strong>System DSN</strong></td><td>All users and services</td><td>Shared apps, Windows services, IIS</td></tr>
<tr><td><strong>File DSN</strong></td><td>Any machine with the driver</td><td>Portable connection, shared configs</td></tr>
</tbody></table></div>
</div>
<div class="section" aria-labelledby="faq-h2"><span class="section-label">FAQ</span><h2 id="faq-h2">ODBC driver questions</h2><div class="faq">
<div class="faq-item"><details><summary>PostgreSQL ODBC driver not showing in ODBC administrator</summary><div class="faq-ans">Make sure you are opening the correct bitness of ODBC administrator. The 64-bit administrator is at <code>C:\Windows\System32\odbcad32.exe</code> and the 32-bit one is at <code>C:\Windows\SysWOW64\odbcad32.exe</code>. A 64-bit driver only appears in the 64-bit administrator.</div></details></div>
<div class="faq-item"><details><summary>Unicode vs ANSI driver — which to use?</summary><div class="faq-ans">Use <strong>PostgreSQL Unicode</strong> for all modern applications. Unicode supports all character sets and locales. Use ANSI only for very old legacy applications that do not support Unicode.</div></details></div>
<div class="faq-item"><details><summary>Connection test fails with "could not connect to server"</summary><div class="faq-ans">Check: (1) PostgreSQL service is running, (2) firewall allows port 5432, (3) pg_hba.conf allows connections from your client IP. For local connections the server should be <code>localhost</code> or <code>127.0.0.1</code>.</div></details></div>
</div></div>
<div class="cta-banner"><div><h2>Need to allow remote connections?</h2><p>Configure pg_hba.conf and Windows Firewall for ODBC over the network.</p></div><a href="/postgresql-allow-remote-connections.html" class="btn-white"><svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2.5" stroke-linecap="round" stroke-linejoin="round"><path d="M21 15v4a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2v-4"/><polyline points="7 10 12 15 17 10"/><line x1="12" y1="15" x2="12" y2="3"/></svg>Remote connections guide</a></div>
<div style="margin-bottom:32px"><span class="section-label">Related guides</span><div class="rel-grid"><a href="/postgresql-allow-remote-connections.html" class="rel-card"><div class="rel-title">Remote connections →</div><div class="rel-sub">pg_hba.conf setup</div></a><a href="/postgresql-port-5432.html" class="rel-card"><div class="rel-title">Port 5432 →</div><div class="rel-sub">port configuration</div></a><a href="/pgadmin-windows.html" class="rel-card"><div class="rel-title">pgAdmin 4 →</div><div class="rel-sub">GUI alternative</div></a></div></div></main>
<aside class="content-sidebar"><div class="sb-card"><div class="version-badge-label">Latest stable</div><div class="version-badge-val">18.3</div><div class="version-badge-sub">Released May 2026</div></div><div class="sb-card"><div class="sb-card-title">Install & setup</div><ul class="sb-links"><li><a href="/download-windows.html">Download PostgreSQL</a></li><li><a href="/offline-installer.html">Offline installer</a></li><li><a href="/configure-windows-service.html">Windows service</a></li><li><a href="/fix-path-issues.html">Fix PATH / psql</a></li><li><a href="/pgadmin-windows.html">pgAdmin 4</a></li><li><a href="/install-postgresql-windows-server.html">Windows Server</a></li></ul></div><div class="sb-card"><div class="sb-card-title">Configuration</div><ul class="sb-links"><li><a href="/postgresql-config-windows.html">postgresql.conf</a></li><li><a href="/postgresql-port-5432.html">Port 5432</a></li><li><a href="/postgresql-allow-remote-connections.html">Remote connections</a></li><li><a href="/postgresql-password-windows.html">Reset password</a></li></ul></div><div class="sb-card"><div class="sb-card-title">Tools & help</div><ul class="sb-links"><li><a href="/psql-commands-windows.html">psql commands</a></li><li><a href="/pg-dump-restore-windows.html">Backup & restore</a></li><li><a href="/postgresql-python-windows.html">Python / psycopg2</a></li><li><a href="/odbc-driver-x64-x86.html" class="cur">ODBC driver</a></li><li><a href="/postgresql-not-starting-windows.html">Service not starting</a></li><li><a href="/postgresql-uninstall-windows.html">Uninstall</a></li><li><a href="/postgresql-windows-faq.html">FAQ</a></li></ul></div></aside>
</div></div>
<footer class="site-footer"><div class="wrap">
<div class="footer-inner">
<div>
<div class="footer-logo"><div class="footer-logo-mark">Pg</div><span class="footer-logo-name">PostgreSQL for Windows</span></div>
<p class="footer-tagline">Unofficial Windows guide for PostgreSQL — download, install, configure, troubleshoot.</p>
</div>
<div>
<div class="footer-col-title">Install & setup</div>
<ul class="footer-links">
<li><a href="/download-windows.html">Download PostgreSQL</a></li>
<li><a href="/offline-installer.html">Offline installer</a></li>
<li><a href="/configure-windows-service.html">Windows service</a></li>
<li><a href="/fix-path-issues.html">Fix PATH / psql</a></li>
<li><a href="/pgadmin-windows.html">pgAdmin 4</a></li>
</ul>
</div>
<div>
<div class="footer-col-title">Configuration</div>
<ul class="footer-links">
<li><a href="/postgresql-config-windows.html">postgresql.conf</a></li>
<li><a href="/postgresql-port-5432.html">Port 5432</a></li>
<li><a href="/postgresql-allow-remote-connections.html">Remote connections</a></li>
<li><a href="/postgresql-password-windows.html">Reset password</a></li>
<li><a href="/install-postgresql-windows-server.html">Windows Server</a></li>
</ul>
</div>
<div>
<div class="footer-col-title">Tools & help</div>
<ul class="footer-links">
<li><a href="/psql-commands-windows.html">psql commands</a></li>
<li><a href="/pg-dump-restore-windows.html">Backup & restore</a></li>
<li><a href="/postgresql-not-starting-windows.html">Service not starting</a></li>
<li><a href="/postgresql-uninstall-windows.html">Uninstall</a></li>
<li><a href="/postgresql-windows-faq.html">FAQ</a></li>
</ul>
</div>
</div>
<div class="footer-bottom">
<p>Not affiliated with the PostgreSQL Global Development Group. Unofficial community guide.</p>
<p><strong>Affiliate disclosure:</strong> Download links may be partner links.</p>
</div>
</div></footer>
<div class="cookie-bar" id="cookieBar" style="display:none">
<p>We use Google Analytics for anonymous traffic data. <a href="/privacy.html">Privacy policy</a></p>
<div class="cookie-btns"><button class="cookie-accept" id="cookieAccept">Accept</button><button class="cookie-decline" id="cookieDecline">Decline</button></div>
</div>
<script async src="https://www.googletagmanager.com/gtag/js?id=G-MHLW57MR8Q"></script>
<script>
window.dataLayer=window.dataLayer||[];function gtag(){dataLayer.push(arguments)}
gtag('consent','default',{analytics_storage:'denied',ad_storage:'denied'});
gtag('js',new Date());gtag('config','G-MHLW57MR8Q',{anonymize_ip:true,send_page_view:false});
function grantGA(){gtag('consent','update',{analytics_storage:'granted'});gtag('event','page_view',{page_location:location.href,page_title:document.title})}
document.addEventListener('DOMContentLoaded',function(){
var bar=document.getElementById('cookieBar');
var c=localStorage.getItem('pg_consent');
if(!c){bar.style.display='flex'}else if(c==='1'){grantGA()}
document.getElementById('cookieAccept').addEventListener('click',function(){localStorage.setItem('pg_consent','1');grantGA();bar.style.display='none'});
document.getElementById('cookieDecline').addEventListener('click',function(){localStorage.setItem('pg_consent','0');bar.style.display='none'});
});
</script>
<script type="application/ld+json">{"@context":"https://schema.org","@type":"HowTo","name":"Install PostgreSQL ODBC Driver on Windows","description":"How to install and configure psqlODBC on Windows for connecting ODBC applications to PostgreSQL.","step":[{"@type":"HowToStep","position":1,"name":"Download psqlODBC","text":"Download from postgresql.org/ftp/odbc/versions/msi/"},{"@type":"HowToStep","position":2,"name":"Run MSI installer","text":"Run as Administrator"},{"@type":"HowToStep","position":3,"name":"Open ODBC administrator","text":"Search ODBC in Start menu, open 64-bit or 32-bit version"},{"@type":"HowToStep","position":4,"name":"Add DSN","text":"Add > PostgreSQL Unicode > fill connection details > Test"}]}</script>
<script>var el=document.getElementById("nl-home");if(el)el.classList.add("active");</script>
</body></html>