Max LongVarChar

Max LongVarChar

am 19.04.2006 18:24:16 von sistemascmp

This is a multi-part message in MIME format.

------=_NextPart_000_003D_01C663B4.8E9413D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I need to know how to spcyfy the parameter MaxLongVarchar in a Visual =
Basic connect string
I=E1m using string like this

driver=3D{PostgreSQL};server=3D(ServerName);uid=3D(username) ;database=3D(=
databaseName)
------=_NextPart_000_003D_01C663B4.8E9413D0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">




I need to know how to spcyfy the =
parameter=20
MaxLongVarchar  in a Visual Basic connect =

string

I=E1m using string like =
this

 

size=3D2>driver=3D{PostgreSQL};server=3D(ServerName);uid=
=3D(username);database=3D(databaseName)
=


------=_NextPart_000_003D_01C663B4.8E9413D0--

Re: Max LongVarChar

am 20.04.2006 08:50:32 von Thomas Chabaud

Sistemas C.M.P. a =E9crit :
> I need to know how to spcyfy the parameter */MaxLongVarchar/* in a=20
> Visual Basic connect string
> I=E1m using string like this
> =20
> *driver=3D{PostgreSQL};server/=3D(ServerName);/uid/=3D(usern ame);/datab=
ase=3D(/databaseName)/*

Try to append "MAXLONGVARCHARSIZE=3Dyourvalue;" to your VB connection st=
ring
=09
driver=3D{PostgreSQL};server/=3D(ServerName);/uid/=3D(userna me);/database=
=3D(/databaseName)/*;MAXLONGVARCHARSIZE=3Dyourvalue;

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

NOTIFY / LISTEN

am 09.04.2007 15:00:12 von Adnan DURSUN

Hi

We developed a software that uses PostgreSQL as backend. Our
application developed using VB6 and uses ODBC for connection. Of course as
connection component is ADO.

I wonder whether PostgreSQL ODBC deriver supports PostgreSQL LISTEN
/ NOTIFY feature. Or any plan for that ?

Sincenerly ?

Adnan DURSUN
ASRIN Bilisim Ltd.


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match