Connecting to PostgreSQL from Windows Platforms Washington

After following Damond Walker's series on PostgreSQL, you would now know how to install and administer a PostgreSQL server. This article shows you how to connect to the databases on the server from the Window platform.

Local Companies

Free Data Recovery Software
001-991-1111 x111
lane
State, WA
Benaroya Research Institute at Virginia Mason
(206) 341-1313
1201 9th Ave.
Seattle, WA
Dendreon Corporation
(206) 256-4545
3005 1st Ave.
Seattle, WA
Advanced Computer Solutions Ltd.
(206) 624-7854
500 Union St.,
Seattle, WA
Envision Telephony, Inc.
(206) 621-9384
520 Pike St.,
Seattle, WA
ClearStar.net
360-892-0687
915 Broadway
Vancouver, WA
Advanced Clinical Software
206-728-0313
2212 4th Ave
Seattle, WA
BioLife Solutions, Inc.
(425) 402-1400
3303 Monte Villa Pkwy, Ste. 310
Seattle, WA
IMAGINiT Technologies, Inc.
(206) 682-8032
2101 4th Ave.,
Seattle, WA
Coolearth Technologies, Inc.
(206) 770-9061
226 S Orcas St.
Seattle, WA

provided by: 
Originally published at Internet.com


The purpose of this article is to show you how to connect to PostgreSQL (pgsql) from 32 bit Windows platforms (9X, NT, and 2000). This is important because for the time being the Windows platform outnumbers Linux on the desktop and as software developers we are more likely to be able to determine the backend portions of our application. The example I'll use will consist of converting a Microsoft Access application to pgsql. It's pretty easy to extend the knowledge in this article to just about any Windows application that can access ODBC enabled information.

Before you can try these examples yourself you will have to get the Win32 ODBC driver for pgsql from ftp://ftp.postgresql.org/pub/odbc/index.html. You'll want to click the "download' link on the lower left part of the page to go to the download section. There are caveats listed on the pages about which platforms the ODBC driver will work with. I've personally used this driver on NT Workstation and Server as well as Windows 2000 Professional without problem. You will have to download and install the driver before you can continue with the examples provided in the rest of the article. If you're interested in what makes an ODBC driver tick you will most certainly want to download the LGPL'ed source code as well...

Read article at Internet.com site

Featured Local Company

ClearStar.net

360-892-0687
915 Broadway
Vancouver, WA
http://www.clearstar.net

