DSN-less connection with Oracle 10 drivers

[Brad]

With Oracle 9.2 drivers, this worked connection string worked in a DSN-less
connection
ODBC;DRIVER={Mi crosoft ODBC For
Oracle};Server= MyServerName;UI D=MyName;PWD=My Pwd;

However, after upgrading to Oracle 10.2, the connection string does not
work.

I don't want to go back to a regular DSN connection because of the setup
involved on many machines.

Have you solved this issue? There must be a replacement string for
{Microsoft ODBC for Oracle}

If I switch over to use the Oracle driver for 10.2, how do I find what the
string is in curly brackets?
Example: {Oracle driver for 10.2 or something else}

I originally used the string from Carl Prothman's site
http://www.carlprothman.net/Default....eFromMicrosoft

For what it's worth, a regular DSN connection does work. The issue is not
with the Oracle connection.

Brad

[engles]

On Mar 30, 12:18 pm, "Brad" <B...@donotcont actme.comwrote:

With Oracle 9.2 drivers, this worked connection string worked in a DSN-less
connection
ODBC;DRIVER={Mi crosoft ODBC For
Oracle};Server= MyServerName;UI D=MyName;PWD=My Pwd;

However, after upgrading to Oracle 10.2, the connection string does not
work.

I don't want to go back to a regular DSN connection because of the setup
involved on many machines.

Have you solved this issue? There must be a replacement string for
{Microsoft ODBC for Oracle}

If I switch over to use the Oracle driver for 10.2, how do I find what the
string is in curly brackets?
Example: {Oracle driver for 10.2 or something else}

I originally used the string from Carl Prothman's sitehttp://www.carlprothma n.net/Default.aspx?ta bid=90#ODBCDriv erForOracle...

For what it's worth, a regular DSN connection does work. The issue is not
with the Oracle connection.

Brad

Why not use DSN once, link to a table, examine the connection string
that is used and go from there?

-- Larry Engles