Re: remote ODBC connection problem

Oracle's ODBC driver is buggy. Use Microsoft's instead. "Phil Warrick" <warrick_at_funsan.biomed.mcgill.ca> wrote in message news: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
> - 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))
> )
> (CONNECT_DATA =
> (sid = my_sid_here)
> )
> )
>
>
> Can anyone suggest what I might have incorrectly configured?
>
> Thanks in advance,
>
> Phil
>
Received on Sat Jul 14 2001 - 16:35:09 CEST