Connecting to Orable DB with Microsoft ODBC crab.dae[ at ]gmail.com 13.07.2006 14:14:12 Sorry for the cross post but I wasn't sure which group might be able to help. I'm having a problem with connecting to Oracle DB using MS Access. I setup a system DNS but when I try to connect, I get the below error: ODBC call failed. [Microsoft][ODBC driver for Oracle][Oracle]ORA-06401: NETCMN: invalid driver designator (#6401) [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed IM006 0 [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (#0) I can make a connection using Toad, but I need to connect with MS SQL and MS Access and becuase I've never had to connect to an Oracle DB with MS products, I'm really clueless. Thanks folks!!

Re: Connecting to Orable DB with Microsoft ODBC "sybrandb" <sybrandb[ at ]gmail.com> 13.07.2006 14:20:20 crab....[ at ]gmail.com wrote: [Quoted Text] > Sorry for the cross post but I wasn't sure which group might be able to > help. > > I'm having a problem with connecting to Oracle DB using MS Access. I > setup a system DNS but when I try to connect, I get the below error: > > ODBC call failed. > > [Microsoft][ODBC driver for Oracle][Oracle]ORA-06401: NETCMN: invalid > driver designator (#6401) > [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed > IM006 0 [Microsoft][ODBC Driver Manager] > Driver's SQLSetConnectAttr failed (#0) > > > I can make a connection using Toad, but I need to connect with MS SQL > and MS Access and becuase I've never had to connect to an Oracle DB > with MS products, I'm really clueless. > > Thanks folks!! Does your database have a version? Does your ODBC driver has a version? Did you install the Oracle client on your PC? If so what is the version? Did you set up a tnsnames.ora? If so, post it. Also post the DSN The error message is an error message from a version which was desupported prior to 1994, and probably you didn't dig up such a paleolithic system. -- Sybrand Bakker Senior Oracle DBA

Re: Connecting to Orable DB with Microsoft ODBC "Charles Hooper" <hooperc2000[ at ]yahoo.com> 13.07.2006 14:52:58 crab.dae[ at ]gmail.com wrote: [Quoted Text] > Sorry for the cross post but I wasn't sure which group might be able to > help. > > I'm having a problem with connecting to Oracle DB using MS Access. I > setup a system DNS but when I try to connect, I get the below error: > > ODBC call failed. > > [Microsoft][ODBC driver for Oracle][Oracle]ORA-06401: NETCMN: invalid > driver designator (#6401) > [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed > IM006 0 [Microsoft][ODBC Driver Manager] > Driver's SQLSetConnectAttr failed (#0) > > > I can make a connection using Toad, but I need to connect with MS SQL > and MS Access and becuase I've never had to connect to an Oracle DB > with MS products, I'm really clueless. > > Thanks folks!! Use the Oracle ODBC driver from the Oracle client install, rather than the Microsoft ODBC driver for Oracle. There are work-arounds: http://www.orafaq.com/forum/t/37835/2/ Charles Hooper PC Support Specialist K&M Machine-Fabricating, Inc.