Craig Ringer wrote:
If I'm wrong about any of this (which is not unlikely, really) then if
anyone else is lucky enough to be using Access with PostgreSQL and
knows of a better solution or workaround, please feel free to correct me.
We have been working with the combination of a PostgreSQL
Hi all
I've been forced into a project that uses MS Access with PostgreSQL.
This message is intended as a bit of a warning to others who actually
have a choice about it, as there are some issues you may not be aware of
that might sway your decision to use Access in a new project instead of
Craig Ringer wrote:
Hi all
I've been forced into a project that uses MS Access with PostgreSQL.
[snip]
The big issue is with Access's linked table support via ODBC (at least
as of Access 2007). Unlike tools like Hibernate, which are capable of
executing filters, queries across multiple
On Tue, Nov 18, 2008 at 1:10 AM, Craig Ringer
[EMAIL PROTECTED] wrote:
I've been forced into a project that uses MS Access with PostgreSQL.
This message is intended as a bit of a warning to others who actually
have a choice about it, as there are some issues you may not be aware of
that might
is returned.
Bayless
- Original Message -
From: Richard Huxton [EMAIL PROTECTED]
To: Craig Ringer [EMAIL PROTECTED]
Cc: PostgreSQL pgsql-general@postgresql.org
Sent: Tuesday, November 18, 2008 3:46 AM
Subject: Re: [GENERAL] MS Access and PostgreSQL - a warning to people
thinking about
Hi Edward,
Michael Fuhr's solution worked (Mar 11). I had to write a method to
insert four backslashes into the the path been searched for. For
example if the stored path in the DB was folder1\folder2\folder3\ in
order for PostgreSQL to serach against this i had to search for path
LIKE
William Shatner wrote:
I have recently migrated from MS Access to PostgreSQL.Previously I had
a SQL command
ResultSet aGroupResultSet = aGroupPathStmt.executeQuery(
SELECT \groupID\,\fullpath\ FROM \groups\ WHERE
\fullpath\ Like ' +
aPath + ');
where aPath was equal to
On Fri, 2005-03-11 at 17:52 +, Brian Gunning wrote:
[rearranged quoting]
From: [EMAIL PROTECTED]
--- William Shatner [EMAIL PROTECTED] wrote:
I have recently migrated from MS Access to
PostgreSQL.Previously I had
a SQL command
ResultSet aGroupResultSet =
I have recently migrated from MS Access to PostgreSQL.Previously I had
a SQL command
ResultSet aGroupResultSet = aGroupPathStmt.executeQuery(
SELECT \groupID\,\fullpath\ FROM \groups\ WHERE
\fullpath\ Like ' +
aPath + ');
where aPath was equal to 'folder\another
--- William Shatner [EMAIL PROTECTED] wrote:
I have recently migrated from MS Access to
PostgreSQL.Previously I had
a SQL command
ResultSet aGroupResultSet =
aGroupPathStmt.executeQuery(
SELECT \groupID\,\fullpath\ FROM
\groups\ WHERE
\fullpath\ Like ' +
aPath
On Fri, Mar 11, 2005 at 05:19:35PM +, William Shatner wrote:
I have recently migrated from MS Access to PostgreSQL.Previously I had
a SQL command
ResultSet aGroupResultSet = aGroupPathStmt.executeQuery(
SELECT \groupID\,\fullpath\ FROM \groups\ WHERE
\fullpath\ Like ' +
PROTECTED];
pgsql-general@postgresql.org; pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] [GENERAL] MS Access to PostgreSQL
--- William Shatner [EMAIL PROTECTED] wrote:
I have recently migrated from MS Access to
PostgreSQL.Previously I had
a SQL command
ResultSet aGroupResultSet
12 matches
Mail list logo