Re: Need help with Visual Basic 6 and PostgreSQL

[Finn Lassen <dcio(at)AxiomInt(dot)com>]

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