ODBC support

noreply | 7 Feb 2012 14:14

[ psqlodbc-Bugs-1011159 ] ODBC driver names on 64bit platforms

Bugs item #1011159, was opened at 2012-02-07 14:14
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1011159&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Jochen Wezel (jwezel)
Assigned to: Nobody (None)
Summary: ODBC driver names on 64bit platforms

Initial Comment:
On x84 and x64 systems, psqlodbc.msi installs 2 odbc drivers called
- "PostgreSql ANSI"
- "PostgreSql Unicode"

On x64 systems, psqlodbc_x64.msi installs 2 odbc drivers called
- "PostgreSql ANSI(x64)"
- "PostgreSql Unicode(x64)"

As a result, 
1. the driver name "PostgreSql" (which is often used in connection string examples on the web) doesn't work
2. the driver name differs on x64 machines for applications running in x86 mode or x64 mode. MS Access 32bit
can use the regular name "PostgreSql Unicode" but MS Access 64bit must use "PostgreSql Unicode(x64)".
This requires us to provide 2 database files for both platforms.

Suggested, simple solution:

(Continue reading)

headers

noreply | 7 Feb 2012 14:20

[ psqlodbc-Bugs-1011159 ] ODBC driver names on 64bit platforms

Bugs item #1011159, was opened at 2012-02-07 14:14
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1011159&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Jochen Wezel (jwezel)
Assigned to: Nobody (None)
Summary: ODBC driver names on 64bit platforms

Initial Comment:
On x84 and x64 systems, psqlodbc.msi installs 2 odbc drivers called
- "PostgreSql ANSI"
- "PostgreSql Unicode"

On x64 systems, psqlodbc_x64.msi installs 2 odbc drivers called
- "PostgreSql ANSI(x64)"
- "PostgreSql Unicode(x64)"

As a result, 
1. the driver name "PostgreSql" (which is often used in connection string examples on the web) doesn't work
2. the driver name differs on x64 machines for applications running in x86 mode or x64 mode. MS Access 32bit
can use the regular name "PostgreSql Unicode" but MS Access 64bit must use "PostgreSql Unicode(x64)".
This requires us to provide 2 database files for both platforms.

Suggested, simple solution:

(Continue reading)

headers

jason.tuttle | 15 Feb 2012 19:33

odbc driver version question for PostgreSQL 8.3.

It seems like I've done a reasonable amount of scouring to find the answer to this without success. So I'm going to take a shot at sending this to you.

We are installing PostgreSQL 8.3 on a 64 bit Solaris OS. Should I download the latest ODBC driver for 64 bit system (I believe it's psqlodbc_09_01_0100-x64.zip) or should I stick with one of the psqlodbc_08_03_0x00.zip versions?

Regards

Jason Tuttle
US Bank Voice Engineering *Call Center Applications
612.492.2883

U.S. BANCORP made the following annotations
---------------------------------------------------------------------
Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation.

---------------------------------------------------------------------

headers

Adrian Klaver | 15 Feb 2012 19:58

Re: odbc driver version question for PostgreSQL 8.3.

On Wednesday, February 15, 2012 10:33:09 am jason.tuttle <at> usbank.com wrote:
> It seems like I've done a reasonable amount of scouring to find the answer
> to this without success. So I'm going to take a shot at sending this to
> you.
> 
> We are installing PostgreSQL 8.3 on a 64 bit Solaris OS. Should I download
> the latest ODBC driver for 64 bit system (I believe it's
> psqlodbc_09_01_0100-x64.zip) or should I stick with one of the
> psqlodbc_08_03_0x00.zip versions?

As far as I know the ODBC drivers are backwards compatible.  The question is 
where you intend to load the driver? If you want it on Solaris the *.zip 
versions will not work as they represent MSI  packages for use in Windows.  You 
will need to get the tarballs located in the src directory here:

http://www.postgresql.org/ftp/odbc/versions/src/

When you untar them there will be a docs/ with a unix-compilation.html file to 
help with building.

> 
> Regards
> 
> Jason Tuttle
> US Bank Voice Engineering *Call Center Applications
> 612.492.2883
> U.S. BANCORP made the following annotations

-- 
Adrian Klaver
adrian.klaver <at> gmail.com

--

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

headers

jason.tuttle | 15 Feb 2012 20:32

Re: odbc driver version question for PostgreSQL 8.3.

The backwards compatible answer makes me feel good since the 8.3 version of the drivers don't specify 64 bit compatibility. We'll package the latest for deployment to our users - for use on their win xp desktops.

Thanks Adrian!

Jason Tuttle
US Bank Voice Engineering *Call Center Applications
612.492.2883

From: Adrian Klaver <adrian.klaver <at> gmail.com>
To: pgsql-odbc <at> postgresql.org
Cc: jason.tuttle <at> usbank.com
Date: 02/15/2012 12:58 PM
Subject: Re: [ODBC] odbc driver version question for PostgreSQL 8.3.

On Wednesday, February 15, 2012 10:33:09 am jason.tuttle <at> usbank.com wrote:
> It seems like I've done a reasonable amount of scouring to find the answer
> to this without success. So I'm going to take a shot at sending this to
> you.
>
> We are installing PostgreSQL 8.3 on a 64 bit Solaris OS. Should I download
> the latest ODBC driver for 64 bit system (I believe it's
> psqlodbc_09_01_0100-x64.zip) or should I stick with one of the
> psqlodbc_08_03_0x00.zip versions?

As far as I know the ODBC drivers are backwards compatible. The question is
where you intend to load the driver? If you want it on Solaris the *.zip
versions will not work as they represent MSI packages for use in Windows. You
will need to get the tarballs located in the src directory here:

http://www.postgresql.org/ftp/odbc/versions/src/

When you untar them there will be a docs/ with a unix-compilation.html file to
help with building.

>
> Regards
>
> Jason Tuttle
> US Bank Voice Engineering *Call Center Applications
> 612.492.2883
> U.S. BANCORP made the following annotations

--
Adrian Klaver
adrian.klaver <at> gmail.com

U.S. BANCORP made the following annotations
---------------------------------------------------------------------
Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation.

---------------------------------------------------------------------

headers

Adrian Klaver | 15 Feb 2012 20:53

Re: odbc driver version question for PostgreSQL 8.3.

On Wed, Feb 15, 2012 at 11:32 AM, <jason.tuttle <at> usbank.com> wrote:

The backwards compatible answer makes me feel good since the 8.3 version of the drivers don't specify 64 bit compatibility. We'll package the latest for deployment to our users - for use on their win xp desktops.

Well there is theory and then there is reality:) I would at least check out the new driver on a few machines before rolling it out. Here is a good read on 32/64 Postgres ODBC set up on Windows:

