Sorry. I should have done baby steps. When it finally started working, one of my other fields was null. Sorry to waste your time.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, April 02, 2004 10:41 AM To: [EMAIL PROTECTED] Subject: RE: Sql server driver Hi There This works for me: <sql:setDataSource driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" url="jdbc:microsoft:sqlserver://[SQLSERVER_NAME]:1433;DatabaseName=[DATABASE _NAME];SelectMethod=cursor" user="[USERNAME]" password="[PASSWORD]" scope="page"/> Could it be a sql server authentication problem? Hope this helps rgds Jim -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 02 April 2004 16:37 To: [EMAIL PROTECTED] Subject: Sql server driver Sql server is MyServer Database Name is test Username is test Password is test In normal jsp my connection string is: Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); con = DriverManager.getConnection("jdbc:microsoft:sqlserver://MyServer;dbname=test ","test","test"); This works fine. In JSTL my connection string is: <sql:setDataSource driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" url="jdbc:microsoft:sqlserver://MyServer;DbName=test" user="test" password="test" /> I get a null pointer exception. I've tried many variations. 'DatabaseName' instead of 'DbName'. I've explicitly used port 1433. Different orders, everything. Any ideas on what I am doing wrong? ======================================================================= Scanned for virus infection by Messagelabs ======================================================================= ======================================================================= This email has been scanned for Virus infection by MessageLabs For more information please contact [EMAIL PROTECTED] ======================================================================= --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
