Go to http://www.mctweedle.com and click the FoxPro Tools link. There you can get my ODBC DSN Class [free] and my VFP/Oracle white paper.

Otherwise, you can create a connection with:

lnHandle = sqlstringconnect('Driver=Microsoft ODBC for Oracle;UID=ggldev;PWD=gglpass;Server=ggserv;')

However, any remote views you have will not be able to use this connection.
To do that AND use the same SHARED connection from a view for SPT:

lcConnString = 'Driver=Microsoft ODBC for Oracle;' ;
    + 'UID=ggldev;PWD=gglpass;Server=ggserv;'

USE SOME_DUMMY_VIEW_TO_ORACLE ;
    CONNSTRING lcCOnnString

goApp.nOracleHandle = CURSORGETPROP("ConnectHandle", SOME_DUMMY_VIEW_TO_ORACLE)

The above code is for VFP7 and beyond.the CONNSTRING clause was not available prior to version 7.

>I am planning to connect to the Oracle database from visual foxpro application.
>
>Can somebody help me how to connect to oracle datbase.
>
>username: ggldev
>password: gglpass
>domain: ggserv
>
>Thank you very much,
>
>Rajender