Hi Joel,
To get connection string you can create a File DSN and open it in any text editor.
>Hi,
>
>Does anyone user the SQLSTRINGCONNECT function to connect to an Oracle Database, if so what is the format of the string needed. I guessed on the following, based on what is used to connect to SQL Server
>
>lnConnect = SQLSTRINGCONNECT("Driver=Oracle ODBC Driver;Server=Phoenix;UID=MyUser;PWD=MyPassword;Database=kan2")
>
>but I always receive a dialog box requesting Service name, User name and Password, although the username and password boxes are prepopulated with the correct info.
>
>Anyone know where I am going wrong?
>
>Thanks,
>
>Joel
--sb--