473,472 Members | 2,208 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

PGOLEDB connection from visual basic 6

5 New Member
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
1 7045
debasisdas
8,127 Recognized Expert Expert
Please find the connection string here and use ADO to connect to database from VB.
Oct 24 '08 #2

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

Similar topics

9
by: sleepyant | last post by:
Hi, I've posted this question on several forum but have no response. So I hope anyone who have any idea what I'm talking about please give your solution or advice. My problem is I need to check...
3
by: Stephanie | last post by:
I have a problem that I am trying to solve. We have a huge product with a whole lot of ASP and VB code. VB code is all ActiveX dlls which are used by ASP app. When I attempt to add features or fix...
7
by: greg | last post by:
Hi We have w2k, iis5, .NET/c# I periodically receive this message and the system freezes ++++++++++++++++++++++++++++++++++++++++++++++++++ Timeout expired. The timeout period elapsed...
0
by: Susan | last post by:
We purchased Visual Basic .NET version 2003 Standard I am trying to connect to an Informix database using ODBC with Visual Basic ..NET. I created the ODBC connection, and it tests OK. When I go...
35
by: Eric Sabine | last post by:
In my Finally block, I was using cn.close (where cn is an ADO.NET connection object, SQLConnection to be exact) and then I came across the following in some microsoft code. If Not cn Is Nothing...
1
by: henk | last post by:
Hello, I want make a database connection to an Oracle db (8i) with Visual Basic 2005 express BETA 2. I already installed Oracle Data Provider for .NET...
20
by: fniles | last post by:
I am using VB.NET 2003, SQL 2000, and SqlDataReader. As I read data from tblA, I want to populate tblB. I use SQLDataReader for both tables. I do not use thread. When I ExecuteReader on tblB, I...
5
by: Frank Rizzo | last post by:
This is driving me nuts. I call the InternetDial API to open a dial-up connection and it just returns 0 (success) without actually making a call. Am I missing something really simple? I've tried...
2
by: prasri | last post by:
Hi frends, I am newely joined in a small software company.I have bit knowledge in visual basic but i dont know connection strings and all.Can any one help me to give connection from Ms access to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.