Oracle Configuration

[Jim Heavey]

Hello, I convinced my company to give .Net a try. I just got through
installing VS.Net and all went well, but now I have to figure out how to
configure VS.Net to access the Oracle Tables and I a little bit lost on how
to do this.

How do I get VS.Net to see my Oracle Tables?

I configured the ODBC source for using Access and Access sees the Oracle
File Just fine. I configured the ODBC source as a "System DSN".

When I get into VS.Net and I in the sever explorer and I right click on
"Data Connections" and then select "Add Connections", I get a dialog box
which ask me for the server IP address or server name. When I provide it
with the IP address which is identified in my "TSSNAMES." file in "TOAD"
(which is the frontend that I am using for creating all my SQL statements),
it give me an error (I can't remember exactly what that error was).

Am I going about configuring Oracle correctly? What am I doing
incorrectly?

When I get it configured corretly, will I be able to see all my tables and
all of the fields, just like I do in SQL?

Any hints/suggestions you can provide would be greatly appreciated!!!

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

 

[Jim Heavey]

A correction to my prior post...

 

[Frans Bouma [C# MVP]]

Hello, I convinced my company to give .Net a try. I just got through
installing VS.Net and all went well, but now I have to figure out how to
configure VS.Net to access the Oracle Tables and I a little bit lost on
how to do this.

How do I get VS.Net to see my Oracle Tables?

I configured the ODBC source for using Access and Access sees the Oracle
File Just fine. I configured the ODBC source as a "System DSN".

When I get into VS.Net and I in the sever explorer and I right click on
"Data Connections" and then select "Add Connections", I get a dialog box
which ask me for the server IP address or server name. When I provide
it with the IP address which is identified in my "TSSNAMES." file in
"TOAD" (which is the frontend that I am using for creating all my SQL
statements), it give me an error (I can't remember exactly what that
error was).

Am I going about configuring Oracle correctly? What am I doing
incorrectly?

When I get it configured corretly, will I be able to see all my tables
and all of the fields, just like I do in SQL?

The VS.NET database explorer works with OleDb. You therefore have
to select the correct OleDb provider in the first tab (the dialog which is
popped up opens in the second tab). It can't read the toad file, you have
to specify the tsn name as if you would use sql+

FB