In a previous project we had to look at mssql as one of the database servers under consideration.
Don't know, with the exception of the order of the arguments in the tag and that I didn't need to use // in front of the machine name (which could be specific to the driver) I can't see anything different; I have the driver in orion/lib, too. Here is a working example: <data-source class="com.evermind.sql.DriverManagerDataSource" name="jSupport" location="jdbc/sql7jSupportDS" xa-location="jdbc/xa/sql7jSupportXADS" ejb-location="jdbc/sql7jSupportEJBDS" connection-driver="weblogic.jdbc.mssqlserver4.Driver" username="......." password="......" url="jdbc:weblogic:mssqlserver4:localhost:1433" inactivity-timeout="30" /> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 8:25 AM To: Orion-Interest Subject: Microsoft JDBC Driver - Issues w/ Data Source I'm having some issues with using the Microsoft SQL Server JDBC Driver with Orion. Let me give you some context: Although I have some past experience with Orion (servlets, beans, jsp), I've never used its Data Sources, so I know next to nothing about them. And, although the community and documentation have improved of late, Orion's documentation is still pretty sparse. When it came time to spend some time with EJB, I moved over to JBoss, which has stronger documentation, for a while, and while on JBoss, I started making use of the Microsoft SQL Server driver beta, which has proved to be quite reasonable (which is not too surprising, since it's the Merant driver). Due to some performance issues, I wanted to see how the application we're working on would run under Orion, so I downloaded the latest, and started to try and configure it. The basic steps were still pretty easy, but now I'm stuck on the data source - no matter what I do, I can't seem to get Orion to recognize the SQL Server driver. Has anyone tried it yet? Am I missing something obvious? I put the driver JARs (three of them: msbase, msutil, mssqlserver) in orion/lib. I modified the data-sources.xml to use the driver, as follows: <data-source name="MicrosoftSqlServer" location="jdbc/SqlServerDS" connection-driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" url="jdbc:microsoft:sqlserver://panthro:1433;DatabaseName=dbVoicenetDevGeoff ;SelectMethod=cursor" username="user" password="password" inactivity-timeout="30" class="com.evermind.sql.DriverManagerDataSource" /> When orion starts, it says the following: Error initializing data-source 'jdbc/SqlServerDS': DriverManagerDataSource driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' not found What does this mean? It can't find the driver? The JARs are in orion lib, I've checked that several times, including that the driver name is right, and the class is in the JAR. I can't swear that Orion is loading the JARs, because it doesn't put that out to the console or log files, so I don't really know that it's doing that, but I'm assuming it is. It does say 'DriverManagerdataSource driver', so perhaps the driver isn't what it's expecting. Should I be using another class? Based on the descriptions in the API docs and the Hypersonic example, this seems like a reasonable class to use. Suggestions? Anyone know where I can go from here? Thanks, - Geoffrey Wiseman __________________________________________________________ Geoffrey Wiseman: Internet Applications Manager Medium One t. 416.977.2101 x. 529 http://www.mediumone.com/ __________________________________________________________ Think it. Build it. Work it.