全套课件 《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 MS Remote方式 (1)．MS Remote - Access (Jet) 1）ODBC DSN oConn.Open Provider=MS Remote; _