http://www.youlikeprogramming.com/2011/09/postgresql-and-odbc-in-64-bit-windows/

Thanks Adrian!

Jason Tuttle
US Bank Voice Engineering *Call Center Applications
612.492.2883

From: Adrian Klaver <adrian.klaver <at> gmail.com>
To: pgsql-odbc <at> postgresql.org
Cc: jason.tuttle <at> usbank.com
Date: 02/15/2012 12:58 PM
Subject: Re: [ODBC] odbc driver version question for PostgreSQL 8.3.

On Wednesday, February 15, 2012 10:33:09 am jason.tuttle <at> usbank.com wrote:
> It seems like I've done a reasonable amount of scouring to find the answer
> to this without success. So I'm going to take a shot at sending this to
> you.
>
> We are installing PostgreSQL 8.3 on a 64 bit Solaris OS. Should I download
> the latest ODBC driver for 64 bit system (I believe it's
> psqlodbc_09_01_0100-x64.zip) or should I stick with one of the
> psqlodbc_08_03_0x00.zip versions?

As far as I know the ODBC drivers are backwards compatible. The question is
where you intend to load the driver? If you want it on Solaris the *.zip
versions will not work as they represent MSI packages for use in Windows. You
will need to get the tarballs located in the src directory here:

http://www.postgresql.org/ftp/odbc/versions/src/

When you untar them there will be a docs/ with a unix-compilation.html file to
help with building.

>
> Regards
>
> Jason Tuttle
> US Bank Voice Engineering *Call Center Applications
> 612.492.2883
> U.S. BANCORP made the following annotations

--
Adrian Klaver
adrian.klaver <at> gmail.com

U.S. BANCORP made the following annotations

---------------------------------------------------------------------
Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation.

---------------------------------------------------------------------

--
Adrian Klaver
adrian.klaver <at> gmail.com

headers

