I have connected to sqlexpress 2008 using ODBC 3.5 and successfully imported and modelled them physically, in business model and in presentation layer....
However, the connection pool loses the user name, and even though I was able to import the tables when I try to view data or update row count the connection pool fails with ODBC error state 37000, code 102.
Similarly if I make the repository live I get odbc connection errors to all objects.
If I reuse the same connection pool details to import more tables the connection works fine.
The odbc is via a system dsn using Merant OEM 5.3 32-bit SQL Server Wire Protocol
The security for sqlexpress is using windows integrated security.
My obiee version is 220.127.116.11.0
Any suggestions please??
I just had the same issue. I had the DSN set to use integrated MS security. (Works fine for metadata imports). I changed that to user input, saved the user/pass, and then checked fully qualified in the connection pool definition. Now I can view data and update row counts against MSSQLServer 2008.