Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Access Oracle Database
Message
 
À
04/12/2008 02:14:51
Ed Hizon
Skswood Sdn. Bhd
Kuala Belait, Brunei
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01365439
Message ID:
01365450
Vues:
27
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform