hiteksoftware.com Forum Index hiteksoftware.com
User discussion forum
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

stored procedure task not working with 2008 MS SQL Server

 
Post new topic   Reply to topic    hiteksoftware.com Forum Index -> Frequently Asked Questions
View previous topic :: View next topic  
Author Message
jmiksa



Joined: 12 Jun 2008
Posts: 16

PostPosted: Thu Mar 15, 2012 8:24 am    Post subject: stored procedure task not working with 2008 MS SQL Server Reply with quote

I received the following error message when trying to run the task against 2008 MS SQL server:

The server version is not supported. The target server must be SQL Server 2000 or later.

I googled the error and discovered that I needed to update my SQL driver class files. I pulled the latest and used those but received a different error:

Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

Are there any plans to update the JRE, or do new versions already work? Are you aware of any SQL Class drives that are supported by the JRE 1.6 and 2008 MS SQLServer? Any recommendations?
Back to top
View user's profile Send private message
Robert
Site Admin


Joined: 25 May 2006
Posts: 1140

PostPosted: Thu Mar 15, 2012 7:31 pm    Post subject: Reply with quote

You can try to use the ODBC driver similar to MSAccess. The instructions are listed here:
http://www.hiteksoftware.com/knowledge/database/other/otherODBC.htm
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    hiteksoftware.com Forum Index -> Frequently Asked Questions All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group