Excel Windows Authentication to SQL Server

  • Thread starter Thread starter John Couch
  • Start date Start date
J

John Couch

Is there a way to have Excel AUthenticate to SQL Server via UDL file similar
to using a ODBC DSN?
 
I'm not an expert in SQL but I was reading a book last night. ODBC is the
older verions of data accesses and doesn't support SQL. You need to move up
to ADO which will support SQL. ODBC was used prior to Excel 2000. ADO was
1st introduced in Excel 2000 with enhancements added in Excel 2003.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel / Sql Server / Pivot Tables 2
Managing ODBC connections 1
Connect to SQL with DSN without uid and password 3
Connect to SQL with DSN without uid adn password 1
troubles with dns-less connection to sql 0
Access 2007 Application for Reports Only – SQL Server Security 3
Change database connection between live and test for external data 5
ODBC Connection String mystery 2

Back
Top