So-net無料ブログ作成

Accessのリンクテーブル「ODBC--呼び出しが失敗しました」タイムアウト設定とパススルークエリ

Access2010 から、SQL Server 2008 R2 のDBへODBC接続して、リンクテーブルを設定する。
Access側でローカルクエリを実行すると、
 
   「ODBC--呼び出しが失敗しました。[ODBC SQL SERVER DRIVER]時間切れになりました」 
 
となってしまう。
 
そもそも、リンクテーブルに対して、joinの多用や、クエリの入れ子が深いとパフォーマンスは期待できない。
 
さらに、SQL Server側で、SSISやレプリケーションなどのトランザクション実行時は、レコードが参照できなくなり、
参照したい場合は "ダーティリード" という指定をする必要があるらしい。
 
ここでは、タイムアウトの設定とパススルークエリについてまとめ、 ダーティリードについては、別の機会にまとめる。
 
◆タイムアウトの設定
Accessのクエリをデザインモードで開く
[デザイン] タブ の [プロパティシート] をクリックして開く
[ODBCタイムアウト] の項目値を変更する  (デフォルト=60(秒)、0=タイムアウトなし)
 
◆パススルークエリ
Accessのクエリをデザインモードで開く
  作成 > クエリデザイン > [テーブルの表示] ダイアログは閉じる
[デザイン] タブ の [パススルー] をクリック
同じく [プロパティシート] をクリックしえ開く 
[ODBC 接続文字列] の項目に接続文字列を設定 
  たとえば、
  "ODBC;DRIVER=SQL Server;LANGUAGE=日本語;DATABASE=DBname;
     SERVER=HostPathname;Integrated Security=SSPI;Auto Translate=True;"
接続文字列情報にパスワードとログオン名を保存する場合、確認ダイアログが表示されるので、[はい] をクリック 
SQL パススルー クエリ ウィンドウにコピーしたAccessクエリを貼り付ける
   ここでAccessクエリをSQLクエリに準じて書き換える
   たとえば、
   dbo_Tablename は、dbo.Tablename という記述に、IIF文は、case文に、といった具合

(Windows Server 2008R2, SQL Server 2008 R2、Windows 7、 Access2010、ODBC)
 

タグ:Windows SQL ODBC
nice!(0)  コメント(70)  トラックバック(0) 

nice! 0

コメント 70

CrbnOptispGF

no credit check payday loans - http://personalnerloan.org/ bad credit home loan <a href=http://personalnerloan.org/>unsecured personal loans</a> ’
by CrbnOptispGF (2017-09-21 02:16) 

お名前(必須)

generic cialis from india
<a href="http://cialisofkl.com/">online cialis</a>
cialis generic online
<a href=http://cialisofkl.com/>cialis</a>
by お名前(必須) (2017-09-23 08:55) 

お名前(必須)

buy cialis australia
<a href="http://cialisovnas.com/">online cialis</a>
buy cialis uk
<a href=http://cialisovnas.com/>cialis</a>
by お名前(必須) (2017-09-23 18:22) 

VqvqloakyEA

cialis 5mg reviews
<a href="http://gawcialis.com/">generic cialis</a>
low dose cialis
<a href=http://gawcialis.com/>generic cialis</a> ’
by VqvqloakyEA (2017-09-24 17:29) 

FfvgprailiIM

cialis tablete
<a href="http://veucialis.com/">buy cialis</a>
discount cialis online
<a href=http://veucialis.com/>buy cialis</a> ’
by FfvgprailiIM (2017-09-24 17:29) 

お名前(必須)

cialis pills for sale
<a href="http://retcialis.com/">cialis online</a>
buy cialis 20mg
<a href="http://retcialis.com/">buy cialis</a> ’
by お名前(必須) (2017-09-24 17:31) 

お名前(必須)

cialis canadian pharmacy
<a href="http://cialiseimah.com/">cheap cialis</a>
generic cialis any good
<a href=http://cialiseimah.com/>buy cialis</a> ’
by お名前(必須) (2017-09-25 20:17) 

お名前(必須)

36 hour cialis
<a href="http://cialisoakdm.com/">generic cialis</a>
cialis tadalafil tablets
<a href=http://cialisoakdm.com/>generic cialis</a> ’
by お名前(必須) (2017-09-25 20:42) 

お名前(必須)

cialis effectiveness
<a href="http://cialisjrncd.com/">generic cialis</a>
generic cialis
<a href=http://cialisjrncd.com/>generic cialis</a> ’
by お名前(必須) (2017-09-25 20:44) 

VtnoVotaSY

buy online cialis - https://jrucialis.com
generic cialis fast shipping <a href=https://jrucialis.com>buy cialis</a> ’
by VtnoVotaSY (2017-09-26 22:19) 

KrtpcoaklyDE

how cialis works - http://haycialis.com/
cialis for sale <a href=http://haycialis.com/>generic cialis</a> ’
by KrtpcoaklyDE (2017-09-26 22:19) 

お名前(必須)

cialis purchase - https://cialisonlin.com
buy cialis 20mg <a href=https://cialisonlin.com>buy cialis</a> ’
by お名前(必須) (2017-09-27 08:18) 

お名前(必須)

24 hour cialis - http://cialiskanr.com
cheapest brand cialis <a href=http://cialiskanr.com>buy cialis</a> ’
by お名前(必須) (2017-09-27 08:19) 

お名前(必須)

cialis and women
<a href="http://cialiseimah.com/">cialis</a>
cialis once a day pricing
<a href=http://cialiseimah.com/>cialis</a>
by お名前(必須) (2017-09-27 15:31) 

お名前(必須)

debt relief
<a href="https://paydayrvjlo.com/">payday loans online</a>
guaranteed payday loans direct lenders
<a href=https://paydayrvjlo.com/>bad credit payday loans</a> ’
by お名前(必須) (2017-09-28 22:29) 

お名前(必須)

of payday loan
<a href="https://cashrvyn.com/">payday advances</a>
instant online loans bad credit
<a href="https://cashrvyn.com/">cash advance</a> ’
by お名前(必須) (2017-09-28 22:29) 

お名前(必須)

short term loan
<a href="https://paydaaexc.com/">pay day loans</a>
100 online payday loans
<a href=https://paydaaexc.com/>payday loans online direct lenders only</a> ’
by お名前(必須) (2017-09-29 04:32) 

お名前(必須)

bad credit consolidation loans
<a href="https://paydaytbukl.org/">cash advances</a>
payday loan no credit check
<a href=https://paydaytbukl.org/>payday loans</a> ’
by お名前(必須) (2017-09-29 11:04) 

お名前(必須)

bad credit payday loans no fax
<a href="https://paydayvynk.org/">cash advance</a>
a plus payday loan
<a href=https://paydayvynk.org/>same day loans</a> ’
by お名前(必須) (2017-09-29 13:26) 

お名前(必須)

bad credit loan
<a href="https://paydaykmae.com">cash advance online</a>
same day cash loans bad credit
<a href="https://paydaykmae.com">cash advance america</a> ’
by お名前(必須) (2017-09-30 18:32) 

???(??)

