I've got a problem with some odbc connection. if i run a server as service, somehow i couldn't connect to the data source which is visual foxpro something. but if i start the server manually the connection will be established.
any suggestions?
MOD - Hi, post moved to Q and A section, please read the section on how to make a bug post in the bug forum.
ODBC connection failure
-
Steve Rowe
- Site Admin
- Posts: 2455
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: ODBC connection failure
This is more than likely a security issue with the user you are running the servive as.
So your widnows id that is used when you run TM1 as an application can use the ODBC connection.
The id used to run the service cannot.
HTH
So your widnows id that is used when you run TM1 as an application can use the ODBC connection.
The id used to run the service cannot.
HTH
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
lotsaram
- MVP
- Posts: 3698
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: ODBC connection failure
I have seen this before with Foxpro and also Quickbooks and believe it is a problem with the relevant ODBC driver. ODBC works fine with TM1 running as an application but refuses to work if TM1 is running as a service.
The only solution is to find an alternative driver that actually works, but for older or less commonly used databases this might not be possible so you might be stuck.
There are alternatives but they aren't pretty. For example using a 3rd party query tool to dump CSVs of the query output or staging data in a SQL data base.
The only solution is to find an alternative driver that actually works, but for older or less commonly used databases this might not be possible so you might be stuck.
There are alternatives but they aren't pretty. For example using a 3rd party query tool to dump CSVs of the query output or staging data in a SQL data base.