Showing posts with label jsp. Show all posts
Showing posts with label jsp. Show all posts

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

JSP + Reporting 2005

Hi,
whats the best way to implement a Java Servelet/JSP to use reporting
services 2005?
I dont want to use the anonymous access,
is there a way to do this?a kind of proxy like this...
http://www.javaworld.com/javaworld/jw-01-2005/jw-0110-sqlrs.html
but with RS 2005
greetings
MauroMauro,
Check out this lab: Implementing SQL Server Reporting Services with a Java
EE Application-Building a Reporting Services Solution Virtual Lab
http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032315323&EventCategory=3&culture=en-US&CountryCode=US
Reeves
"Mauro SB." wrote:
> Hi,
> whats the best way to implement a Java Servelet/JSP to use reporting
> services 2005?
> I dont want to use the anonymous access,
> is there a way to do this?a kind of proxy like this...
> http://www.javaworld.com/javaworld/jw-01-2005/jw-0110-sqlrs.html
> but with RS 2005
> greetings
> Mauro
>
>|||tnks veeeery much!
gretings
Mauro
"Reeves Smith" <ReevesSmith@.discussions.microsoft.com> escribió en el
mensaje news:E7113029-9686-474C-BF7E-8F37A01D4ABE@.microsoft.com...
> Mauro,
> Check out this lab: Implementing SQL Server Reporting Services with a Java
> EE Application-Building a Reporting Services Solution Virtual Lab
> http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032315323&EventCategory=3&culture=en-US&CountryCode=US
> Reeves
> "Mauro SB." wrote:
>> Hi,
>> whats the best way to implement a Java Servelet/JSP to use reporting
>> services 2005?
>> I dont want to use the anonymous access,
>> is there a way to do this?a kind of proxy like this...
>> http://www.javaworld.com/javaworld/jw-01-2005/jw-0110-sqlrs.html
>> but with RS 2005
>> greetings
>> Mauro
>>