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]
