Odbc excel ドライバ 64
![odbc excel ドライバ 64 odbc excel ドライバ 64](http://www.ujp.jp/modules/tech/index.php/System/RDBMS/ODBC_Oracle9i/ODBC_Oracle9i03.gif)
The top one is the 32 bit driver, the bottom one is the 64 bit driver. Make sure you download the top one that is named “AccessDatabaseEngine.exe” and NOT the second one that says “AccessDatabaseEngine_X64.exe”. When you click on the “Download” button it will ask you what version.
#ODBC EXCEL ドライバ 64 DRIVERS#
You can download the 32 bit Office 2010 drivers from here Microsoft Excel 2010 Drivers
#ODBC EXCEL ドライバ 64 HOW TO#
Is account security a cause for "SQL Statement failed" ( Account as in Tm1 service account ) ?Īny ideas on how to investigate this further would be appreciated.If you are on SmartConnect 2018 or lower you need to install 32 Bit Excel/Office ODBC Drivers on each machine with a SmartConnect client on it. ( Is that the pupose of the new items of Tm1 config file relating to ODBC ?) I would like to understand why TM1 did not use the 64 bits set of ODBC connections by default but instead try to get the list from the 32bits interface ?Īlso has anybody an idea how to "connect" TI to the ODBC sources defined in the 64bit interface for ODBC connections ? I suspected security setting of the account used in Production but i think it that was the case i could not query the SQL servers using excel in the prod server as described above.Ĭould somebody confirm ( i read the FAQs) that TM1 64bits versions installed on 64bits OS has to use the ODBC set up using the 64bit interface ?
![odbc excel ドライバ 64 odbc excel ドライバ 64](https://kajimublog.com/wp-content/uploads/2020/03/67_odbc画面-1024x576.png)
The windows account used to run and install the test server is different from the account that is used to run our productiono envronment describe above. In my Dev environment the test TM1 server has been installed exactly the same method, refers to ODBC connections 32bits and is able to connect and issue the sql statements. The Tm1 Log file show the following message :Į16) Cannot connect to ODBC data source "triprd" IM002 Data source name not found and no default driver specified.Ġ8003 Connection not open ( I suppose this is due to the fact that i am using a 64bit version of Tm1 and therefore should not use 32bits ODBC ). I can browse to a source configurated using the 32bits interface but now i get the error "SQL statements fails". No ODBC links were configured using 32bits so it explain why the list of ODBC sources for TI was blank.ĥ - I tryed to configure to ODBC links in the 32 bit interface in order to test if TI would be able to use that. The existing ODBC connections were not modified and are defined using the 64bit interface ( Windows/Syswow64/odbcad.exe )ġ - When i test the ODBC connections (using the same account that is used to run the Tm1 install / runs the tm1 services) throught this interface, i can connect succesfully to my sources.Ģ - When i test the ODBC connection (using the same account that is used to run the Tm1 install / runs the tm1 services) throught Excel using external data sources, the configurated ODBC connections appears and enable to issue SQL query to the sources.ģ - When i test the connection (using the same account that is used to run the Tm install / runs the tm1 services) throught Tm1 TI the first instance i had the message "umable to connect to database".Ĥ - When i try to browse to the existing ODBC datasources, the list is blank ( only a back up exec catalog is in the list).Īfter investigation, I finnally realised that TI was using the list of ODBC link provided from the 32bits ODBC driver configuration ( Windows/System32/odbcad.exe ). I realised our ODBC connections to SQL servers have an issue.
![odbc excel ドライバ 64 odbc excel ドライバ 64](https://www.still.co.jp/main/still/faq/C0/A17_image001.jpg)
I have upgraded my Tm1 version from 9.1 sp3 (64bits) to 9.4MR1 FP3.