DSN-less connection with Oracle 10 drivers

With Oracle 9.2 drivers, this worked connection string worked in a DSN-less
connection
ODBC;DRIVER={Microsoft ODBC For
Oracle};Server=MyServerName;UID=MyName;PWD=MyPwd;

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.aspx?tabid=90#ODBCDriverForOracleFromMicrosoft

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

Brad


.

Relevant Pages

  • Re: Connecting to ODBC DB at startup
    ... Creating an Oracle connection in an independent object ... Dim cnConn As ADODB.Connection ... Dim strDB As String ...
    (comp.databases.ms-access)
  • Re: ASP.net and Oracle error System.Data.OleDb.OleDbException
    ... And are you sure your connection string is ok. ... > on our test web server, There is only one oracle home on the test server. ... > Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: oracle db connection with VB 2005 express BETA 2
    ... Each provider has other specific attributes. ... Connection String Assistant of my add-in. ... I already installed Oracle Data ...
    (microsoft.public.dotnet.languages.vb)
  • PreparedStatement, ACCESS and jdbcodbc
    ... I am using the JdbcOdbc driver, ... String driverName = "sun.jdbc.odbc.JdbcOdbcDriver"; ... Connection dbConn = DriverManager.getConnection; ...
    (comp.lang.java.databases)
  • cannot find symbol DriverManager
    ... Connection connection = null; ... String driverName = "oracle.jdbc.driver.OracleDriver"; ... String username = "scott"; ... // Could not find the database driver ...
    (comp.lang.java.programmer)