Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access Oracle Database
Message
From
04/12/2008 02:36:36
 
 
To
04/12/2008 02:14:51
Ed Hizon
Skswood Sdn. Bhd
Kuala Belait, Brunei
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01365439
Message ID:
01365450
Views:
26
>Drivers already been installed i tried to use this coding with foxpro and could not connect giving a value of -1:
>
>lcDSNLess="driver = {Microsoft ODBC for Oracle};server=dbserver01;database=oracledb;uid=sys;pwd=monitor"
>
>lnConnHandle=SQLSTRINGCONNECT(m.lcDSNLess)
>
>Anything wrong with the above coding.
>
>Ed

And what AERROR() gives to you?
lcDSNLess="driver = {Microsoft ODBC for Oracle};server=dbserver01;database=oracledb;uid=sys;pwd=monitor" 

lnConnHandle=SQLSTRINGCONNECT(m.lcDSNLess)
IF lnConnHandle < 0
   AERROR(laError)
   MessageBox(laError[1,2])
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform