Oracle Connection

[Jim Heavey]

If I am going to connect to an oracle database - Do I have to configure an
ODBC Datasource on my machine (Control Panel/Admin Tools/Data Sources
(ODBC) ?

My machine currently has Oracle configured here for, but for a "System
DSN"...is this what I need or do I need "User" or "File" or does it matter?
I had to have this in order for Access to be able to talk to Oracle, which
I am guessing is for OLEDB.

Does Microsoft Oracle Provider use this "System DSN" or do I need to
configure something else for that?

Thanks in advance for your assistance!!!!!!

 

[Paul Clement]

¤ If I am going to connect to an oracle database - Do I have to configure an
¤ ODBC Datasource on my machine (Control Panel/Admin Tools/Data Sources
¤ (ODBC) ?
¤
¤ My machine currently has Oracle configured here for, but for a "System
¤ DSN"...is this what I need or do I need "User" or "File" or does it matter?
¤ I had to have this in order for Access to be able to talk to Oracle, which
¤ I am guessing is for OLEDB.
¤
¤ Does Microsoft Oracle Provider use this "System DSN" or do I need to
¤ configure something else for that?
¤

The Server Explorer in .NET supports the OLEDB providers (not ODBC) so you would need to use
Microsoft's or Oracle's to create a new a new connection. Don't believe you need a DSN, just a
server name that is configured in your TNSNAMES.ORA file.

Frankly, I don't think this utility is very useful unless you are just viewing data, using an OLEDB
driver for your application, or using SQL Server. It doesn't support the native .NET providers for
Oracle.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)