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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only