C#

OriginalGriff wrote:

What help do you need?

private TypeOfClass DataConnection<TypeOfClass>(TypeOfClass db_conn_obj, int index_of_mydatafile)
    {
    return db_conn_obj;
    }

var x = DataConnection("hello", 666);

private T DataConnection<T>(T db_conn_obj, int index_of_mydatafile) where T: System.Data.Common.DbConnection
    {
    Console.WriteLine(db_conn_obj.ConnectionString);
    db_conn_obj.Open();
    return db_conn_obj;
    }

var x = DataConnection(new SqlConnection(), 666);
var y = DataConnection(new OleDbConnection(), 666);

private OleDbConnection DataConnection ( int index_of_mydatafile )
{
    string dbpath = MyDataFiles[ index_of_mydatafile ];

    string conn_string = OledbProvider(dbpath) + "data source=" + dbpath;

    Debug.WriteLine ( conn_string );

    return new OleDbConnection ( conn_string );

}

using ( OleDbConnection dbConnection = DataConnection ( index_of_mydatafile ) )
			using ( OleDbCommand dbCommand = new OleDbCommand ( sql , dbConnection ) )
			using ( OleDbDataAdapter adapter = new OleDbDataAdapter ( dbCommand ) )

private T DataConnection<T> ( T db_conn_obj , int index_of_mydatafile ) where T : System.Data.Common.DbConnection
		{
			string dbpath = MyDataFiles[ index_of_mydatafile ];
			string provider = OledbProvider ( dbpath );
			string conn_string =  provider + "data source=" + dbpath;

			Debug.WriteLine ( conn_string );

			if ( provider == "" )
			{
				conn_string = @"Data Source= xxxx\xxxx;Initial Catalog=xxxx;Integrated Security=SSPI;Connect Timeout=5;ConnectRetryCount=0;ApplicationIntent=ReadWrite;"
			}
	
			return new T ( conn_string );
		}

private T DataConnection<T>(int index_of_mydatafile) where T : System.Data.Common.DbConnection, new()
    {
    T db_conn_obj = new T();
    db_conn_obj.ConnectionString = "...";
    db_conn_obj.Open();
    return db_conn_obj;
    }

RickBishop wrote:

I'm supposed to make work with both OleDbConnection as well as SqlConnection.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Dave Kreskowiak wrote:

1) You don't encrypt the text. You're correct is questioning "how does AD know the PW is encrypted?". It doesn't. The function you're calling is running on your machine, not the server. The method hashes the password for you, gets the encrypted account details, including password, from the domain controller and makes the comparison locally. The password never leaves the machine.