MasteringVFP/12/8/2

出自VFP Wiki

(修訂版本間差異)
跳轉到: 導航, 搜尋
(使用Oracle提供的ODBC Driver)
第13行: 第13行:
</pre>
</pre>
=====使用Oracle提供的ODBC Driver=====
=====使用Oracle提供的ODBC Driver=====
-
</pre>
+
<pre>
&& === ODBC Driver for Oracle - from Oracle ====
&& === ODBC Driver for Oracle - from Oracle ====
-
 
Local ConnectString AS String  
Local ConnectString AS String  
-
 
Public Connected AS Integer
Public Connected AS Integer
ConnectString = "Driver={Oracle ODBC Driver};Dbq=myDBName;Uid=myUsername;Pwd=myPassword"
ConnectString = "Driver={Oracle ODBC Driver};Dbq=myDBName;Uid=myUsername;Pwd=myPassword"
-
 
Connected = SQLSTRINGCONNECT(ConnectString)
Connected = SQLSTRINGCONNECT(ConnectString)
</pre>
</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
&& === 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)