Difference in SQLGetInfo between 7.4 and earlier protocol

--_000_C82C3D242A30ksellgreenplumcom_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I've noticed a difference when calling SQLGetInfo with SQL_DBMS_VER. If the=
protocol attribute is set to 7.3, I get

SQL_DBMS_VER =3D PostgreSQL 8.2.13 on i386-apple-darwin9.8.0, compiled by=
GCC i686-apple-darwin9-gcc-4.0.1

If the protocol attribute is set to 7.4 (or 7.4-1) I get,

SQL_DBMS_VER =3D 8.2.13

This kind of looks like libpq is being used in the the first case to get th=
e version, and the socket library is being used in the second case.
Or perhaps the protocol is not recognized in the second case and it default=
s to the socket library?

Is this correct behavior?

Thanks,

.....Ken



--_000_C82C3D242A30ksellgreenplumcom_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<HTML>
<HEAD>
<TITLE>Difference in SQLGetInfo between 7.4 and earlier protocol</TITLE>
</HEAD>
<BODY>
<FONT FACE=3D"Calibri, Verdana, Helvetica, Arial"><SPAN STYLE=3D'font-size:=
11pt'>Hi,<BR>
<BR>
I’ve noticed a difference when calling SQLGetInfo with SQL_DBMS_VER. =
If the protocol attribute is set to 7.3, I get<BR>
<BR>
  SQL_DBMS_VER =3D PostgreSQL 8.2.13 on i386-apple-darwin9.8.0, c=
ompiled by GCC i686-apple-darwin9-gcc-4.0.1<BR>
<BR>
If the protocol attribute is set to 7.4 (or 7.4-1) I get,<BR>
<BR>
  SQL_DBMS_VER =3D 8.2.13<BR>
<BR>
This kind of looks like libpq is being used in the the first case to get th=
e version, and the socket library is being used in the second case.<BR>
Or perhaps the protocol is not recognized in the second case and it default=
s to the socket library?<BR>
<BR>
Is this correct behavior?<BR>
<BR>
Thanks,<BR>
<BR>
.....Ken <BR>
<BR>
  </SPAN></FONT>
</BODY>
</HTML>


--_000_C82C3D242A30ksellgreenplumcom_--
Ken Sell [ Do, 03 Juni 2010 01:53 ] [ ID #2042573 ]
Datenbanken » gmane.comp.db.postgresql.odbc » Difference in SQLGetInfo between 7.4 and earlier protocol

Vorheriges Thema: [ psqlodbc-Bugs-1010833 ] '--without-iodbc' enables iodbc support
Nächstes Thema: VBA, ADO, selecting from a view -> ctid not found