全套课件 《Web数据库技术》.ppt

"Exclusive=No"? DBF文件不是一个标准的数据库文件，只相当于标准数据库文件中的一个数据表，所以为了使用DBF文件，采用把所有的DBF文件放在一个目录下，这样把目录名看成标准数据中的数据库表，每一个DBF文件相当于标准数据库的数据表。 (9)．ODBC Driver for Excel oConn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _ "DriverId=790;" & _ "Dbq=c:\somepath\mySpreadsheet.xls;" & _ "DefaultDir=c:\somepath"? 将Excel97或Excel2000生成的XLS文件（book）看成一个数据库，其中的每一个工作表(sheet)看成数据库表。 3 OLE DB Providers方法 (1)．OLE DB connection for Access oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _ "Data Source= c:\\somepath\\dbname.mdb;" & _ "User Id=myUsername;" & _ "Password=myPassword" (2)．OLE DB Provider for Informix: 1）Informix 3.30: oConn.Open "Dsn='';Driver={INFORMIX 3.30 32 BIT};Host=hostname; " & _ "Server=myserver;Service=service- name;Protocol=olsoctcp; " & _ "Database=mydb;UID=username;PWD=myPwd " 2）Informix-CLI 2.5: oConn.Open "Driver={Informix-CLI 2.5 (32 Bit)};Server=myserver; " & _ "Database=mydb;Uid=username;Pwd=myPwd" (3)．OLE DB Provider for MySQL oConn.Open "Provider=MySQLProv;" & _ "Data Source=mySQLDB;" & _ "User Id=myUsername;" & _ "Password=myPassword" (4)．OLE DB Provider for Oracle (from Oracle) oConn.Open "Provider=OraOLEDB.Oracle;" & _ "Data Source=MyOracleDB;" & _ "User Id=myUsername;" & _ "Password=myPassword" (5)．OLE DB Provider for IBM DB2 1）TCP/IP oConn.Open "Provider=DB2OLEDB;Network Transport Library=TCPIP; " & _ "NetworkAddress=XXX.XXX.XXX.XXX;InitialCatalog=MyCtlg; " & _ "Package Collection=MyPkgCol;Default Schema=Schema; " & _ "User ID=MyUser; Password=MyPW" 2）APPC oConn.Open "Provider=DB2OLEDB;APPC Local LU Alias=MyAlias; " & _ "APPC Remote LU Alias=MyRemote;InitialCatalog=MyCtlg; " & _ "Package Collection=MyPkgCol;Default Schema=Schema; " & _ "User ID=MyUser;Password=MyPW" (6)．OLE DB Provider for EXCEL: oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _ "Data Source=C:\MyExcel.xls;Extended Properties=Excel 9.0;HDR=Yes;" 4