SQL Power Software Forum

This message was edited 1 time. Last update was at 2010-02-24 08:18:22

No matter how I try and connect to my local networked SQL Server database, i get an error message JRE version 1.6 is not supported by this driver. Use the sqljdbc4.rar cla ...

I have looked everywhere on the internet for this file, and although it is referred to on the microsoft website it is not available anywhere for download. i found it on mediafire .. copied it onto my hard-drive and then added that to the JDBC driver (and deleted the original JAR file)

Someone please help ?!

I'm using a mac running Leopard trying to connect to a SQL Server database..

The Microsoft JDBC driver comes for Java 4 & 5 with the filename sqljdbc.jar

That one will refuse to load with Java 6 (please don't ask me why Microsoft decided to do it this way, maybe to bug Java users and drive them to .Net because there is no technical reason for it)

The driver package also contains a file named sqljdbc4.jar which will only work with Java 6 (for technical reasons, as it implements JDBC 4.0 which is not available in previous Java versions)

If you only have a single file, you should download the full distribution from the Microsoft website:

http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en

I usually download the "Linux distribution" and unzip the .tar.gz file manually. It contains both jar files.

Then point Power*Architect to the new file (sqljdbc4.jar)

I think PA still has a bug that when you remove one JDBC jar file and add another, the reference to the old file is still in PA's configuration file. You will need to remove that manually.

The config file is located in $HOME/pl.ini

It's a text file that you can edit manually

thanks for getting back to me.
I still can't get the file to download from either safari or google chrome or firefox. I suspect it will only download using internet explorer.

Bill Ambrose wrote:thanks for getting back to me.
I still can't get the file to download from either safari or google chrome or firefox. I suspect it will only download using internet explorer.

Hmm, I can download it using Firefox. Although it will open an intermediate "EULA" page.

Does this link work for you
http://go.microsoft.com/fwlink/?LinkId=144635&clcid=0x409
(I copied that from the license agreement page)

Yes !!! that worked perfectly
what a nice person. Thank you so much..
now I can get on with the task in hand.
Have a great day