Trouble With A Windows Service Accessing MAS90 Tables

[mcmsweet]

Hello Tek-Tips,

I am stumped with this "ERROR [S0000] [ProvideX][ODBC Driver] [FILEIO]Table is not accessible" I have read many of the posts here pertaining to this error and have gotten nowhere.

Essentially I have a windows service I have built (in VB.NET) that logs in using a specified windows account which has privileges to access MAS90, the service attempts to access the MAS90 data and move it to SQL Server. When the service tries to access the MAS90 tables I get:

ERROR [S0000] [ProvideX][ODBC Driver][FILEIO]Table is not accessible

without fail.

I have tried mirroring the service as a windows application and the application works like a charm when I log into the server as the specified MAS90 data user.

From all of my research and debugging it seems like MAS90 simply will not allow access by a service. I hope someone here can tell me this is not so!

Thanks in advance for any help! (Let me know if any additional information is required to solve this problem)

I am using a VB.NET windows service with ProvideX ODBC Datasource.

 

[MASGuy]

If all of your research indicates that MAS90 cannot be accessed by a service then I doubt anything we say will change that. Are you trying to pull all tables or just one or two specific ones. I do know there is an issue is you try to access all at once because some do not exist until reports are run.

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[mcmsweet]

Thanks for your quick response MASGuy,

I am accessing a handful of tables which I believe to be available without running reports ie: Product, Customer, Inventory, InventoryTransactions.

 

[MASGuy]

For technical questions such as this I normally post on the Sage Community since I can contact Sage/MAS engineers through there.

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc