Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

SQL Server linked Server [ProvideX][ODBC Driver][PVKIO]Invalid segment number

Posted By roastbeast over 12 years ago

i am trying to query a mas table from sql server. several other mas tables return data successfully, but attempts to read from the

IM_ItemTransactionHistory table return this error:

OLE DB provider "MSDASQL" for linked server "MAS_LINKED_44" returned message "[ProvideX][ODBC Driver][PVKIO]Invalid segment number".

the mas version is 4.4. the sql server version is 2008 r2.

anyone have any ideas on this?

roastbeast over 12 years ago

after inexplicably getting "table is not accessible" errors instead of the "invalid segment number" error when retrying queries to the table i did some more research and found others who had the same error and solved it by changing the sql service account login. i changed my sql server service account from "network service" to the domain administrator account. using the administrator account is generally not recommended but i'll use it for now...

here is the link to the discussion:
http://community.sagemas.com/t5/Sage-MAS-90-and-200-Extended/SQL-Server-Linked-Server-MAS90-ODBC/td-p/23757
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
rclowe over 6 years ago in reply to roastbeast

Hi roastbeast,

Other than changing the SQL Server service account was there anything else you needed to do. We are having the exact same issue and the link in your post does not seem to work for me.

Thanks very much.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Sage 100

SQL Server linked Server [ProvideX][ODBC Driver][PVKIO]Invalid segment number

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING