MasteringVFP/12/8/2
出自VFP Wiki
(修訂版本間差異)
小 (revert) |
|||
第1行: | 第1行: | ||
- | + | ====連結到 Oracle 的方法==== | |
- | + | =====使用Microsoft提供的ODBC Driver===== | |
- | + | <pre> | |
- | + | && ==ODBC Driver for Oracle - from Microsoft For the current Oracle ODBC Driver from Microsoft ==== | |
- | + | Local ConnectString AS String | |
- | + | Public Connected AS Integer | |
- | + | ||
- | + | ||
+ | ConnectString = "Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=myUsername;Pwd=myPassword" | ||
+ | Connected = SQLSTRINGCONNECT(ConnectString) | ||
+ | </pre> | ||
- | + | =====使用Oracle提供的ODBC Driver===== | |
- | + | <pre> | |
- | + | && === ODBC Driver for Oracle - from Oracle ==== | |
- | + | Local ConnectString AS String | |
- | + | Public Connected AS Integer | |
- | + | ||
- | + | ||
- | + | ||
- | + | ConnectString = "Driver={Oracle ODBC Driver};Dbq=myDBName;Uid=myUsername;Pwd=myPassword" | |
- | + | Connected = SQLSTRINGCONNECT(ConnectString) | |
- | + | </pre> | |
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + |
在2005年4月3日 (日) 08:02所做的修訂版本
連結到 Oracle 的方法
使用Microsoft提供的ODBC Driver
&& ==ODBC Driver for Oracle - from Microsoft For the current Oracle ODBC Driver from Microsoft ==== Local ConnectString AS String Public Connected AS Integer ConnectString = "Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=myUsername;Pwd=myPassword" Connected = SQLSTRINGCONNECT(ConnectString)
使用Oracle提供的ODBC Driver
&& === ODBC Driver for Oracle - from Oracle ==== Local ConnectString AS String Public Connected AS Integer ConnectString = "Driver={Oracle ODBC Driver};Dbq=myDBName;Uid=myUsername;Pwd=myPassword" Connected = SQLSTRINGCONNECT(ConnectString)