Change the url and the driver. You have miswritten them: url="jdbc:microsoft:....." connection-driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
Lachezar > Subject: how do I setup a datasource for mssql 1 2 3 4 5 6 7 8 9 > From: "alt.cybercafes" <[EMAIL PROTECTED]> > === > I have tried setting up my the datasource like the following > > <data-source > class="com.evermind.sql.DriverManagerDataSource" > name="Billing" > schema="database-schemas/ms-sql.xml" > location="jdbc/Billing" > xa-location="jdbc/Billing" > ejb-location="jdbc/Billing" > url="com.microsoft.jdbc.sqlserver.SQLServerDriver" > > connection-driver="jdbc:microsoft:sqlserver://myserver:1433;DatabaseName=Bil > ling" > username="applesauce" > password="1234" > inactivity-timeout="30" > /> > > and I get the following errors > "Error initializing data-source 'jdbc/Billing': DriverManagerDataSource > driver 'jdbc:microsoft:sqlser > ver://Appserver1:1433;DatabaseName=Billing' not found" > > What am I doing wrong? > > thanks > > > >