This content has been marked as final. Show 3 replies
As long as the ODBC connection tests correctly, there should be no problems logging into the EIS catalog. The only thing I can see that might have gone astray is the Server name you are using.
" I enter the correct EIS server name" is not clear. Are you using the SQLServer2008 name or the Essbase server name? It should be the Essbase server name.
It's no surprise that you had to type the ODBC DSN name into the window the first time. EIS is not smart enough to go looking for names. It is somewhat obsolete.
Hope this helps,
Yes, I am using the Essbase server name. The only other thing I can think of is the driver version. I just used the one called "SQL Server" which is what the install guide said. However, this is the 9.3.1 guide, so may be outdated info for 9.3.3. I did not use the DataDirect 6.0 drivers that were installed when I installed the Integration Services software on the server. Is it possible I need to download Microsoft SQL Server 2008 Native Client 10.0 and install that on the server? That is the other thing. There currently is no SQL client software installed on the EIS server. Could that be the problem? Thanks
I found the problem. We run Essbase/EIS on 64 bit server. I was using the standard ODBC Data Source Administrator from the Start/Programs to create my data source. However, this uses 32bit drivers. I needed to launch the data source admin from c:/windows/syswow64 which will use 64 bit drivers. Once I did this, I was able to create the Metadata Catalog. Info on this issue can be found in the following article: Troubleshooting Problems with Essbase SQL Interface and SQL / ODBC Data Sources [ID 1268756.1]