Tamaki, Hisayoshi (TS/TC/IWS_1 | 19 Feb 2012 15:33

psqlODBC driver version compatibility with PostgreSQL database

Hi

Can I use the 8.4 driver with 9.1 servers or is not compatible? I was looking for information about the
compatibility on the official website but I couldn't find it.

Thanks,

Hisayoshi Tamaki

--

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

headers

Harun Trefry | 22 Feb 2012 03:01

Re: psqlODBC driver version compatibility with PostgreSQL database

Hi,

Yes you can.

As always, testing is the only was to guarantee that your application(s) will work with this setup, but it should be fine.

Regards,
Harun Trefry

The information contained in this email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please promptly notify the sender by reply email and then delete the email and destroy any printed copy. If you have received this email in error, you must not disclose or use this information in any way.

On 19/02/12 22:33, Tamaki, Hisayoshi (TS/TC/IWS_1) wrote:

Hi Can I use the 8.4 driver with 9.1 servers or is not compatible? I was looking for information about the compatibility on the official website but I couldn't find it. Thanks, Hisayoshi Tamaki

headers

Tamaki, Hisayoshi (TS/TC/IWS_1 | 22 Feb 2012 03:15

Re: psqlODBC driver version compatibility with PostgreSQL database

Hi Harun,

Thank you for your response.

I was relieved to find that out. Can you please tell me where can I find information about the compatibility on the Internet.

Regards,

Hisayoshi Tamaki

From: Harun Trefry [mailto:htrefry <at> lynx.com.au]
Sent: Wednesday, February 22, 2012 11:01 AM
To: Tamaki, Hisayoshi (TS/TC/IWS_1)
Cc: pgsql-odbc <at> postgresql.org
Subject: Re: [ODBC] psqlODBC driver version compatibility with PostgreSQL database

Hi,

Yes you can.

As always, testing is the only was to guarantee that your application(s) will work with this setup, but it should be fine.

Regards,
Harun Trefry

The information contained in this email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please promptly notify the sender by reply email and then delete the email and destroy any printed copy. If you have received this email in error, you must not disclose or use this information in any way.

On 19/02/12 22:33, Tamaki, Hisayoshi (TS/TC/IWS_1) wrote:

Hi

Can I use the 8.4 driver with 9.1 servers or is not compatible? I was looking for information about the compatibility on the official website but I couldn't find it.

Thanks,

Hisayoshi Tamaki

headers

Ganesh Borse | 24 Feb 2012 06:06

Request for help on retrieving binary data from bytea column using ODBC calls

Dear All,

I've a VC++ application which displays the various binary files (like jpgs, xls, zips) stored in PostgrelSQL DB in bytea column.

Files are inserted into bytea column using hex encoding.

But, when I try to access this column by executing the query "select * from tablename;" from ODBC on Windows in this application, the buffer contains the same hex encoded data, but not the binary data.

Application does the following steps to retrieve this binary data. This same code works well with other DBS, like Oracle, Sybase, DB2, MSSQL & so on.

//---------------------------------------------------------------------------------------------------

// prepare query:

wchar_t *query = _T("select * from mytable;");

SQLRETURN ret = SQLPrepare(stmt, query, SQL_NTS);

if (!SQL_SUCCEEDED(ret))

{

TRACE("SybAse:SQLprepare failed.");

DbException::sqlErrorInfo(SQL_HANDLE_STMT, stmt);

throw DbException(std::string(""));

}

// bind to column:

SQLBindCol(stmtHdl, columnNumber, SQL_C_BINARY,

m_colValue[0], m_len, &m_LenInd[0]);

// Execute query:

ret = SQLExecute(stmt);

// fetch rows

if (SQL_SUCCESS == ret || SQL_SUCCESS_WITH_INFO == ret)

{

do {

ret = SQLFetchScroll(m_stmt, SQL_FETCH_NEXT, 0);

// handle data per row here...

} while(SQL_SUCCEEDED(ret));

}

//---------------------------------------------------------------------------------------------------

Can you please help me know, how can I retrieve the data stored in bytea columns in binary format, so that those file can be handled appropriately?

Thanks in advance for your help and guidance.

Best Regards,

Ganesh

Mon	Tue	Wed	Thu	Fri	Sat	Sun

		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29

36	June 2013
91	May 2013
50	April 2013
27	March 2013
2	February 2013
17	January 2013
3	December 2012
5	November 2012
16	October 2012
20	September 2012
30	August 2012
15	July 2012
38	June 2012
18	May 2012
24	April 2012
33	March 2012
18	February 2012
10	January 2012
3	December 2011
32	November 2011
7	October 2011
14	September 2011
4	August 2011
16	July 2011
19	June 2011
11	May 2011
19	April 2011
37	March 2011
17	February 2011
25	January 2011
25	December 2010
37	November 2010
40	October 2010
35	September 2010
33	August 2010
34	July 2010
44	June 2010
52	May 2010
21	April 2010
19	March 2010
19	February 2010
24	January 2010
32	December 2009
79	November 2009
22	October 2009
40	September 2009
39	August 2009
45	July 2009
16	June 2009
43	May 2009
23	April 2009
43	March 2009
13	February 2009
24	January 2009
30	December 2008
40	November 2008
40	October 2008
38	September 2008
33	August 2008
5	July 2008
25	June 2008
19	May 2008
52	April 2008
47	March 2008
64	February 2008
45	January 2008
29	December 2007
63	November 2007
31	October 2007
21	September 2007
46	August 2007
62	July 2007
69	June 2007
73	May 2007
91	April 2007
124	March 2007
52	February 2007
84	January 2007
92	December 2006
60	November 2006
122	October 2006
112	September 2006
185	August 2006
53	July 2006
162	June 2006
77	May 2006
144	April 2006
239	March 2006
152	February 2006
308	January 2006
331	December 2005
245	November 2005
132	October 2005
206	September 2005
248	August 2005
171	July 2005
81	June 2005
77	May 2005
142	April 2005
144	March 2005
127	February 2005
95	January 2005
61	December 2004
119	November 2004
133	October 2004
104	September 2004
65	August 2004
173	July 2004
61	June 2004
47	May 2004
128	April 2004
87	March 2004
49	February 2004
119	January 2004
91	December 2003
131	November 2003
90	October 2003
119	September 2003
77	August 2003
62	July 2003
83	June 2003
74	May 2003
101	April 2003
81	March 2003
99	February 2003
111	January 2003
113	December 2002
212	November 2002
91	October 2002
110	September 2002
57	August 2002
80	July 2002
116	June 2002
71	May 2002
82	April 2002