- Local time
- Tomorrow, 07:39
- Joined
- Jan 20, 2009
- Messages
- 12,895
I am having trouble connecting to MS SQL Server 2005 using an OLEDB DSN-less connection string. Server uses Windows Authentication.
This returns an error Login Failed for user 'username':
Should there be another argument?
The ODBC connection works:
This returns an error Login Failed for user 'username':
Code:
"Provider=SQLOLEDB;Data Source=servername;Initial Catalog=databasename;Trusted_Connection=True"
The ODBC connection works:
Code:
"Driver={SQL Server}; Server=server; Database=databasename"