• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2255
  • Last Modified:

PostgreSQL OLE DB Provider and VB6

Hello,
I have installed the PostgreSQL 8.3 database and i have created with pgAdmin III  a blank database named testDatabase.
Now, when i have installed the database, i have also installed the PostgreSQL OLE DB Provider driver.
I have started a new VB6 project, i have have added a Microsoft ADO Data Control (Project >Components >Microsoft ADO Data Control 6.0 - OLE DB), and i tryed to connect to the testDatabase created earlyer.
I have opened the Data Link Properties for ADODC1, and I have choosed the PostgreSQL OLE DB Provider, but i don't know what information to provide for Data Source, Location and User Name in the connection tab.
I tryed to search the computer for testDatabase, but i didn't find anything.
Whai information should i provide for those fields?
0
Cristi_E
Asked:
Cristi_E
  • 3
  • 2
2 Solutions
 
Daniel WilsonCommented:
Getting some help from http://connectionstrings.com/postgre-sql#53 , I'd say:

Data Source -> MyServerName
Location -> testDatabase
User Name -> check your admin tool for what use name(s) you have set up
0
 
Cristi_EAuthor Commented:
Yes,   but i don't know how to find the Location path to the Database
0
 
Daniel WilsonCommented:
You don't need the file path to the database.  You need the database name.

The more advanced RDBMS's like SQL Server and (I think) Postgre SQL do not have the client access by file path.  They serve up the data on their own ports.
0
 
Cristi_EAuthor Commented:
So, the database name si testDatabase. I fill the Data Source with testDatabase, i leave blank the location.... and what user should i fill in?  
 I saw that a user named postgres was automatically created when i have installed the database... but if i try with this one it's not working.
Also i see that the password field in disabled. When i open pgAdmin and connect to the server i must fill in the password i set up durring the database instalation.
0
 
Cristi_EAuthor Commented:
I have reached this page..... so i have managed to solve this part.
http://www.oraxcel.com/projects/sqlxl/help/techniques/data_link_properties/

After i filled up all fields ... i pressed the Test connection button ... and succeeded!

Thanks
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now