MasteringVFP/12/8/2

出自VFP Wiki

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