Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ODBC
You may not have defined (ODBC Admin) the ODBC connection properly, or,
you're using Microsoft's ODBC driver(s) which may work on a Oracle 7
instance, but not an 8.
Double-check the ODBC setup or, although dog-slow, try Oracle's;
John Duran <d3plan_at_hotmail.com> wrote in message
news:7uqjge$ghv$1_at_nnrp1.deja.com...
> I need to connect MS Access 2000 to my Oracle 8 database running on Sun
> SPARC with Solaris 2.6
>
> I have tried every combination that I can think of to get a connection
> but fail to do so.
>
> I have various Net8 connections that work fine including TOAD, ERWIN
> etc that are all direct
>
> What do I need to get the ORACLE8 ODBC to work? Following are the
> errors I keep getting:
>
> "ODBC-call failed.
> [Oracle][ODBC][ORA]: NETCMN: invalid driver designator
> (#6401)[Microsoft][ODBC Driver Manager] Connection
> not open (#0)"
>
> I have used the service name from Net 8 to no use, I have used the
> IP:PORT:SID just not sure what it looks for - the Oracle instructions
> on using the ODBC driver are useless and there is no test function
> prior to using the setting.
>
> Any help or reference source with sample setups would be apprectiated.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Oct 25 1999 - 13:40:10 CDT