Monday, March 26, 2012

JSP connection string to SQL 2000

Hi,
What will be the connection string in the JSP to SQL
Server 2000?
Thanks.
JasonIf you are using MS JDBC Driver try the following:
jdbc:microsoft:sqlserver:// hostname:1433;DATABASENAME=YourDBName;Se
lectMetho
d=cursor
The SelectMethod=cursor parameter is important to allow multiple
statements per connection.
If you are using the ODBC/JDBC bridge try:
jdbc:odbc:YourOdbcDsnName
Regards,
Chris
JasonHuang8888 wrote:

> Hi,
> What will be the connection string in the JSP to SQL
> Server 2000?
> Thanks.
> Jasonsql

No comments:

Post a Comment