System DSN towards MS Access on a 64-bits server

[Wim Gielis]

Hello

On a 64-bits environment:

Does someone know how you can use a system DSN with an ODBC driver towards for instance a MS Access database?

When I try to do this, in the list of drivers there's only 2 SQL related drivers, nothing else. In 32-bits, I am used to see a full list of drivers, incl. MS Access drivers in several languages.

Thanks for any feedback,

Wim

[LoadzaGrunt]

On a 64-bits environment:

Does someone know how you can use a system DSN with an ODBC driver towards for instance a MS Access database?

You need a 64-bit driver. Mircosoft haven't issued a 64-bit driver for Access and, as I heard, aren't likely to. They'd prefer you to use SQL Server Express.

[Wim Gielis]

Thank you for the information Loadzagrunt.

Just a follow-up question. If we want to connect towards a SQL-like Accounting system on a 64bits server, do you think that would work? Does anyone have experience with this?

Sorry for the lack of details, perhaps see http://www.bob-50.be (a website in Dutch). Currently, a 32 bits server with TM1 8.3.4 can connect to BOB and BOB50, but I'm unsure whether a 64 bits server will.

Thanks for any feedback,

Wim

[LoadzaGrunt]

64 bit TM1 on a 64 bit box pre-TM1 9.4 can connect to 32-bit ODBC sources if you have configured the Axnet service (ODBC gateway). You need to choose this when you install TM1. You also need to run odbcad32.exe in the C:\WINDOWS\SysWow64 folder instead of the normal one (accessed via Administrative tools). I agree that RTFM doesn't help much on this point.

From 9.4 onward (IIUC) the ODBC Gateway is no longer supported and the official line is that you need to get a 64-bit ODBC driver. Most of the main players have these but some of the others don't. Your first choice sounds like contacting the BOB/BOB50 vendor and/or partners and asking direct for the driver. If that comes up blank then Google. If that comes up blank and you must use TM1 9.4 in a 64-bit environment, then I would opt to stage the BOB/BOB50 data in SQL Server and connect TM1 to the data that aways.

[Wim Gielis]

Many thanks for the information.

You're right, this kind of information is not easily found.

Thank you for sharing.

Wim

[Kaveenga]

Hi All,

Is there any way for TM1 (9.5.2 64-bit) running on a Window Server 2008 (64-bit) use a 32-bit Access 2010 db as a data source in TI?

Would appreciate any suggestions.

Thanks in advance

Kavee

[Steve Rowe]

Pretty sure the answer is no if you mean direct via ODBC. You can of course push out text files for TI from the access DB or port your access to another tool whose authors have bothered to release a 64 bit ODBC driver.

I'm suprised that no third part has released a 64 bit access ODBC driver but I've not heard of one...

[Kaveenga]

Pretty sure the answer is no if you mean direct via ODBC. You can of course push out text files for TI from the access DB or port your access to another tool whose authors have bothered to release a 64 bit ODBC driver.

Actually I want to push text into Access so that the TM1 drill function can return values back to users via RETURNSQLTABLEHANDLE.

[moby91]

What about the method outlined in the thread

http://www.tm1forum.com/viewtopic.php?f=3&t=6448#p26818
Re: Excel ODBC drivers in 64 bit Tm1 9.5.2 Server

?

[Kaveenga]

Thanks Moby I will look into this. However, I am looking at installing Access 2010 64 bit on the TM1 server and see if it works.

[Kaveenga]

Thanks Moby I will look into this. However, I am looking at installing Access 2010 64 bit on the TM1 server and see if it works.