Manohar,<br>
<br>
<prescript><br>
I came back and added this after writing all the stuff below - well, I pasted a lot of it, but same thing <grin!>. I really don't mind if you need to contact me during working hours, assuming that you and I have any in common. I know just how frustrating this can be - it took me six months at work to get a couple of people to explain to me _how_ to set this up instead of having them come by when I was gone and setting it up for me! Getting a good answer on the ODBC/Oracle interface simply is not an easy task - Oracle DBAs say its a MS (ODBC) problem, and ODBC techs say its an Oracle problem - darn few will admit that it's an interface problem that involves several disciplines - particularly if they don't know one of those disciplines very well <grin!>.<br>
</prescript><br>
<br>
Don't have the whole bit here right now, but you need to use the Oracle installer and create a TNSNames piece for the ODBC connection. To this end, you must have installed SQL*Net when you installed the Oracle ODBC drivers. Then you can use the SQL Net Easy Configuration utility.<br>
<br>
If you really understand the Oracle stuff and its CLI, you may be able to 'munge' the TNSNames file.<br>
<br>
On this machine, the file is <br>
C:\Aps\OraWin95\Network\Admin\TNSNAMES.ORA<br>
<br>
This is the beginning of the TNSNames file<br>
__________________________________________________<br>
---<br>
#This is a SQL*Net Configuration file generated by SQL*Net Easy Configuration.<br>
#Attention: Do not modify this file yourself.<br>
#If you do, your SQL*Net Easy Configuration may not function properly.<br>
<br>
Example1.world = <br>
(DESCRIPTION = <br>
(ADDRESS_LIST = <br>
(ADDRESS = <br>
(COMMUNITY = tcp.world)<br>
(PROTOCOL = TCP)<br>
(Host = Production1)<br>
(Port = 1521)<br>
)<br>
)<br>
(CONNECT_DATA = (SID = SID1)<br>
)<br>
)<br>
_____________________________________________<br>
<br>
This next is a real connection to an Oracle instance that I use at work. Pardon me that the server information is obfuscated - corporate rules, donchano - but everything else is verbatim.<br>
<br>
_______________________________________<br>
FMBC.world = <br>
(DESCRIPTION = <br>
(ADDRESS_LIST = <br>
(ADDRESS = <br>
(COMMUNITY = tcp.world)<br>
(PROTOCOL = TCP)<br>
(Host = servername.companyname.com)<br>
(Port = 1521)<br>
)<br>
(ADDRESS = <br>
(COMMUNITY = tcp.world)<br>
(PROTOCOL = TCP)<br>
(Host = servername.companyname.com)<br>
(Port = 1526)<br>
)<br>
)<br>
(CONNECT_DATA = (SID = fmba)<br>
)<br>
)<br>
___________________________________________<br>
<br>
The port numbers are consistent throughout the file, so I assume they are standard Oracle configuration. They are not version dependent, at least not since version 7.0, 'cause I've used the same connection from 7.0, 7.1, 7.3, to 8.0. Don't remember a 7.2, bet there may have been one. Biggest problem I've had to date has been when the Oracle Listener was the wrong version or was down. (As near as I can tell, the 'listener' is a server-side component that waits for Oracle SQL statements.)<br>
<br>
The ODBC side of this is simplistic in the extreme (is that possible? or just redundant? <grin!>
. The only critical item is that the SQL*Net Connect String in the ODBC configuration _must_ be the same as the TNSNames name (the FMBC.world above - FMBC is the SQL*Net Connect String).<br>
<br>
If this doesn't seem clear - which is likely - ask again and I'll try to make more sense. If you're really in a bind, you can get my e-mail from my profile. Mail me at work if need be. My working hours are 0600-1700 CDT (US), which is -6 GMT (or Zulu).<br>
<br>
Make a good day . . .<br>
. . . barn<br>
<br>
