MS SQLSERVER 7.0 ( very old ) as a data server service in MII 12.2

[Former Member]

Hi everybody ,

Our client has a MSSQL SERVER 7.0 database engine .  We have a MSSQL SERVER 2008 as our database engine for our MII 12.2 version .  Is is possible to connect our MII 12.2 plataform to that old database engine ( as a data server service ) ? .

Thanks for your kind help

[former_member185280 · Accepted solution]

I don't know if there is an ms provided jdbc driver. You can try the jtds driver: http://jtds.sourceforge.net/

If you can't get a connection that way maybe you can try linking the servers http://msdn.microsoft.com/en-us/library/ms188279.aspx

[Former Member · Accepted solution]

Thanks Christian ,

I looked over our old xMII 11.5 version data servers and found that the connection works with the following configuration :

JDBC driver : com.inet.tds.TdsDriver

Server URL : jdbc:inetdae:143.94.1.71:1433?database=FUELFACS&sql7=true

I think it is a matter of installing in our MII 12.2 version,  the JDBC driver .  How can I do it ,  because I do not find in the System Management folder a way to do it .

Please help, Thank you

[former_member185280 · Accepted solution]

You may need some 'Actions' assigned to a role you have in the UME to be able to deploy drivers:

JDBC Drivers:

XMII_JDBCDriver_R

XMII_JDBCDriver_RWD

XMII_JDBCDriver_deploy

XMII_JDBCDriver_all

http://help.sap.com/saphelp_mii122sp01/helpdata/en/48/d0c6efbcb810b6e10000000a421138/content.htm?fra...

[jcgood25 · Accepted solution]

Look in the c:\Illuminator\Conf directory on your 11.5 server for a zip or jar file that would be the JDBC driver used by the connection you mentioned.  This is from memory, but if think that is the directory (or somewhere in that area of the file system.  Upload/deploy and try your same connection details on the new server - with different claSS paths there should be no conflict.

[Former Member · Accepted solution]

Thanks jeremy,

I will try

Best regards,

[former_member202228 · Accepted solution]

UNA2000.Jar file in xMII 11.5 can be grabbed and  deployed into newer versions of MII (up to 14.0 SP04 tested). It is exactly the one having the "com.inet.tds.TdsDriver" description (default in MII IDBC data server configuration)

[Former Member · Accepted solution]

thanks Jeremy,

I found the jdbc2_0-stdext.jar in the folder "c:\\ServletExec AS\lib .  I expect is the one you mentioned above .

I will let you know what happens .

Best regards,

[Former Member · Accepted solution]

Thanks ,

I found it . I will try to deploy it on our MII 12.2 system .

Best regards,

[Former Member · Accepted solution]

Thanks,

When the UNA2000.jar is uploaded ,  there is a yellow warning mark and I am not able to connect to that old database .

Best regards & help !

[Former Member · Accepted solution]

I uploaded it and a yellow warning mark appeared at the JDBC drivers upload page .  I still can not connect to the old database .

Please help . Best Regards