which odbc version (32 or 64 bit) should be installed in Client ?

when using psqlodbc_09_01_0200.zip,
when i store picture to bytea using vc2008,
calling appendchunk will get com_error.

On 7/4/14, sunpeng <bluevaley@gmail.com> wrote:

my server is pg 9.1.13 in win8 64, my client is win xp 32 bit, which odbc
version (32 or 64 bit) should be installed in Client ? is
psqlodbc_09_01_0200.zip or psqlodbc_09_01_0200-x64.zip?or others?
thks!
peng

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 07/03/2014 05:10 PM, sunpeng wrote:

when using psqlodbc_09_01_0200.zip,
when i store picture to bytea using vc2008,
calling appendchunk will get com_error.

The actual error message is?

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Why do I get 800A0C93 errors?

If you are getting one of these errors:

ADODB.Recordset error '800a0c93'
Operation is not allowed in this context.

or

I got ADODB.Recordset error '800a0c93'
The operation requested by the application is not allowed in this context.

or

ADODB.Recordset error '800a0c93'
Illegal Operation.

If you are using an ADODB.Recordset to UPDATE / INSERT (e.g. using the
AddNew method), use a direct SQL statement instead (see Article
#2191).

see http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-800a0c93-errors.html

how to do?

peng

On 7/4/14, sunpeng <bluevaley@gmail.com> wrote:

when using psqlodbc_09_01_0200.zip,
when i store picture to bytea using vc2008,
calling appendchunk will get com_error.

On 7/4/14, sunpeng <bluevaley@gmail.com> wrote:

my server is pg 9.1.13 in win8 64, my client is win xp 32 bit, which odbc
version (32 or 64 bit) should be installed in Client ? is
psqlodbc_09_01_0200.zip or psqlodbc_09_01_0200-x64.zip?or others?
thks!
peng

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 7/3/2014 5:08 PM, sunpeng wrote:

my server is pg 9.1.13 in win8 64, my client is win xp 32 bit, which
odbc version (32 or 64 bit) should be installed in Client ? is
psqlodbc_09_01_0200.zip or psqlodbc_09_01_0200-x64.zip?or others?

a 32 bit client OS would *mandate* a 32bit ODBC. even on a 64bit
client OS, if you have 32 bit applications, they also require 32 bit
ODBC drivers. only if both the OS *and* the client applications are
64bit would a 64bit ODBC be suitable.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Thank you, all friends, I will post "appendchunk error hresult
800a0c93" to pg_odbc mailing list.
peng

On 7/4/14, John R Pierce <pierce@hogranch.com> wrote:

On 7/3/2014 5:08 PM, sunpeng wrote:

my server is pg 9.1.13 in win8 64, my client is win xp 32 bit, which
odbc version (32 or 64 bit) should be installed in Client ? is
psqlodbc_09_01_0200.zip or psqlodbc_09_01_0200-x64.zip?or others?

a 32 bit client OS would *mandate* a 32bit ODBC. even on a 64bit
client OS, if you have 32 bit applications, they also require 32 bit
ODBC drivers. only if both the OS *and* the client applications are
64bit would a 64bit ODBC be suitable.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general