Hi,
I am new to the forum and was hoping someone could help me. I've search Google and keep coming up with nothing. We are switching a database over to 2008 and the DBAs have a login trigger that requires an app to pass the application name while using windows authentication. I can't find anything examples using an Application Name parameter. Is it possible with this driver? I have the DBAs turn off the trigger and login is successful without the app name specified so I am hitting the server. Below is the string I'm using. Thanks for any help you can provide.
Provider=MSDASQL;driver={SQL Server};dsn=;server=co-db-034;database=Plaid;Trusted_Connection=Yes;Application Name=Stuffer2000
Error:
(-2147467259) [Microsoft][ODBC SQL Server Driver][SQL Server]Logon failed f....
thanks,
Mike