Mark,

You do realize that your connection string denotes the MS Oracle ODBC driver. It looks like the guy is using the native Oracle Driver. I believe the connec strings are different. Here is an oracle string:

"DRIVER=ORACLE ODBC DRIVER;UID=TGRAM;DBQ=?;SERVER=?;PWD=?"
DBQ and the Server are the service name.


>>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
>
>SQLSTRINGCONNECT("Driver=Microsoft ODBC for Oracle;UID=MyUserID;PWD=MyPassword;Server=HostName;")
>
>The HostName has to be the alias used in the TNSNAMES.ORA file in your Oracle_Home\[OraX\]Network\Admin folder. Whatever driver you use is CASE sensitive. The one for Oracle might be "Oracle ODBC Driver". In Administrative Tools, open the "Data Sources (ODBC)" Control Panel. Then click the Drivers tab. One of those names is what you have to use for the Driver name.