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
- in MSAccess "Get External Data", can use an ODBC DataSource to link to
a table on the server
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))
)