Oracle SQL*Net

[BIS]

Hi All,
OK, I am a newbie with ODBC. I hope someone somewhere can help me out with this, it is probably really simple. I have an Oracle database (8.1.5) running, and I want to link to it via ODBC remotely. It is my undertanding that to use the oracle ODBC drivers I also need SQL*Net running, which I have. DOes anybody know anything about this? I assume I will need a desktop client as well, but I am not really sure. Any help, or pointers in the right direction would be appreciated.

 

[Megahurtz]

I am curious too I need to make an ODBC Connection to an Oracle Database (7.1.3)

I think I have something, but can't get it to work correctly yet
Oracle Connect String

Personal Oracle Connect String
If you want to connect to a local installation of Personal Oracle, you can use 2: to indicate that the driver should connect to Personal Oracle. If you want to connect to a remote server, use SQL*Net V2 connect string.

SQL*Net V2 Connect String Alias
To create an alias, use SQL*Net Easy Configuration Utility. This utility is installed when you install SQL*Net V2. For more information on SQL*Net Easy Configuration, refer to the on line help provided with it. SQL*Net Easy Configuration creates an entry in TNSNAMES.ORA file. The entry for an alias will look like:

HR.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = HRSRVR)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = HRSRVR)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)

Note: If you are having a local installation of the Oracle7 database, you can use 2: instead of SQL*Net alias. This will bypass SQL*Net and connect to the local database.

For more information, see the SQL*Net documentation.

 

[BIS]

Thanks Megahurtz,

I was looking at that as well in the help files. I get stuck on the remote part.I want to connect via TCP/IP, but creating the alias you need the Oracle SID - I can't figure out how to get this. The oracle db is on an SCO unix box.

 

[jjrrgg01]

Hi All!!!
I am interesting in connecting an application to an Oracle DB, like you both are. I need to connect a VB application in a Windows enviroment using the VB Data Environment to an Oracle 7 placed in an AIX-Unix enviroment. What I get till now is in the following address:

http://www.recital.com/solutions_odbc.htm

there you can download an ODBC that lets do what we need.
I download the trial one, but I did not have time to test it. If you can download it too and test it, please let us know your comments, I will try to test it by the end of the next week. I know that there are other address where free ODBC can be downloaded, when get the address I will post them here.
Well keep in contact.

Julio G.(jjrrgg01)