2/2/2023 0 Comments Excel queries and connections![]() ![]() " Open the worksheet and place the cursor on a cell within the cell range of Apparently MS hard coded a check for "Microsoft® Query" in sql server which then runs DBCC TRACEON for no apparent reason. In that case you may get the error "User 'DOMAIN\username' does not have permission to run DBCC TRACEON." In that case, you need to alter the connection string to change "APP=Microsoft® Query" to something else. Despite having the same ODBC connection set up, excel wouldn't refresh the query and gave the error "SQL Server does not exist or access denied."Ī similar problem can happen if you update the database from sql server 2000 to sql server 2005 or 2008. This bit us when moving the reports to a different machine. Even if you change the ODBC connection on the computer, excel still uses the original connection from when the query was created. However I have recently run into a rather painful excel quirk with ODBC connections: Excel stores the database connection string internally. It's quick and easy to set-up, and provides reports that our clients can manipulate. We use Excel and database queries extensively for reporting purposes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |