プログラミング　メモ

ADO 接続文字列

• SQLServerへ接続
  Provider=SQLOLEDB; Data Source=(Local); Initial Catalog=XXXX;User Id=sa; Password=XXXX
• WindowsログインユーザーでのSQLServer接続
  Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=XXXX;Data Source=XXXX
• テキストファイへ接続
  Provider=MSDASQL;DRIVER={Microsoft Text Driver (*.txt; *.csv)};DBQ=C:\XXXX\
• Accessへ接続
  Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\XXXX.mdb;Jet OLEDB:Database Password=XXXX:Database Locking Mode=512;
  

おまけ　"\Binn\OSQL.EXE" -E -e -o

Provider=MSDAORA; Data Source=ORACLE8i7;Persist Security Info=False;Integrated Security=yes
Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\bin\LocalAccess40.mdb
Provider=SQLOLEDB;Data Source=MySQLServer;Integrated Security=SSPI
Provider=MSDataShape.1;Persist Security Info=False;Connect Timeout=15;Data Source=192.***.***.***;User ID=sa;Password=;Initial Catalog=DB_NAME;Data Provider=SQLOLEDB.1

ASP

• Session.Contents("sample1") = "Hello World"
• Session("sample1") = "Hello World"
  

作成者情報
Copyright © 2004 EriguchiShouten All rights reserved.
Revised: 2009/02/19.