Page 1 of 1
ODBC connection failure
Posted: Thu Jul 16, 2009 9:31 am
by gs1hu
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.
Re: ODBC connection failure
Posted: Thu Jul 16, 2009 10:04 am
by Steve Rowe
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
Re: ODBC connection failure
Posted: Thu Jul 16, 2009 1:23 pm
by lotsaram
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.