By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,064 Members | 1,449 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,064 IT Pros & Developers. It's quick & easy.

PGOLEDB connection from visual basic 6

P: 5
Hey guys,

Is anybody at all using the PGOLEDB for PostGreSQL on Windows ?
I google this and i come up completely empty as far as code examples or any documentation etc.

Does anybody know how to connect to postgresql using the postgres oledb connection from visual basic 6?



Here is what I have tried

I reference the PGOLEDB.dll file

and then I try to instantiate an object

Dim cn As PGOLEDBLib.PgSession
Set cn = New PGOLEDBLib.PgSession

As soon as it hits the Set line it throws ActiveX object cannot create object.

So I also tried
Dim cn As PGOLEDBLib.PgSession
Set cn = createobject("PGOLEDBLib.PgSession")

and received the exact same error

Does nobody use PostGreSQL on windows with OLEDB?
Oct 16 '08 #1
Share this Question
Share on Google+
1 Reply


debasisdas
Expert 5K+
P: 8,127
Please find the connection string here and use ADO to connect to database from VB.
Oct 24 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.