>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.
Mark McCasland
Midlothian, TX USA