payday loan cash advance
<a href="https://loansonlinevaec.org">payday loans online</a>
payday loans online
[url=https://loansonlinevaec.org]online payday loan[/url] ’
by ???(??) (2017-09-30 18:32) 

お名前(必須)

need personal loan
<a href="https://paydayvrvi.org">payday loans</a>
irs tax debt relief
<a href=https://paydayvrvi.org>payday loans online</a> ’
by お名前(必須) (2017-10-01 07:40) 

お名前(必須)

freedom debt relief reviews
<a href="https://leopaydayadvanceonlinefastpayday.org">online loans</a>
loans people bad credit
<a href=https://leopaydayadvanceonlinefastpayday.org>payday advance</a> ’
by お名前(必須) (2017-10-01 09:35) 

FvrcIdeadaHZ

loans payday loans
<a href="https://cashadvanceamericasev.org">3 month payday loans</a>
cash loans
<a href=https://cashadvanceamericasev.org>payday loans online same day</a> ’
by FvrcIdeadaHZ (2017-10-01 10:12) 

お名前(必須)

affordable payday loan online
<a href="https://badcreditnyrc.org">fast payday loans</a>
low interest loans
<a href=https://badcreditnyrc.org>online loan</a> ’
by お名前(必須) (2017-10-01 14:05) 

お名前(必須)

online payday advance loans
<a href="https://cashadvanceamericavatn.org">cash advance usa</a>
personal loans for people with bad credit
<a href=https://cashadvanceamericavatn.org>cash advance</a> ’
by お名前(必須) (2017-10-01 16:15) 

お名前(必須)

quick personal loans
<a href="https://paydayllae.com/">payday loans online</a>
a plus payday loan
<a href=https://paydayllae.com/>pay day loans</a> ’
by お名前(必須) (2017-10-03 21:29) 

お名前(必須)

home loans people bad credit
<a href="https://paydayloanswwe.com/">payday cash loan</a>
cash loans
<a href=https://paydayloanswwe.com/>payday day loans</a> ’
by お名前(必須) (2017-10-04 03:36) 

お名前(必須)

instant payday loan
<a href="https://cashadmme.com/">bad credit payday loans</a>
personal loans people bad credit
<a href=https://cashadmme.com/>get payday loan</a> ’
by お名前(必須) (2017-10-04 10:26) 

JtnbIdeadaRF

no fax same day payday loans
<a href="https://paydayloamec.com/">payday loans online</a>
account now payday loan
<a href=https://paydayloamec.com/>payday loans online</a> ’
by JtnbIdeadaRF (2017-10-04 13:11) 

お名前(必須)

bad credit loans no payday loans - https://paydayllae.com/
1 hr payday loan <a href=https://paydayllae.com/>payday loans</a> ’
by お名前(必須) (2017-10-05 05:22) 

お名前(必須)

bad credit payday loans no faxing - https://paydayloanswwe.com/
online loans no credit check instant approval <a href=https://paydayloanswwe.com/>payday loans</a> ’
by お名前(必須) (2017-10-05 11:35) 

お名前(必須)

personal loans people bad credit - https://cashadmme.com/
bad credit auto loans <a href=https://cashadmme.com/>best payday loans</a> ’
by お名前(必須) (2017-10-05 17:50) 

お名前(必須)

payday loan - https://paydayloawdcr.com/
check cash <a href="https://paydayloawdcr.com/">payday loans online same day</a> ’
by お名前(必須) (2017-10-06 21:07) 

お名前(必須)

cialis vs cialis professional - https://onlineonlinecialis.com/
cialis samples free <a href=https://onlineonlinecialis.com/>cialis</a>
by お名前(必須) (2017-10-06 21:07) 

お名前(必須)

cash 1 payday loan - https://cashecbya.com/
loan payday savings <a href=https://cashecbya.com/>payday loans online</a> ’
by お名前(必須) (2017-10-07 03:48) 

お名前(必須)

loans for poor credit - https://paydayloansrvhj.com/
personal installment loan <a href=https://paydayloansrvhj.com/>payday loans online</a> ’
by お名前(必須) (2017-10-07 09:52) 

お名前(必須)

cialis weekend pill - https://cheapcheapcialis.com/
cialis professional vs regular <a href=https://cheapcheapcialis.com/>buy cialis</a> ’
by お名前(必須) (2017-10-07 12:33) 

お名前(必須)

does female cialis work
<a href="https://onlineonlinecialis.com/">cheap cialis</a>
brand cialis over the net
<a href=https://onlineonlinecialis.com/>generic cialis</a> ’
by お名前(必須) (2017-10-08 04:48) 

お名前(必須)

cialis professional uk
<a href="https://buybuybuycialis.com/">cialis online</a>
cialis made in india
<a href=https://buybuybuycialis.com/>cialis online</a> ’
by お名前(必須) (2017-10-08 11:08) 

お名前(必須)

payday cash loan
<a href="https://cashecbya.com/">payday loans</a>
3 month payday loans uk
<a href=https://cashecbya.com/>get payday loan</a> ’
by お名前(必須) (2017-10-08 11:10) 

お名前(必須)

generic cialis soft - http://buycialis-menedpil.com/
cialis everyday pill <a href="http://buycialis-menedpil.com/">generic cialis</a> ’
by お名前(必須) (2017-10-11 02:30) 

お名前(必須)

cialis drug - http://cialisonline-vipmej.com/
cheap liquid cialis <a href=http://cialisonline-vipmej.com/>cialis samples</a> ’
by お名前(必須) (2017-10-11 08:28) 

お名前(必須)

cialis 5mg daily dose - http://cialisonline-pricepil.com/
cialis dosage 40 mg <a href=http://cialisonline-pricepil.com/>buy cialis</a> ’
by お名前(必須) (2017-10-11 14:16) 

お名前(必須)

medicament cialis - http://onlinecialis-cialisvip.com
buy cialis in canada <a href=http://onlinecialis-cialisvip.com>online cialis</a> ’
by お名前(必須) (2017-10-11 22:39) 

AqrhdatommaDI

is generic cialis from india safe - http://genericcialis-viaed.com/
cialis next day delivery <a href=http://genericcialis-viaed.com/>buy cialis</a> ’
by AqrhdatommaDI (2017-10-12 01:06) 

お名前(必須)

buying cialis online
<a href="http://cialisonline-vipmej.com/">cialis sample</a>
cialis sales
<a href=http://cialisonline-vipmej.com/>generic cialis</a> ’
by お名前(必須) (2017-10-12 10:56) 

お名前(必須)

bad credit no credit check payday loan - https://paydayceinf.org/
best payday loan online <a href=https://paydayceinf.org/>fast payday loan</a> ’
by お名前(必須) (2017-10-17 23:30) 

お名前(必須)

canadian payday loan association - https://paydayobns.com/
loans with no credit check <a href="https://paydayobns.com/">same day payday loans</a> ’
by お名前(必須) (2017-10-17 23:31) 

お名前(必須)

best payday loan website - https://loanenav.net/
canada payday loans <a href=https://loanenav.net/>payday loan lenders</a> ’
by お名前(必須) (2017-10-18 08:25) 

お名前(必須)

1st payday loan free - https://loans7foal.com/
payday loan cash advance <a href=https://loans7foal.com/>payday loans no credit check</a> ’
by お名前(必須) (2017-10-18 17:31) 

お名前(必須)

no credit check personal loans - https://loansnzyr.com/
small payday loans <a href=https://loansnzyr.com/>fast loans</a> ’
by お名前(必須) (2017-10-19 06:13) 

お名前(必須)

of payday loan
<a href="https://loansnzyr.com/">payday loans bad credit</a>
small personal loans bad credit
<a href=https://loansnzyr.com/>payday loans</a> ’
by お名前(必須) (2017-10-20 10:03) 

お名前(必須)

account now payday loans
<a href="https://loansnerc.org/">payday loans</a>
loans unemployed
<a href=https://loansnerc.org/>payday loan lenders</a> ’
by お名前(必須) (2017-10-20 12:07) 

お名前(必須)

cialis pills - http://pillsme.com/
cialis one a day review <a href="http://pillsme.com/">cialis online</a> ’
by お名前(必須) (2017-10-20 23:25) 

お名前(必須)

where to buy cialis - http://genericcialis-edviaprx.com/
drug cialis <a href="http://genericcialis-edviaprx.com/">cialis for sale</a> ’
by お名前(必須) (2017-10-24 05:32) 

お名前(必須)

buy brand cialis - http://cialisonline-vipcijffo.com/
cialis pharmacy <a href=http://cialisonline-vipcijffo.com/>buy cialis generic</a> ’
by お名前(必須) (2017-10-24 10:54) 

FfbvgprailiDL

cialis pills online
<a href="http://buycialis-menrxonil.com/">generic cialis</a>
cialis wholesale
<a href=http://buycialis-menrxonil.com/>cheap cialis</a> ’
by FfbvgprailiDL (2017-10-26 06:10) 

お名前(必須)

installment loan - http://personalloanvryn24.org/
payday loans no credit check no faxing <a href="http://personalloanvryn24.org/">short term loan</a> ’
by お名前(必須) (2017-10-30 20:36) 

お名前(必須)

payday loans no credit check online - http://paydayloansrbui365.org/
fast loans <a href=http://paydayloansrbui365.org/>cash advances</a> ’
by お名前(必須) (2017-10-31 01:47) 

お名前(必須)

bad credit loans for military payday loans for military - https://cashadmme.com
bad credit car loans <a href=https://cashadmme.com>small loans</a> ’
by お名前(必須) (2017-11-01 09:47) 

お名前(必須)

installment loans no credit check - http://personalloanplk.org
online payday loan <a href=http://personalloanplk.org>instant loans</a> ’
by お名前(必須) (2017-11-02 06:37) 

お名前(必須)

apply for payday loan - https://installmentsvfacr.com
can a payday loan garnish my wages <a href=https://installmentsvfacr.com>cash advance</a> ’
by お名前(必須) (2017-11-02 07:12) 

お名前(必須)

debt consolidation loans - https://cashadvancesquickcashrtb.org
canadian payday loan association <a href=https://cashadvancesquickcashrtb.org>cash advance credit card</a> ’
by お名前(必須) (2017-11-03 09:12) 

お名前(必須)

bad credit
http://paydayloansken.com/
$500 payday loans
<a href="http://paydayloansken.com/">cash advance payday loan</a>
a quick payday loan
by お名前(必須) (2017-11-10 02:06) 

お名前(必須)

bad credit payday loans
http://paydayloanslomonline.com/
bad credit faxless payday loans
<a href="http://paydayloanslomonline.com/">pay day loans</a>
bill consolidation loans
by お名前(必須) (2017-11-10 02:06) 

お名前(必須)

cialis 20mg price
http://buycialisenahonlined.com/
cialis uk pharmacy
<a href=http://buycialisenahonlined.com/>buy cialis</a>
is cialis safe for women
by お名前(必須) (2017-11-13 02:31) 

お名前(必須)

cialis prices
http://cialisonlinednabpill.com/
cialis daily prices
<a href=http://cialisonlinednabpill.com/>cheap generic cialis</a>
cialis 10 mg
by お名前(必須) (2017-11-13 11:10) 

お名前(必須)

payday loan
http://paydayloansken.com/
best personal loans bad credit
<a href=http://paydayloansken.com/>]payday cash advance online</a>
bad credit loans no payday loans
by お名前(必須) (2017-11-14 07:36) 

お名前(必須)

national debt relief
http://paydayloanslomonline.com/
need payday loan today
<a href="http://paydayloanslomonline.com/">]pay day loans</a>
canadian payday loans
by お名前(必須) (2017-11-14 07:38) 

コメントを書く

お名前:
URL:
コメント:
画像認証:
下の画像に表示されている文字を入力してください。

トラックバック 0

この広告は前回の更新から一定期間経過したブログに表示されています。更新すると自動で解除されます。

×

この広告は1年以上新しい記事の更新がないブログに表示されております。