I've been trying to figure out a way to connect to an Oracle Database using no DSN without success. I seem to continue to miss some information. Does anyone have any ideas?

This is what I've been trying:

x = SQLSTRINGCONNECT("DRIVER=ORACLE ODBC DRIVER;server = ids.xxx.state.xx.us;User ID=dxxreh1;password=xxx")

TIA,

Richard