Connection Pooling works the same across all databases. So, connection pooling should be working for Excel. Of course, you don't really need connection pooling for Excel because the connection doesn't represent a network connection.
If you look closely and compare the two sql logs, you can see that under pooling, there is a SELECT @@database, [QUERY], DATABASE [DB] for each query. Each query is wrapped by SELECT/DATABASE.
If you look closely and compare the two sql logs, you can see that under pooling, there is a SELECT @@database, [QUERY], DATABASE [DB] for each query. Each query is wrapped by SELECT/DATABASE.
Issue #11926 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
Connection Pooling works the same across all databases. So, connection pooling should be working for Excel. Of course, you don't really need connection pooling for Excel because the connection doesn't represent a network connection.