| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Windows Authentication to SQL Server
Is there a way to have Excel AUthenticate to SQL Server via UDL file similar
to using a ODBC DSN? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Windows Authentication to SQL Server
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. "John Couch" wrote: Is there a way to have Excel AUthenticate to SQL Server via UDL file similar to using a ODBC DSN? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Installing Excel to Windows 2003 Terminal Server | Excel Discussion (Misc queries) | |||
| Excel 2000 on Windows Server 2003 | Excel Discussion (Misc queries) | |||
| Is Excel 95 compatible with Windows 2003 Server? | Excel Discussion (Misc queries) | |||
| making changes to excel file on Windows 2003 small business server | Excel Discussion (Misc queries) | |||
| problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) | |||
Linear Mode
