Installing the sql server 2005 drivers ?

[Former Member]

Hi Guys,

I am following How to guide to install and configure external drivers.

where can i get the drivertool.bat and drivertool.jar files and which version of sql drivers i need to install, i have downloaded

sqljdbc_1.1.

any help would be appreciated

Thanks,

Srini

[nisarkhan_n · Accepted solution]

check this lnk

http://www.microsoft.com/downloads/details.aspx?familyid=6D483869-816A-44CB-9787-A866235EFC7C&displa...

[Former Member · Accepted solution]

Hi Nisar,

I have already downloded the drivers from this link and i am looking for driver tool.bat file by which you can add the .jar files.

can you please tell me where we can get this tool ?

any help would be appreciated

Thanks,

Srini

[Former Member · Accepted solution]

Check out this may it helps you...

Using JDBC Connection Pool in XI Message Mapping:

/people/william.li/blog/2007/03/30/using-jdbc-connection-pool-in-xi-message-mapping

cheers

[Former Member · Accepted solution]

Hi,

For installing driver for SQL Server 2005 you don't need all these tools. You just need to have the the following jar files.

msbase.jar, mssqlserver.jar, msutil.jar

You can directly create the sda file without the driver tool also and the steps for the same are already mentioned in How To... guide

You just need to edit the provider.xml and add the jar file in the required zip file with name sda.

Maintain the directory structure within the SDA file ( which is nothing but Zip file )

Reward points if find useful

Thanks

Amit

[Former Member · Accepted solution]

Hi Amit,

I have downloaded the mssql 2005 drivers from this link and i could not find the jar files you mentioned , i am seeing only

sqljdbc jar file.

can anybody please tell me where can i download all the above

3 jar files msbase.jar, mssqlserver.jar, msutil.jar.

any help would be appreciated

Thanks,

Srini

[Former Member · Accepted solution]

You can download from the link

http://www.akadia.com/services/sqlsrv_jdbc.html

Go to section "Download Sources" and click on the link and save.

Gaurav Jain

*Points

[Former Member · Accepted solution]

Hi Gaurav,

Thanks for the quick reply and i am able to see now all the jar files required for the deployment.

Thanks,

Srini

[Former Member · Accepted solution]

Hi,

You can download it from

http://www.microsoft.com/downloads/details.aspx?FamilyID=4f8f2f01-1ed7-4c4d-8f7b-3d47969e66ae&displa...

Jar name is mssqlserver.tar

Open it with winzip and Inside that you will find all the three jar files.

Reward point if find useful

Thanks

Amit

[Former Member · Accepted solution]

Hi Amit,

Thanks for the reply and i have added all the 3 jar files manullay in the SDA file and in the how to guide it says we need to update the provider.xml as

<jar-name>ojdbc14.jar</jar-name>

<jar-name>msbase.jar</jar-name>

<jar-name>mssqlserver.jar</jar-name>

<jar-name>msutil.jar</jar-name>

I dont have ojdbc14.jar, do i need to download this as well or just the above 3 jar files will suffice.

any help would be appreciated

Thanks,

Srini

[Former Member · Accepted solution]

Hi,

You don't need to add Ojdbc14.jar. This needs to be used only if you want to connect with Oracle Database which is not true in your case.

Reward points if find useful

Thanks

Amit

[Former Member · Accepted solution]

Hi Amit,

Thanks for the quick reply and i have successfully deployed the sda file for sql drivers.

I appreciate your help and points are rewarded.

Thanks,

Srini

[Former Member]

Hi,

Check this [post|; it explains the manual procedure for doing it. Only difference between the post and your requirement is that you only need to add your 1 jar file whereas the blog describes deploying for SQL server 2000 where 3 jars are required.

Best Regards,

Daniel

Edited by: Daniel Engsig-Karup on Jun 12, 2008 3:05 PM