Seagull.bartender.systemdatabase Question
I've developed my application to load up to 7 formats and print any one randomly to 7 printers on demand using a single engine.
The Bartender system database is SQL Server 2012 and I added several additional tables for use with my application, I did not initially plan on using any of the system tables since the formats already connects to an Excel spreadsheet for its data and prompts not SQL.
Now I think I need to use the system database to log the print jobs and get data at the end of the run.
My questions are:
Can the SystemDatabaseConnection still use my predefined SqlConnectionString?
Do I only create a single SystemDatabaseConnection when I start my Engine, then every time I print a format it will update the database?
Or do I have to connect and disconnect with each printed format?
I didn't see anywhere the need to close the connection, is this handled in the dll when I close my application?
Even Scarier...Does each format need to point to the SQl database to log the print jobs etc.?
Thanks again
-
Hi LBarton, I'm new to BarTender, but I use Entity Framework for handling the database in my C# programms so you do not have to take care about connection strings or reconnects and it is easy to use.
May this can help.
Regards
0 -
The BarTender System Database structure shouldn't be modified for your own use by adding extra tables. It should be entirely managed by BarTender's System Service. Find below some a link to some clarifying training videos which I hope will help:
http://www.seagullscientific.com/label-software/training-video-(setting-up-a-system-database).aspx
0
Please sign in to leave a comment.
Comments
2 comments