Post reply

how to disble trusted connection Excel 97?

  • May 6, 2002 at 12:29 am

    #57964

    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

    #428489

    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

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • May 6, 2002 at 8:19 pm

    #428550

    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