Can't input username into sspi odbcconnection - Mailing list pgsql-odbc
| From | Branden Huggins |
|---|---|
| Subject | Can't input username into sspi odbcconnection |
| Date | |
| Msg-id | CA+Dj3KbZbbm6kXM9q0TevydW3R-WuJ-=qfqkSFnHSy2rBuOfXw@mail.gmail.com Whole thread Raw |
| Responses |
Re: Can't input username into sspi odbcconnection
(Lindsay Stevens <lindsay.stevens.au@gmail.com>)
|
| List | pgsql-odbc |
Anytime I input any username into the connection string for an Odbc connectionstring when using SSPI, I get and AccessViolationException.
Is there a way to generate the extra @NETWORK without inputting a username?
or
Can I change something to make the uid string take an input without throwing an acception?
pg_hba.conf:
host all all 127.0.0.1/32 sspi include_realm=1
host all all ::1/128 sspi include_realm=1
Connection String:
"Driver={PostgreSQL Unicode};Trusted_Connection=yes;uid=bwhuggin@CCANET;database=hostdb-4.2.0;server=localhost;port=5432;"
Simple Code:
try
{
using (OdbcConnection connection = new OdbcConnection(odbc_connection_string))
{
connection.Open();
}
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine("Connection problem: " + ex);
odbc = false;
}
Result:
Connection problem: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
at System.Data.Common.UnsafeNativeMethods.SQLDriverConnectW(OdbcConnectionHandle hdbc, IntPtr hwnd, String connectionstring, Int16 cbConnectionstring, IntPtr connectionstringout, Int16 cbConnectionstringoutMax, Int16& cbConnectionstringout, Int16 fDriverCompletion)
at System.Data.Odbc.OdbcConnectionHandle.Connect(String connectionString)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)
at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at ConsoleApplication1.Program.TestMethod(String connectionMethod) in
2012\Projects\ConsoleApplication1\ConsoleApplication1\Program.cs:line 86
pgsql-odbc by date: