May 6, 2002 at 12:29 am
hi,
I have an Excel 97 workbook which has an external data source that connect to SQL server database thru ODBC. Everytime I refresh it ask for NT login password. The login to SQL Server has its own user name and password. As the result the connection is always failed. Does anyone know to diable the trusted connection in Excel 97?
May 6, 2002 at 6:25 am
Not aware of a way, then again I dont do much data access with Excel. Are you using a DSN, UDL, or embedded connection string?
Andy
May 6, 2002 at 8:19 pm
I will have to dig at work but what Andy states sounds right about a DSN or UDL, those things always give us trouble when moving the Excel file to different machines.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply