postgresql & VB6

[peterv6]

Does anyone know if VB6 can connect to a postgresql database? If so, can you pass along information on how to do it? I've only done it with Access databases. All help would be greatly appreciated.
Peter V.

PETERV
Syracuse, NY &
Boston, MA

 

[BobRodes]

If you google to "ole db provider postgresql" you will find numerous links to them. An OLE DB provider is an implementation that allows an ADO Connection object to connect to a given back end database. In the connectionstring property, when you say, for example, "Provider=SQLOLEDB;" you are specifying the OLE DB provider for SQL Server. Yours will say "Provider=postgresql;" or something similar.

HTH

Bob

 

[johnwm]

There is a fine collection of connection strings for MANY types of database here:

http://www.carlprothman.net/Default.aspx?tabid=81

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[BobRodes]

Let me also make clear to the OP that it's necessary to download and install an OLE DB provider for postgresql, and then use the appropriate connection string.