Re: DSN-less connection with Oracle 10 drivers
- From: engles@xxxxxxxxxxxx
- Date: 30 Mar 2007 23:30:09 -0700
On Mar 30, 12:18 pm, "Brad" <B...@xxxxxxxxxxxxxxxxxx> wrote:
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 sitehttp://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForOracle...
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
.
- References:
- DSN-less connection with Oracle 10 drivers
- From: Brad
- DSN-less connection with Oracle 10 drivers
- Prev by Date: Re: Delete Record - DAO to ADO
- Next by Date: form manipulation
- Previous by thread: DSN-less connection with Oracle 10 drivers
- Next by thread: VB Code to change the Allow Additions Property
- Index(es):
Relevant Pages
|
