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