Skip site navigation (1) Skip section navigation (2)

"No Postgres username" error with psqlodbc

From: Craig Sanders <cas(at)vicnet(dot)net(dot)au>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: "No Postgres username" error with psqlodbc
Date: 1998-05-12 07:23:50
Message-ID: Pine.LNX.3.96.980512170004.30656N-100000@csanders.vicnet.net.au (view raw or flat)
Thread:
Lists: pgsql-interfaces
has anyone had any luck getting Cold Fusion on NT to talk to a postgres
database using the psqlodbc driver?

i've tried v0.238 and v0.239 (and another version from mid april...can't
remember the version number).  am getting an error message saying:

	ODBC Error Code = 28000 (Invalid authorization specification)

	No Postgres username specified in startup packet.


there *is* a username and a password entered into the datasource
definition, and they are correct.

BTW, i don't think it's a cold-fusion problem.  I get a similar response
with MS Access.


PS: this has occured with postgres 6.3.1 and 6.3.2 running on debian
linux.  works perfectly with decent software like perl DBI & DBD::Pg. no
luck with MS stuff so far.


craig

--
Craig Sanders
Systems Administrator
VICNET- Victoria's Network              http://www.vicnet.net.au
Ph:  +61 3 9669 9684                    Fax: +61 3 9669 9805
        ** nothing is true, everything is permitted **


pgsql-interfaces by date

Next:From: Tony CowderoyDate: 1998-05-12 08:01:57
Subject: Re: [INTERFACES] Group/Order by not in target - Was [NEW ODBC DRIVER]
Previous:From: Michael TungDate: 1998-05-11 23:32:17
Subject: JDBC for postgresql 6.3.2.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group