troubleshooting Question

FoxPro printing works through 2003 Server, but not 2008 server.

Avatar of woodwyn
woodwynFlag for United States of America asked on
FoxProWindows Server 2003Windows Server 2008
13 Comments1 Solution907 ViewsLast Modified:
We have two FoxPro applications running on multiple systems in a single domain.  SQL Server is the backend DB.  UNC networked printer share names stored in a SQL table are queried from the FoxPro applications.  The FoxPro app is set to the printer share name and sends the print job.

The query "SELECT PrinterName FROM Printers WHERE PrinterNumber='1' " returns the share name "\\Server01\Printer1" where Server01 is the 2003 server and Printer1 is a shared printer on that server.  This has worked for years on the Windows 2003 Server print spooler.  

We added a Windows Server 2008 system to the domain.  

The query "SELECT PrinterName FROM Printers WHERE PrinterNumber='2' " returns the share name "\\Server02\Printer2" where Server02 is the 2008 server and Printer2 is a shared printer on that server.  This does not work.  Server02 is a HyperV guest OS where the host OS is Server 2008 Enterprise.  (This is NOT R2).  Server02 has been set up as the print spooler for the domain and is working as such for all purposes other than the FoxPro print jobs.  
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 13 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros