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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
ASKER
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
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
ASKER