Hi,
Thanks a lot.
It's up and running.
roy
-----Original Message-----
From: Danny Rubis [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2000 01:26
To: [EMAIL PROTECTED]
Subject: Re: Connection Failure - Urgent
Hey!
Like Doug says you need a Type-3 JDBC driver.
Microsoft strikes again. I guess you didn't know that
Microsoft does not support JDBC for SQLServer. Opps!
Microsoft supports ASPs and VB not Java. So if
you are going to stick with Java then you need to get
a DB that supports Java.
Otherwise, you will need to buy a driver from some place else.
Merant comes to mind but I think their driver costs
$4500. Opps again. You may have gotten SQLServer
for free, but now you're really gonna pay.
Doug Turner's work around is not good for production.
When something goes wrong
with the JDBC Type-3 driver bundled with BEA's Weblogic, and
you are using a competitor Application Server, BEA is
going to be reluctant to cooperate.
I heard there is a JDBC driver from a German company.
I lack info. though.
I suggest that you switch to DB2 UDB. They write there own
driver and therefore can be held accountable. Oh, yes Oracle too.
Also, I heard that Informix is also finally smelling Java.
Sorry about this off-topic posting, but I just can't resist dumping
on MS when I can.
Sans adieu,
Danny Rubis
"Roy Silva (Java)" wrote:
> Hi,
>
> I have a proxy servlet which validates the clinet login. The problem is
> after a while I get a message saying
>
> MessageText = "[Microsoft][ODBC SQL Server Driver]Connection failure" AND
> stop the JWS!. I have to restart the JWS manually each time this happens!.
>
> Microsoft SQL Server support says,
>
> To work around this problem, drop the current connection and reconnect
> the client.
>
> HOW DO I DO THIS without restarting JWS!
>
> many thanks
> roy
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
