Connecting to SQL Server

Hi all,

                I’m trying to connect to MS SQL Server, but can’t get the datasource right. I’d prefer to connect directly to the DB, but I’d settle for ODBC. Could someone  point me in the right direction, I currently have

 

<datasource>

  <driver-class-name>org.hsqldb.jdbcDriver</driver-class-name>

  <uri>jdbc:odbc:test</uri>

  <username>sa</username>

  <password/>

</datasource>

 

But get the following error message

 

java.sql.SQLException “No suitable driver”

 

Thanks

 

Ryan

 

-----------------------------------------------

Ryan Puddephatt

FIX Developer

Fidessa LatentZero

1 Alfred Place

London WC1E 7EB

Office: +44 (0) 20 7462 4200

Direct: +44 (0) 20 7323 6112

Blackberry: +44 (0) 79 8539 2458

Fax: +44 (0) 20 7462 4242

Email: [hidden email]

Web: http://www.latentzero.com

 

_______________________________________________________________________
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

_____________________________________________________________________
This e-mail has been scanned for viruses by Verizon Business Internet Managed Scanning Services - powered by MessageLabs. For further information visithttp://www.mci.com

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: [hidden email]
For general help: [hidden email]
OW2 mailing lists service home page: http://www.ow2.org/wws