Driver s sqlsetconnectattr failed excel

 · The error presents itself when we open Excel (on the new PCs) goto the 'Data' menu, select 'Import external data' (the Choose Datasource Window appears), goto 'Queries' tab, select an existing query from the list and click 'Open' then we get the following errors: Insufficient Connection Information was supplied Driver's SQLSetConnectAttr failed.  · [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 3 [Oracle][ODBC][Ora]ORA TNS:Connect timeout occurred ERROR [IM] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed.  · I have created an ODBC connection for oracle using "Microsoft ODBC for Oracle" driver under user DSN. I can connect to oracle 10g using SQL developer but when i try to connect via ODBC its saying [Microsoft][ODBC DRIVER Manager] Driver's SQLSetConnectAttr Failed. I have tried following code for www.doorway.rus: 2.

The Driver Manager's SQLSetConnectAttr will not accept SQL_ATTR_DBC_INFO_TOKEN, since an application should not set this attribute. If a driver returns SQL_ERROR after setting SQL_ATTR_DBC_INFO_TOKEN, the connection just obtained from the pool will be freed. The Driver Manager will then try to obtain another connection from the pool. [Microsoft][ODBC DRIVER Manager] Driver's SQLSetConnectAttr Failed I have tried following code for connecting. data_src = Oracle Database = sys Uid = pwd = Set cn=new www.doorway.rution www.doorway.ru "DataSource=" + data_src + ";" + Database + "; persist security Infor = True; UserID= " + Uid + "; Password=" + pwd + "; SessionMode = ANSI;". The error presents itself when we open Excel (on the new PCs) goto the 'Data' menu, select 'Import external data' (the Choose Datasource Window appears), goto 'Queries' tab, select an existing query from the list and click 'Open' then we get the following errors: Insufficient Connection Information was supplied Driver's SQLSetConnectAttr failed.

To resolve this error, contact the workbook or data source publisher or the Tableau Server administrator to get the DSN and ODBC driver information that matches. Database Connector Error: IM[Microsoft][ODBC Driver Manager] Driver's Perhaps your Excel AND your ODBC drivers are both 64 bit along. Step by step tutorial on how to install an odbc driver for Microsoft access/excel in windows 7 /