remote ODBC connection problem
Date: Thu, 12 Jul 2001 23:38:44 -0400
Message-ID: <3B4E6D44.B5137625_at_funsan.biomed.mcgill.ca>
Hi,
I'm having problems viewing tables on a server from a client via ODBC. The following does work:
On the server
- viewing tables locally through ODBC
On the client,
- performing queries with SQLNet
However, when the I attempt to open the table in MSAccess, I receive the error dialog message: "ODBC--call failed". I press "OK" and then get the error message "[Oracle][ODBC][Ora]ORA-00911:invalid character (#911)"
Server: NT 4.0, Oracle 8i 8.1.6
Client: Win95, Oracle client included in 8.1.6 installed
On the client machine, I have the following tnsnames.ora file: # TNSNAMES.ORA Network Configuration File: d:\Oracle\Ora81\network\admin\tnsnames.ora # Generated by Oracle configuration tools.
my.url.here =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = my_dns_here)(PORT = 1521))
)
(CONNECT_DATA =
(sid = my_sid_here)
)
)
Can anyone suggest what I might have incorrectly configured?
Thanks in advance,
Phil Received on Fri Jul 13 2001 - 05:38:44 CEST