Bartender - Datareader Follow

0
Avatar
Legacy Poster

I assigned a user the db_datareader Role. When she connects to the MS SQL Server where there is an installation of the Bartender Automation 9.4 SR1 running on Windows Server 2008 R2 Standard 64bit SP1, she is able to print labels.

This same user when trying to print from a remote workstation, gets a dialog box pops up with BarTender: Error Message #3239, OLE DB has encountered error 0x80040E09: Unknown Error. OLE DB error message: IDispatch error #3081.

I looked in the documentation but could not find the minimum rights/permissions required for the program.

Keep in mind I hadn't heard of Bartender until today! Any help would be appreciated.

1 comments

0
Avatar
Susan Chen
Moderator
Comment actions Permalink

Hi, Rbay:

Can you let us know more about your environment?
1. user db_datareader print OK from the machine(say A) as a MS SQL server and with Bartender 9.4SR1 install
2. user db_datareader login to the other machine(say B) and try to print from the other machine(B) with Bartender installed : Baredner ->File-> Print then 3239 error happen ??
3. On Machine B, connection to machine A's SQL server inside Bartender is OK no problem? There is a "Test Connection" button you can test in "Add Database connection wizard". Can you confirm this part?
4. Does customer set up custom SQL statement in Bartender? If you can share with us your label format with/without sample SQL database, it will be helpful. You might need someone know basic Bartender to work with you or you can contact our local regional support office to provide you with more personalized help on this specific error.

Thanks!

Please sign in to leave a comment.