Try this where the server is the proper entry in your tnsnames.ora file and you have the correct user name and password. I am using the M$ ODBC driver
for Oracle.

lcconstring = "driver={Microsoft ODBC for Oracle};server=tnsentry;uid=userid;pwd=password;"

lnHandle = SQLStringConnect(lcconstring)

IF lnHandle > 0
lnSQLExecVal = SQLEXEC(lnHandle, "SELECT sysdate FROM dual", 'cursorname')
ELSE
MessageBox('Connection Problem')
ENDIF


>I want to make a DSNLESS connection to an Oracle database.
>
>What is the complete syntax for doing this? Is there an Oracle driver?
>
>Thanks. Bob