PI and SQL Server

Started by Gareth Watkinson

Gareth Watkinson

PI and SQL Server 25 April 2006, 17:00

Hi,

I've got PI installed on 2 print servers and have configured it to write into a single SQL database. However i find whenever i add printers it deletes all existing printers in the printers table in SQL (i.e. only the last set of printers i add are listed).

Is this by design? Should i create a new database for each print server?

Thanks,
Gareth

Reply Quote

Andrew

Re: PI and SQL Server 25 April 2006, 19:34

Admin
Registered: 12 years ago
Posts: 5 643

Ah, this is a bug. The problem comes from the design when Print Inspector supported just a single local database. Currently, I would recommend to use different databases for two Print Inspector instances. I hope we'll fix it shortly.

Reply Quote

Gareth Watkinson

Re: PI and SQL Server 25 April 2006, 21:23

OK Thanks.

Reply Quote

Scott

Re: PI and SQL Server 24 May 2006, 01:00

When will the fix be available as I have 20-30 print servers which i'd need to install this on and do not want 20-30 databases.

Reply Quote

Andrew

Re: PI and SQL Server 24 May 2006, 01:44

Admin
Registered: 12 years ago
Posts: 5 643

Yes, this issue has been fixed in a build of the 15th of May. Simply download the current installation package and install it over the previous release.

Reply Quote

Salvador Diosdado

PI and SQL Server 25 October 2009, 15:09

Well, I'm a beginner trying to use PI to generate reports from data base in SQL, can you suggest the best and quickest way to learn?..where can I find examples?. any suggestion would be appreciated.

Reply Quote

Andrew

PI and SQL Server 25 October 2009, 15:48

Admin
Registered: 12 years ago
Posts: 5 643

Try [sqlcourse.com]

Reply Quote

Newer topic Older topic

Print view of this page

Sometimes you can get the answer faster if you try the forum search and/or have a look at the software user manual to see if your question has already been answered.

Our forum rules are simple:

Be polite.
Do not spam.
If possible, check your spelling and grammar.

Author:

Email:

Subject

A brief and informative title for your message, approximately 4–8 words:

Disable BBcode in this message Disable smileys in this message

Help information

Spam prevention: please enter the following code in the input field below.

 **     **   *******   **    **  **     **  ********  
 ***   ***  **     **   **  **   **     **  **     ** 
 **** ****  **     **    ****    **     **  **     ** 
 ** *** **   ********     **     *********  ********  
 **     **         **     **     **     **  **        
 **     **  **     **     **     **     **  **        
 **     **   *******      **     **     **  **

Enter the code:

Message:

PI and SQL Server

Software Products

Store & Support

Download

SoftPerfect