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.

Why won't a Sage 100 Mas90 32 bit ODBC driver allow wrire access when exporting FedEx tracking numbers to a SO-HEADER field contaiing a maximum 35 character limit? Version 4.0

Posted By Rick Barone over 2 years ago

Please advise if this is a "Write" permissions issue that needs to be set within Sage. Only reason I can advance for the processed shipment data to not be able to post to the referenced table and table field.

Top Replies

Kevin M over 2 years ago +3

The ODBC driver that ships with MAS90 / Sage 100 is read only.

Use an import job (Visual Integrator) if you have that module.

Note: Read-Only ODBC is purposeful to protect the data integrity, since ODBC…

Parents

Kevin M over 2 years ago

The ODBC driver that ships with MAS90 / Sage 100 is read only.

Use an import job (Visual Integrator) if you have that module.

Note: Read-Only ODBC is purposeful to protect the data integrity, since ODBC bypasses all the programmed system logic.
Cancel
Vote Up +3 Vote Down

Sign in to reply

Cancel

Reply

Kevin M over 2 years ago

The ODBC driver that ships with MAS90 / Sage 100 is read only.

Use an import job (Visual Integrator) if you have that module.

Note: Read-Only ODBC is purposeful to protect the data integrity, since ODBC bypasses all the programmed system logic.
Cancel
Vote Up +3 Vote Down

Sign in to reply

Cancel

Children

FormerMember over 2 years ago in reply to Kevin M

ODBC is useless with Payroll and credit card based tables due to encryption.
Cancel
Vote Up -1 Vote Down

Sign in to reply

Cancel

Sage 100

Why won't a Sage 100 Mas90 32 bit ODBC driver allow wrire access when exporting FedEx tracking numbers to a SO-HEADER field contaiing a maximum 35 character limit? Version 4.0

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING