Hey there, NUG,
I use PostgreSQL, but I've been using Marc's pgSQL4RB classes for a
couple years now. One of the big reasons was that the standard
PostgreSQL plugin didn't support MD5 passwords. Well, in the release
notes for 2006r2, I notice that it's supposed to do so now. But I
still can't it to work. Do I have to do something special? Here's the
code I'm using:
Dim d As PostgreSQLDatabase
d=New PostgreSQLDatabase
d.Host="myserver.com" //Obviously an example, but I've double
checked it.
d.DatabaseName="template1"
d.UserName="brad"
d.Password="mypassword" //Also an example. Come on, like I'm gonna
give you my password. ;)
d.Port=5432
If d.Connect Then
MsgBox "Success!"
Else
MsgBox "Failure."
End If
Comes up with "Failure" every time.
Similar code (but obviously not identical) works with the pgSQL4RB
classes, so I know the database is up and accepting connections. But
it only accepts MD5 passwords. Also, if I change the host to my local
machine (which accepts plain text and CRYPT passwords), it does work.
This isn't an emergency or anything. I just thought I'd kick the
tires on the built-in PostgreSQL plugin, since I haven't used it for
a while.
Thanks in advance.
--
Brad Rhine
[EMAIL PROTECTED]
http://bradrhine.com
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
