Unable to locate MS SQL Server driver

[sai charan <ch...@gmail.com>]

Hi,

I have Geronimo 2.1.1 and Microsoft SQL Server 2005 database, while i was
creating the datasource, i found two options in the repository like SQL
Server,SQL Server (Data Direct) & SQL Server (jTDS)... My question is is
SQL Server same as MS SQL Server, if yes, then i tried to use the driver of
MS Sql but i am not able to create a data source and connect to the
database, Please help me in order to shut out this issue....

Thanks,
Saicharan Burle.

Re: Unable to locate MS SQL Server driver

[Forrest Xia <fo...@gmail.com>]

You need to download ms sql jdbc driver from microsoft web site, then
install it into geronimo, then define a datasource which uses the jdbc
driver. You can refer to daytrader ms sql datasource plan for an example.

http://www.microsoft.com/en-us/download/details.aspx?id=2505
https://svn.apache.org/repos/asf/geronimo/daytrader/tags/daytrader-2.1.7/plans/src/main/resources/daytrader-mysql-xa-plan.xml

On Fri, Jun 22, 2012 at 6:30 AM, sai charan <ch...@gmail.com> wrote:

> Hi,
>
> I have Geronimo 2.1.1 and Microsoft SQL Server 2005 database, while i was
> creating the datasource, i found two options in the repository like SQL
> Server,SQL Server (Data Direct) & SQL Server (jTDS)... My question is is
> SQL Server same as MS SQL Server, if yes, then i tried to use the driver of
> MS Sql but i am not able to create a data source and connect to the
> database, Please help me in order to shut out this issue....
>
> Thanks,
> Saicharan Burle.
>



-- 
Thanks!

Regards, Forrest

Re: Unable to locate MS SQL Server driver

[sai charan <ch...@gmail.com>]

Hi,

I have followed the same steps which you provided after unzipping i got two
jar files PFA, When i was trying to install thru Repositories, I gave
group as "MSSQL" Artifact as "MSSQL" version as "2.0" and type as "jar" ...
It got installed successfully, but now the problem started again, while
creating database pools, I selected SQL Server and clicked on next button,
but no luck it was showing nothing and remaining on the same page... Please
advice me on which step i was wrong...


Please find below Screen shot also: There were three options , i choosed
the SQl Server,