Обсуждение: which odbc version (32 or 64 bit) should be installed in Client ?
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
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 >
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
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 >> >
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
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 >