Using Sql Server's Name Instance via JDBC

Very recently i had to use named instance of SQL Server 2000 via JDBC Drivers

After googling i found out the winner in the connection string is "instance=instancename"

Example String
JdbcURL=jdbc:sqlserver://servername:1433;instance=instancename;databaseName=dbname

The print spooler was unable to connect to your printer

Problem when printing to Network Printer

"The print spooler was unable to connect to your printer. This can be caused
by your printer being turned off, the cable being unplugged, or by being
connected to a VPN, which will block your access to your local network. Your
document will print when the printer becomes available."

The message stays on screen until manually cleared, it does not
automatically clear when the printer comes back online.

Solution:
After much googling i came to a solution As soon as I replaced the "HP Standard TCP/IP Port" with the "Standard TCP/IP Port" on all my print queues everything was fine.

multiple connections to a server or shared resource by the same user, using more than one user name, are not allowed

Sometimes Windows networking really does some stupid stuff. Not only does it take up to a minute to connect to a network resource that is literally sitting one meter away, it also has annoying limitations such as the one listed in the title of this article.

I have seen this message before and usually disconnecting a network drive would do the trick. This time however the message would just not go away.


net use * /delete