bodington-developers

[Bodington-developers] Bodington and SQL Server 2005

[Andrew B. <a.g...@le...>]

Having obtained a copy of SQL Server 2005 via the SOCKET project, I decided
to see if it worked with Bodington via the Microsoft JDBC driver for SQL
Server 2005.  Guess what?

Microsoft have changed both the JDBC driver name and the URL.

The driver name has changed from:

com.microsoft.jdbc.sqlserver.SQLServerDriver

to

com.microsoft.sqlserver.jdbc.SQLServerDriver

and the URL from:

jdbc:microsoft:sqlserver://

to

jdbc:sqlserver://

I've fixed the SetupServlet - OK to commit to head?
If there no objections by the end of today, I'll commit the changes
tomorrow.

Aggie

Re: [Bodington-developers] Bodington and SQL Server 2005

[Matthew B. <mat...@ou...>]

Andrew Booth wrote:
> Having obtained a copy of SQL Server 2005 via the SOCKET project, I decided
> to see if it worked with Bodington via the Microsoft JDBC driver for SQL
> Server 2005.  Guess what?
> 
> Microsoft have changed both the JDBC driver name and the URL.
> 
> The driver name has changed from:
> 
> com.microsoft.jdbc.sqlserver.SQLServerDriver
> 
> to
> 
> com.microsoft.sqlserver.jdbc.SQLServerDriver
> 
> and the URL from:
> 
> jdbc:microsoft:sqlserver://
> 
> to
> 
> jdbc:sqlserver://
> 
> I've fixed the SetupServlet - OK to commit to head?
> If there no objections by the end of today, I'll commit the changes
> tomorrow.

Does the fix allow both versions to work?

-- 
  -- Matthew Buckett, VLE Developer
  -- Learning Technologies Group, Oxford University Computing Services
  -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/

RE: [Bodington-developers] Bodington and SQL Server 2005

[Andrew B. <a.g...@le...>]

Yes.

Aggie

-----Original Message-----
From: bod...@li...
[mailto:bod...@li...] On Behalf Of
Matthew Buckett
Sent: 24 May 2006 11:49
To: bod...@li...
Subject: Re: [Bodington-developers] Bodington and SQL Server 2005

Andrew Booth wrote:
> Having obtained a copy of SQL Server 2005 via the SOCKET project, I
decided
> to see if it worked with Bodington via the Microsoft JDBC driver for SQL
> Server 2005.  Guess what?
>
> Microsoft have changed both the JDBC driver name and the URL.
>
> The driver name has changed from:
>
> com.microsoft.jdbc.sqlserver.SQLServerDriver
>
> to
>
> com.microsoft.sqlserver.jdbc.SQLServerDriver
>
> and the URL from:
>
> jdbc:microsoft:sqlserver://
>
> to
>
> jdbc:sqlserver://
>
> I've fixed the SetupServlet - OK to commit to head?
> If there no objections by the end of today, I'll commit the changes
> tomorrow.

Does the fix allow both versions to work?

--
  -- Matthew Buckett, VLE Developer
  -- Learning Technologies Group, Oxford University Computing Services
  -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/


-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Bodington-developers mailing list
Bod...@li...
https://lists.sourceforge.net/lists/listinfo/bodington-developers

Re: [Bodington-developers] Bodington and SQL Server 2005

[Colin T. <col...@ou...>]

Andrew Booth wrote:
> Microsoft have changed both the JDBC driver name and the URL.

Does that mean you use the old name and URL if you're running a pre-2005 
version and old jdbc driver, and the new ones if using the new versions?

> I've fixed the SetupServlet - OK to commit to head?

Does the fix need to cope with both versions of names and URLs?

Colin

-- 
____________________________________
Colin Tatham
VLE Team
Oxford University Computing Services

http://www.oucs.ox.ac.uk/ltg/vle/
http://bodington.org

RE: [Bodington-developers] Bodington and SQL Server 2005

[Andrew B. <a.g...@le...>]

Yes, apparently the changes were made in order to allow SQL Server 2000 and
2005 to co-exist. The fix copes with both versions.

Aggie

-----Original Message-----
From: bod...@li...
[mailto:bod...@li...] On Behalf Of Colin
Tatham
Sent: 24 May 2006 11:50
To: bod...@li...
Subject: Re: [Bodington-developers] Bodington and SQL Server 2005

Andrew Booth wrote:
> Microsoft have changed both the JDBC driver name and the URL.

Does that mean you use the old name and URL if you're running a pre-2005
version and old jdbc driver, and the new ones if using the new versions?

> I've fixed the SetupServlet - OK to commit to head?

Does the fix need to cope with both versions of names and URLs?

Colin

--
____________________________________
Colin Tatham
VLE Team
Oxford University Computing Services

http://www.oucs.ox.ac.uk/ltg/vle/
http://bodington.org


-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Bodington-developers mailing list
Bod...@li...
https://lists.sourceforge.net/lists/listinfo/bodington-developers