Hello all. I just installed Oracle 10g developer tools on a machine
running XP Pro and Office XP. Before this I had just the Oracle 9
client installed. I the previous configuration, I was able to access
any of the Oracle tables on another machine but now I am having
problems. Unfortunately, I don't remember the correct syntax for the
ODBC connect string and I am hoping that is my whole problem.
I am trying to connect to an Oracle 9 database on a VMS server. Here's
the info:
VMS machine:
-IP Address 192.168.0.250
-Database global name: db1.mcbill
PC:
-IP Address: 192.168.0.202
-Win XP Pro
-Office XP
When I run the linked table manager and then type username, password
and server I get an Odbc call failed error. Here is what I tried:
username: scott
password: tiger
For the server, I've tried the server's IP address, db1, db1.mcbill,
db********@192.168.0.250, etc.
Can anyone help?
BTW, I know this is not a connectivity issue as I can connect from this
PC using Oracle forms, SQLPlus and Toad.
Here is my tnsnames.ora file:
# TNSNAMES.ORA Network Configuration File:
c:\oracle\ora10g\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
DB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.250)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db1.mcbill)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PLSExtProc)
)
)
Thanks.
Bill