TM1 Forum

Apologies if this is a basic question, but it's something I have not come up against before

On Server A, I have 64 bit TM1 9.4 MR1 installed. I have configured a 64-bit ODBC Access driver and can quite happilly connect to a database on the same server

If I move the Access DB to Server B, and reconfigure the ODBC connection on Server A to point to Server B I get a connection error when opening a TI process that uses this connection. The error message is "Unable to open connection to Database".

The username that I am logged in on can map a drive on Server B to Server A succesfully. Server A is running Windows Server 2003 R2 64 bit (SP2)

I tried to put the Access DB on to another server - Server C - and tried to connect to this instead but got the same error.

What should I be looking at to resolve this?


Thanks in advance

Anthony

if you are talking about Microsoft Access there is no 64-bt ODBC driver, unless you are using some third-party JET driver. Microsoft does not have a 64-bit ODBC driver for Access. That's one of the things you have to give up when you move to the 64-bit version of TM1.

Apologies, but I was told that we were using a 64 bit driver.

That possibly doesn't seem to be the issue really - it's more why can I connect to the database on the same server, and not on another one?

AnthonyT wrote:it's more why can I connect to the database on the same server, and not on another one?

How exactly are you connecting? Are you telling me you can run a TI process on a 64-bit TM1 service that is using a 64-bit ODBC driver into Microsoft Access on one piece of hardware but when you move it to another it doesn't work? Or did you just connect by going through the steps of setting up a DSN and doing the connection test? Are you sure you just didn't set up a 32-bit ODBC connection and then test that, outside of TM1?

so the ODBC driver works outside of TM1?

dubs wrote:so the ODBC driver works outside of TM1?

The 32-bit Access driver works inside and outside of TM1, that's what I was alluding to. Perhaps they were testing the 32-bit driver and just assumed that since they were testing it on a 64-bit machine then it was the 64-bit driver. You can run 32-bit software on a 64-bit machine. I do it all the time. However, a TI process running under the 64-bit version of TM1 can not access a 32-bit Access ODBC driver DSN without a second "gateway" machine being set up to provide the driver. I'm not going to go into that, I'm sure there are a number of posts about that topic already on the board.

all i was trying to ascertain was whether the connection had been set up properly as it sounds to me like it shouldn't