×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Trouble With A Windows Service Accessing MAS90 Tables

Trouble With A Windows Service Accessing MAS90 Tables

Trouble With A Windows Service Accessing MAS90 Tables

(OP)
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.

RE: Trouble With A Windows Service Accessing MAS90 Tables

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 Communityhttp://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc  

RE: Trouble With A Windows Service Accessing MAS90 Tables

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close