Skip site navigation (1) Skip section navigation (2)

Re: Need help with Visual Basic 6 and PostgreSQL

From: Finn Lassen <dcio(at)AxiomInt(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Need help with Visual Basic 6 and PostgreSQL
Date: 2007-11-24 01:55:46
Message-ID: 474784A2.6030301@AxiomInt.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Thanks for all your help!

I finally broke down and dropped the table and recreated it WITH OID.
Now everything works, even with these simple strings:
       .ConnectionString = "Driver={PostgreSQL ANSI};Server=localhost;Port=5432;Database=postgres;Uid=user;Pwd=secret,B1=128000"
        rsOut.Open """Contact1""", dbOut, adOpenDynamic, adLockOptimistic, adCmdTable

I don't understand the difference between "LongVarchar" and "Varchar", but I have to use B1 whether I use the ANSI or UNICODE driver.
(Source content of the memo field I put into text data type can be more than 64K, so I choose 128000. The default is 8196, so it has to be increased.)

Conclusion: Version 8.2.4.0 of psqlodbc30a.dll and psqlodbc30w.dll require tables WITH OID.
(The "OID Options, Show column" -- and presumably "ShowOidColumn" -- has no effect.)

Finn



-- 
Finn Lassen
Deputy CIO
Axiom
1805 Drew Street
Clearwater, Florida 33765
727-442-7774 voice
727-442-8344 fax
dcio(at)AxiomInt(dot)com
www.AxiomInt.com



pgsql-odbc by date

Next:From: Richard Broersma JrDate: 2007-11-24 02:09:23
Subject: Re: Need help with Visual Basic 6 and PostgreSQL
Previous:From: Richard Broersma JrDate: 2007-11-24 00:50:19
Subject: Re: Need help with Visual Basic 6 and PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group