MS SQL 2005 hotfix from last week and Java clients

I was using a great Java client before tha last hotfix to access my SQL Server 2005 system. After the last upgrade, I haven't been able to connect. I've tried three different softwares and two platforms ( I normally use a Mac, but I went so far as to try it out on a PC, no success). I even set up a brand new account to see if my settings on discountasp.net had caused some problems. Still no luck.

I can't be the only one?

The search on this system is not so great, so I'm putting some keywords so that others with my troubles can find this and add to this, rather then wander in the dark with me.

hotfix MSSQL SQL Server 2005 Java Client Mac OS X Apple

 

I have used the new jdbc driver - no luck. I'm running Aqua Data Studio on OS X. I've tried SQL4X on both platforms and I've tried DbVIsualizer, and iSQL viewer - all on the Mac.

Thanks,
Mayur

 

Bruce,
I created a new account, so I assume that I can log on using an MS SQL client from a windnows box.

The Java error I get is:

An error occured while establishing the connection.
Type: java.sql.SQLException Error Code: 0 SQL State: 08S01
Message:
I/O Error: DB server closed connection.

Thoughts?

Thanks,
Mayur

 

Thanks for the adivce. I wish this was the first time I have received this advice. I know that I can log on without using a Mac. My sole purpose in posting is to talk to others who use a Java based client and want to know if I'm the only one who's having trouble.

The tone of frustration is from the fact this is because I'm getting more finger pointing here then at city hall.

Future posters, please bear in mind that I am looking to hear from somebody who has succesfully connected to SQL Server 2005 with a Java-based client or if you were connecting before the fix and are having trouble now.

Best,
Mayur

 

Bruce,
Thanks for the help. I've used 3-4 different Java clients, all with failure. I've tried all sorts of permutations of .jar files. I've tried logging on to two different discountasp.net accounts, using two different platforms. The developer of my software of choice has worked with another SQL Server 2005 post hotfix successfuly. I've already contacted support several times by now - I'm sure that they hate me.

I'm convinced it's some error on the part of discountasp, but I'm trying to get some help before I start looking into other hosting services.

Any suggestions by way of direct java-based client experience would be welcomed.

Best,
Mayur

 

WIthout exagerating, that would greatly appreciated and something I've been waiting a week for.

Thanks,
Mayur

 

Yes, MS SQL Server express is able to connect.

Thanks,
Mayur

 

Bruce,
Have you tried and failed or have you not tried yet?
Junior,
Would it be possible for you to try this if Bruce can't.

Thanks for giving it shot. I am sure that I am not crazy about this.

Best,
Mayur

 

Aqua Data Studio - http://www.aquafold.com/ is my choice.

iSQL - http://www.isqlviewer.com/

SQLgrinder for mac
http://www.advenio.com/sqlgrinder/

DB Visualizer http://www.minq.se

Are a few more.

Thanks for looking into it.

 

Bruce or Junior,

Any luck?

Thanks,
Mayur

 

THANK YOU! I appreciate your help.

Best,
Mayur