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