Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

PostgresSQL connection error.

 
   Database Help (Home) -> Visual Basic -> DAO RSS
Next:  PostgresSQL connect string  
Author Message
Fishing Guy

External


Since: Dec 18, 2007
Posts: 2



(Msg. 1) Posted: Wed Dec 19, 2007 5:00 pm
Post subject: PostgresSQL connection error.
Archived from groups: microsoft>public>vb>database>dao (more info?)

I use the connect string format from this site:
http://www.connectionstrings.com/default.aspx?carrier=postgresql

I am using VB6 with ADO. when I try to connect I got this error:

FATAL: no pg_hba.conf entry for host "192.168.0.5", user "postgres",
database "test", SSL off

VB code:

Set catObj = New ADOX.Catalog

catObj.ActiveConnection =
"Driver={PostgreSQL};Server=192.168.0.5;Port=5432;Database=test;Uid=postgres;Pwd=fishing;"


thank you for any one who can help.

--
FishingGuy DeleteThis @discussions.microsoft

 >> Stay informed about: PostgresSQL connection error. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
PostgresSQL connect string - Hi does any one out there know how to build the Postgres SQL connect string for ADO connection? thanks any one who can help. -- George @ Lexington

Can't Make Data Connection - I'm getting a bit frustrated. 1) I want to evaluate Access 2007 Beta but can't install it and posting the question concerning this produces no rewsponse from these geniuses. 2) Going to abandon Access 2003 and use some other database or programming..

Jet error - I've just started getting this error message on a seemingly random basis. 'The Microsoft Jet database engine does not recognize 'CID' as a valid field name or expression.' CID is a text field, and it is a valid column name. The line of code that..

Error 3043 - We are supporting an older app written in VB 6.0 (sp5), with Jet 3.51 connected to Access 97 databases. For most users, the system works great, but at a few sites we hit error 3043 which then causes the dreaded 3343 error. At one site, this seems to..

Error Trapping - I am trying to trap the error that raises when you attempt to query a database that does not exist. noted that DAO.DBEngine.Error.Count does contain the value of how many errors have happened. Just cant seem to catch the error so that It can be handled..
   Database Help (Home) -> Visual Basic -> DAO All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]