MasteringVFP/12/8/2

出自VFP Wiki

(修訂版本間差異)
跳轉到: 導航, 搜尋
第1行: 第1行:
 +
====連結到 Oracle 的方法====
 +
=====使用Microsoft提供的ODBC Driver=====
 +
<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 ====
第8行: 第11行:
Connected = SQLSTRINGCONNECT(ConnectString)
Connected = SQLSTRINGCONNECT(ConnectString)
-
 
+
</pre>
-
 
+
=====使用Oracle提供的ODBC Driver=====
 +
</pre>
&& === ODBC Driver for Oracle - from Oracle ====
&& === ODBC Driver for Oracle - from Oracle ====
第19行: 第23行:
Connected = SQLSTRINGCONNECT(ConnectString)
Connected = SQLSTRINGCONNECT(ConnectString)
 +
</pre>

在2005年2月22日 (二) 02:58所做的修訂版本

連結到 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

</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>