Can someone help me with the ADO connection string for PostgreSQL 1

[WantsToLearn]

Thanks for any help and or suggestions and have a great day!

 

[Leland123]

Hi,

Here are a couple of link that may be of some help:

http://crlab.com/pgsqlnet/

http://sourceforge.net/projects/pgsqlclient/

What language and framework are you using like VB.NET, C#.Net, momo, Microsoft .NET, VB, Visual FoxPro, etc.

Regards,

LelandJ

Leland F. Jackson, CPA
Software - Master (TM)

http://www.smvfp.com

Nothing Runs Like the Fox

 

[WantsToLearn]

Thanks, Leland! The development framework is mostly VB/VBA with a strong desire to go to .Net as soon as possible.

 

[Leland123]

Hi,

I've worked with ADO OLEDB connecting a Visual FoxPro app to a MSSQL backend using an activeX .ocx grid. Worked pretty well. I havn't used ADO to connect to a postgreSQL database, so I can't supply you with a working connection string, but the below link should help. Once you make the connection it should work about the same regardless of backend. He is a link:

http://msdn.microsoft.com/archive/d...rforumaccessadvancedadoforthevbaprogramme.asp

http://dbforums.com/arch/81/2003/5/771061

OpenLink Software Releases High-Performance, Fully Managed .NET Data Providers for Major Databases

http://www.openlinksw.com/

Here is where an OLE DB provider for postgreSQL is in development, but their is no stable release available for download at this time. You may have to use ADO OLEDB over ODBC.

Regards,

LelandJ

Leland F. Jackson, CPA
Software - Master (TM)

http://www.smvfp.com

Nothing Runs Like the Fox