[ psqlodbc-Bugs-1000519 ] Does not pick up default username - Mailing list pgsql-odbc

From
Subject [ psqlodbc-Bugs-1000519 ] Does not pick up default username
Date
Msg-id 20060105115357.B84421033E1E@pgfoundry.org
Whole thread Raw
List pgsql-odbc
Bugs item #1000519, was opened at 2006-01-05 12:53
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000519&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Magnus Hagander  (mha)
Assigned to: Nobody (None)
Summary: Does not pick up default username

Initial Comment:
To use ODBC with Kerberos authentication, the connection needs to pick up the current username from the logged in user
anduse that for authentication. For normal libpq connections, this works fine if you just skip specifying the username
completely.For ODBC connection, it crashes. Example vbscript: 

set conn = CreateObject("ADODB.Connection")
conn.Open "Driver={PostgreSQL UNICODE};DATABASE=admin;SERVER=server.domain.se"

This gives me the error:
H:\t2.vbs(2, 1) Microsoft OLE DB Provider for ODBC Drivers: Operation was canceled.


If I specify the username (mha) with "uid=mha", it works.


A workaround is possible when connectingl ike above, because I can have my vbscript determine the userid and pass it
along.But it's not possible with software using a global DSN that expect integrated login to work the same way as for
SQLServer.

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000519&group_id=1000125

pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: psqlODBC 8.01.0106 Development snapshot
Next
From:
Date:
Subject: [ psqlodbc-Bugs-1000498 ] rollback to savepoint in case of error