Related Articles
- XSLerator: A Visual Transformation Tool Washington
Coming up with effective XSLT scripts is not a trivial task specially when complex transformations are involved and the source document has a complicated structure.
- "Just Add Linux": The Union of Commercial and Open Source Software into Existing Business Models Washington
Regional Articles
- Connecting to PostgreSQL from Windows Platforms Anacortes WA
- Connecting to PostgreSQL from Windows Platforms Arlington WA
- Connecting to PostgreSQL from Windows Platforms Auburn WA
- Connecting to PostgreSQL from Windows Platforms Bainbridge Island WA
- Connecting to PostgreSQL from Windows Platforms Battle Ground WA
- Connecting to PostgreSQL from Windows Platforms Bellevue WA
- Connecting to PostgreSQL from Windows Platforms Bellingham WA
- Connecting to PostgreSQL from Windows Platforms Bothell WA
- Connecting to PostgreSQL from Windows Platforms Bremerton WA
- Connecting to PostgreSQL from Windows Platforms Buckley WA
- Connecting to PostgreSQL from Windows Platforms Camas WA
- Connecting to PostgreSQL from Windows Platforms Chehalis WA
- Connecting to PostgreSQL from Windows Platforms Cheney WA
- Connecting to PostgreSQL from Windows Platforms East Wenatchee WA
- Connecting to PostgreSQL from Windows Platforms Edmonds WA
- Connecting to PostgreSQL from Windows Platforms Ellensburg WA
- Connecting to PostgreSQL from Windows Platforms Enumclaw WA
- Connecting to PostgreSQL from Windows Platforms Everett WA
- Connecting to PostgreSQL from Windows Platforms Federal Way WA
- Connecting to PostgreSQL from Windows Platforms Gig Harbor WA
- Connecting to PostgreSQL from Windows Platforms Issaquah WA
- Connecting to PostgreSQL from Windows Platforms Kelso WA
- Connecting to PostgreSQL from Windows Platforms Kenmore WA
- Connecting to PostgreSQL from Windows Platforms Kennewick WA
- Connecting to PostgreSQL from Windows Platforms Kent WA
- Connecting to PostgreSQL from Windows Platforms Kirkland WA
- Connecting to PostgreSQL from Windows Platforms Lacey WA
- Connecting to PostgreSQL from Windows Platforms Lake Stevens WA
- Connecting to PostgreSQL from Windows Platforms Lakewood WA
- Connecting to PostgreSQL from Windows Platforms Longview WA
- Connecting to PostgreSQL from Windows Platforms Lynden WA
- Connecting to PostgreSQL from Windows Platforms Lynnwood WA
- Connecting to PostgreSQL from Windows Platforms Maple Valley WA
- Connecting to PostgreSQL from Windows Platforms Marysville WA
- Connecting to PostgreSQL from Windows Platforms Mercer Island WA
- Connecting to PostgreSQL from Windows Platforms Moses Lake WA
- Connecting to PostgreSQL from Windows Platforms Mount Vernon WA
- Connecting to PostgreSQL from Windows Platforms Mountlake Terrace WA
- Connecting to PostgreSQL from Windows Platforms Mukilteo WA
- Connecting to PostgreSQL from Windows Platforms Oak Harbor WA
- Connecting to PostgreSQL from Windows Platforms Olympia WA
- Connecting to PostgreSQL from Windows Platforms Pasco WA
- Connecting to PostgreSQL from Windows Platforms Port Angeles WA
- Connecting to PostgreSQL from Windows Platforms Port Orchard WA
- Connecting to PostgreSQL from Windows Platforms Poulsbo WA
- Connecting to PostgreSQL from Windows Platforms Pullman WA
- Connecting to PostgreSQL from Windows Platforms Puyallup WA
- Connecting to PostgreSQL from Windows Platforms Redmond WA
- Connecting to PostgreSQL from Windows Platforms Renton WA
- Connecting to PostgreSQL from Windows Platforms Richland WA
- Connecting to PostgreSQL from Windows Platforms Seattle WA
- Connecting to PostgreSQL from Windows Platforms Sedro Woolley WA
- Connecting to PostgreSQL from Windows Platforms Selah WA
- Connecting to PostgreSQL from Windows Platforms Sequim WA
- Connecting to PostgreSQL from Windows Platforms Shelton WA
- Connecting to PostgreSQL from Windows Platforms Silverdale WA
- Connecting to PostgreSQL from Windows Platforms Snohomish WA
- Connecting to PostgreSQL from Windows Platforms Spanaway WA
- Connecting to PostgreSQL from Windows Platforms Spokane WA
- Connecting to PostgreSQL from Windows Platforms Stanwood WA
- Connecting to PostgreSQL from Windows Platforms Sumner WA
- Connecting to PostgreSQL from Windows Platforms Tacoma WA
- Connecting to PostgreSQL from Windows Platforms University Place WA
- Connecting to PostgreSQL from Windows Platforms Vancouver WA
- Connecting to PostgreSQL from Windows Platforms Washougal WA
- Connecting to PostgreSQL from Windows Platforms Wenatchee WA
- Connecting to PostgreSQL from Windows Platforms Woodinville WA
- Connecting to PostgreSQL from Windows Platforms Yakima WA
- Connecting to PostgreSQL from Windows Platforms Yelm WA
Related Articles
- "Just Add Linux": The Union of Commercial and Open Source Software into Existing Business Models Washington
With open source taking off in the marketplace, new business models for vendors providing value-added services mix and match commercial and open technologies to increase market reach.
- XSLerator: A Visual Transformation Tool Washington
Related Local Events
Intellectual Property: Commercialization & Protection
Dates: 2/17/2010 - 2/17/2010
Location: AHA!
Vancouver, WA
View Details

2010 'The Future is Now' Technology Expo
Dates: 1/27/2010 - 1/27/2010
Location: ShoWare Center
Kent, WA
View Details

Leads Group: Wired
Dates: 12/31/2009 - 12/31/2009
Location: Mud Bay Coffee
Olympia, WA
View Details

Leads Group: Wired
Dates: 12/24/2009 - 12/24/2009
Location: Mud Bay Coffee
Olympia, WA
View Details

Leads Group: Wired
Dates: 12/13/2009 - 12/13/2009
Location: Mud Bay Coffee
Olympia, WA
View Details

Topics: 
Architecture & Design Languages & Tools Project Management Web Services
Database Microsoft & .NET Security Wireless
Java Open Source Techniques XML