Received: from mtiwmhc01.worldnet.att.net (mtiwmhc01.worldnet.att.net
	[204.127.131.36]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA55258
	for <pgsql-interfaces@postgresql.org>;
	Fri, 8 Oct 1999 08:01:34 -0400 (EDT)
	(envelope-from Ravindra-Prasad@worldnet.att.net)
Received: from npgm063lptop ([12.20.41.107]) by mtiwmhc01.worldnet.att.net
	(InterMail v03.02.07.07 118-134) with SMTP
	id <19991008120003.DXHE12280@npgm063lptop>
	for <pgsql-interfaces@postgresql.org>; Fri, 8 Oct 1999 12:00:03 +0000
Message-ID: <000c01bf1184$c38cc0c0$46619ca7@npgm063lptop.chubb.com>
From: "Ravi Prasad" <Ravindra-Prasad@worldnet.att.net>
To: <pgsql-interfaces@postgresql.org>
Subject: Accessing Text field using ODBC and RDO
Date: Fri, 8 Oct 1999 08:00:49 -0400
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0009_01BF1163.3C37FD40"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

This is a multi-part message in MIME format.

------=_NextPart_000_0009_01BF1163.3C37FD40
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi All
I am using the ODBC and VB6.0 to access a postgre6.4 database. I have a =
table whose column has some text fields.


I am using a recordset object to get data from it. However when hits a =
text field I get ODBC error "Invalid Cursor position".=20

I tried to use the colsize property but the ODBC driver does not return =
any value.


Does anyone know how to use text field using ODBC and rdoresultset.

Thanks
Ravi

------=_NextPart_000_0009_01BF1163.3C37FD40
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>Hi All<BR>I am using the ODBC and VB6.0 to access a postgre6.4 =
database. I=20
have a table whose column has some text fields.<BR></DIV>
<DIV>&nbsp;</DIV>
<DIV>I am using a recordset object to get data from it. However when =
hits a text=20
field I get ODBC error &quot;Invalid Cursor position&quot;. </DIV>
<DIV>&nbsp;</DIV>
<DIV>I tried to use the colsize property but the ODBC driver does not =
return any=20
value.<BR></DIV>
<DIV>&nbsp;</DIV>
<DIV>Does anyone know how to use text field using ODBC and=20
rdoresultset.<BR><BR>Thanks</DIV>
<DIV>Ravi</DIV></BODY></HTML>

------=_NextPart_000_0009_01BF1163.3C37FD40--