SQL Server Version Not Supported (2008 R2)

[Clam]

I'm running SQL Server 2008 R2 Enterprise edition.

When I run: "dbcreate.bat" I get the following error:

Default Logging Loaded from a file.

build parser and it is validating true

build parser and it is validating true

Connecting with JDBC Driver URL:
jdbc:sqlserver://localhost:1433;databasename=dt

s;forwardReadOnlyMethod=serverCursor

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

r later.

com.microsoft.sqlserver.jdbc.SQLServerException: The server version is not
suppo

rted. The target server must be SQL Server 2000 or later.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U

nknown Source)

at com.microsoft.sqlserver.jdbc.DBComms.Prelogin(Unknown Source)

at com.microsoft.sqlserver.jdbc.DBComms.<init>(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour

ce)

at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at com.apelon.common.sql.SQL.getConnection(Unknown Source)

at com.apelon.common.util.db.DbCreate.makeConnection(Unknown Source)

at com.apelon.common.util.db.DbCreate.<init>(Unknown Source)

at com.apelon.common.util.db.DbCreate.main(Unknown Source)

Press any key to continue . . .

It says, "The target server must be SQL Server 2000 or later," and 2008 is
clearly later than 2000.

Has anyone else had this problem? Should I just downgrade to 2000? or 2005
perhaps?

Or is it something entirely different, and I am just losing my mind... which
is entirely possible. lol

Thanks ahead of time.

[Abhay Sinha]

The error is coming from SQL Server JDBC driver.

This issue can be fixed by using the JDBC driver for 2008

Here is the link to download the driver.

http://www.microsoft.com/downloads/details.aspx?FamilyID= a737000d-68d0-4531-b65d-
da0f2a735707&displaylang=en

[Clam]

Worked like a charm. Thanks again for your help.

[EDWARD WARREN]

I have been trying to get SNOMED CT loaded into SQL server 2008 R2 for a day
now. I just simply do not understand enough about Jdbc, DTS, etc. to make it
work. Does anyone have a copy of the required KB Create xml files that are
tuned for SQL server 2008, I have downloaded the newest JDBC driver from MS
(3.0), but I'm not sure I have it properly installed and/or know how to
properly call it from the XML files.

Thanks in advance

Ed Warren

[Abhay Sinha]

Ed,

The workaround provided here is for DTS 3.5.

For DTS 3.5.1 Beta, you do not need add new jdbc driver.

kbcreate.bat uses target-connection.xml in bin/kb folder for connection
parameters information by default. Just edit that file to add the connection
information. You do not need to modify kbcreate.xml file.

Abhay

[EDWARD WARREN]

Thanks, I will download the Beta version and give it a try. My basic
deficiency is: I'm not a JAVA programmer, worked with C, C++, Basic but have
never ventured into JAVA. This may be my opportunity :).

Ed Warren.

[EDWARD WARREN]

That worked thanks, the BETA version allowed the kbcreate to create the
tables, it would appear no sql triggers or constraints were created. but then
that may be the correct answer. Now on to trying to fill the tables with
SNOMED CT... not having much luck there, but will start a new thread...

Again, thanks for the reply, it got me pointed in the correct direction.

Ed Warren