MasteringVFP/12/8/2

出自VFP Wiki

在2005年2月22日 (二) 02:58由Elleryq (對話 | 貢獻)所做的修訂版本
跳轉到: 導航, 搜尋

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