Hello,

I am currently working on a solution to set up PostgreSQL on Mac OS X
Server 10.3.3 and I want to enable ODBC support so that our client PCs
can continue using their MS-Access GUI which they are used to. My
questions:

- Is ODBC included in you average build of PostgreSQL or would I have
to download any add-on packages?
- Does anyone have experience with Access/PostgreSQL? Is it working
well? I have my doubts concerning the MS-anomalies I have found in
other areas of work..

Stephan


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

--- Stephan Hochhaus <stephan (AT) yauh (DOT) de> wrote:
You need to download and install the ODBC driver on
the client pc's. Get that from here:

http://gborg.postgresql.org/project/...rojdisplay.php

You don't need to do anything on the server.

Generally Access works well using linked PostgreSQL
tables. There are some issues with running Access
client/server, and these apply regardless of what
backend database you use. The "Access Developers
Handbook" has a good coverage of these issues. There
is also a microsoft newsgroup devoted to Access
client/server. You will find some useful material on
gborg (the link I provided above); you will also find
useful material by searching the archives of the
pgsql-odbc list.

If you need to migrate Access data to PostgreSQL, I
have had good success using the Database Migration
Wizard that comes with PgAdminII. Unfortunately this
is now a legacy application, so you will need to
search for it (PgAdminIII apparently does not yet have
this feature).






__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

stephan (AT) yauh (DOT) de (Stephan Hochhaus) wrote in message news:<42DCC41E-9B63-11D8-BCA7-003065EFA8F0 (AT) yauh (DOT) de>...
PostgreSQL will serve ODBC connections by default.

However, you will need an ODBC client driver on each Windows host,
which may be and/or open-source, or one of the commercial offerings
such as those from OpenLink.


The free drivers will support some ODBC activity -- but they have
their limits, and MS Access will stretch them.

OpenLink provides two options -- Single-Tier, where all components are
installed on the Client host, and licensing is based primarily on
installed workstations; and Multi-Tier, where components are installed
on both the Client host and optimally the Database host (three-tier
connections, via a "gateway" host, are also possible), and licensing
is based primarily on concurrent database connections.

Functionally, the two are identical. The differences are primarily in
configuration (Single-Tier must be entirely configured on each Client,
while Multi-Tier may be configured entirely on the Server), and
security (Single-Tier provides nothing beyond the database's own
security, while Multi-Tier offers the administrator substantially
greater control over who may connect, from where, and with what
connection options and permissions).

OpenLink's solutions are freely downloadable from our website, with a
30-day evaluation license automatically sent to your registered email
address. There are no restrictions on features or functionality --
only the 30-day expiration.

OpenLink encourages download and testing of these components,
head-to-head with any other solutions under consideration. To this
end, we provide the open-source and GPL OpenLink ODBC Bench and
OpenLink JDBC Bench utilities. These benchmark tools are based on the
TPC-A and TPC-C suites, and perform a wide range of tests, allowing
you to compare Drivers, Databases, DSN Configurations, Operating
Systems, and more -- in your own environment, on your own equipment,
where you can be sure that the results are as honest as they can be.

Remember -- as open-source tools, you can examine all tests, and
ensure that they are not written to favor any tested element -- and
you can also add tests for any scenarios you require which have not
been covered by the TPC suites.

Finally, please be aware that OpenLink provides web-based support,
free of charge, for installation, configuration, testing, and
development with our components.

I hope this information proves of some use.

Be seeing you,

Ted

--
A: Yes.
http://learn.to/attribute
Ted Thibodeau, Jr. // voice +1-781-273-0900
x32
Evangelism & Support //
mailto:tthibodeau (AT) openlinksw (DOT) com
OpenLink Software, Inc. //
http://www.openlinksw.com/

http://www.openlinksw.com/weblogs/uda/
OpenLink Blogs
http://www.openlinksw.com/weblogs/virtuoso/

http://www.openlinksw.com/blog/~kidehen/
Universal Data Access and Virtual Database Technology Providers

stephan (AT) yauh (DOT) de (Stephan Hochhaus) wrote in message news:<42DCC41E-9B63-11D8-BCA7-003065EFA8F0 (AT) yauh (DOT) de>...
PostgreSQL will serve ODBC connections by default.

However, you will need an ODBC client driver on each Windows host,
which may be and/or open-source, or one of the commercial offerings
such as those from OpenLink.


The free drivers will support some ODBC activity -- but they have
their limits, and MS Access will stretch them.

OpenLink provides two options -- Single-Tier, where all components are
installed on the Client host, and licensing is based primarily on
installed workstations; and Multi-Tier, where components are installed
on both the Client host and optimally the Database host (three-tier
connections, via a "gateway" host, are also possible), and licensing
is based primarily on concurrent database connections.

Functionally, the two are identical. The differences are primarily in
configuration (Single-Tier must be entirely configured on each Client,
while Multi-Tier may be configured entirely on the Server), and
security (Single-Tier provides nothing beyond the database's own
security, while Multi-Tier offers the administrator substantially
greater control over who may connect, from where, and with what
connection options and permissions).

OpenLink's solutions are freely downloadable from our website, with a
30-day evaluation license automatically sent to your registered email
address. There are no restrictions on features or functionality --
only the 30-day expiration.

OpenLink encourages download and testing of these components,
head-to-head with any other solutions under consideration. To this
end, we provide the open-source and GPL OpenLink ODBC Bench and
OpenLink JDBC Bench utilities. These benchmark tools are based on the
TPC-A and TPC-C suites, and perform a wide range of tests, allowing
you to compare Drivers, Databases, DSN Configurations, Operating
Systems, and more -- in your own environment, on your own equipment,
where you can be sure that the results are as honest as they can be.

Remember -- as open-source tools, you can examine all tests, and
ensure that they are not written to favor any tested element -- and
you can also add tests for any scenarios you require which have not
been covered by the TPC suites.

Finally, please be aware that OpenLink provides web-based support,
free of charge, for installation, configuration, testing, and
development with our components.

I hope this information proves of some use.

Be seeing you,

Ted

--
A: Yes.
http://learn.to/attribute
Ted Thibodeau, Jr. // voice +1-781-273-0900
x32
Evangelism & Support //
mailto:tthibodeau (AT) openlinksw (DOT) com
OpenLink Software, Inc. //
http://www.openlinksw.com/

http://www.openlinksw.com/weblogs/uda/
OpenLink Blogs
http://www.openlinksw.com/weblogs/virtuoso/

http://www.openlinksw.com/blog/~kidehen/
Universal Data Access and Virtual Database Technology Providers