>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.