>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

Try to create a new dsn by doing something like dsn=sqlstringconnect() and creating the dsn on the fly.