Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing External Data using ODBC
I use Excel to connect to a SQL Server data base using a file ODBC/DSN
connection. The data base is accessed by a ASP.Net web app, an Access app, and Excel. When running long or inefficient queries in Excel, the web app will sometimes "time out". I would like to change my file ODBC configuration to only allow non-locking connections similar to using the WITH (NOLOCK) parameter in a SELECT statement. Here is my ODBC DSN file: [ODBC] DRIVER=SQL Server UID=myuserid_r QueryLog_On=Yes Network=DBMSSOCN WSID=XX12345678 APP=Microsoft Data Access Components SERVER=MyServer Description=SQL Server ROnly Can I use the read/uncommited parameter in SQLConfigDataSource: SQL_TXN_ISOLATION = SQL_TXN_READ_UNCOMMITED to do this? if not, is there another way to create this connection on client side using a file DSN? thanks. Alan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating new link to external data (ODBC) | Excel Discussion (Misc queries) | |||
Get External Data : ODBC Lock Type | Excel Discussion (Misc queries) | |||
Importing external data | Excel Programming | |||
Pivot tables, external data sources and ODBC links | Excel Worksheet Functions | |||
Importing ODBC Data .. anywhere?? | Excel Programming |