ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lou Fox" <lou...@cloud9.net>
Subject Re: <sql> using driver: com.microsoft.jdbc.sqlserver.SQLServerDriver
Date Thu, 05 Sep 2002 14:37:01 GMT
Yup, it was a socket problem.  Got it squared away now.

Thanks.
  ----- Original Message ----- 
  From: Martin Gainty 
  To: foulox@yahoo.com ; ant-user@jakarta.apache.org 
  Sent: Wednesday, September 04, 2002 6:59 PM
  Subject: Re: <sql> using driver: com.microsoft.jdbc.sqlserver.SQLServerDriver


  Lou:

  1)Make sure the SQLSERVER Socket port you are using is not being used by another
  2)sign the file containing the classes that will load your DB drivers.
  Keep us apprised,

  Martin Gainty

  ______________________________________________

  Disclaimer and confidentiality note

  Everything in this e-mail and any attachments relating to the official business of Laconia
Data Systems (LDS) is proprietary to the company. It is confidential, legally privileged and
protected by law. LDS does not own and endorse any other content. Views and opinions are those
of the sender unless clearly stated as being that of LDS. 

  The person addressed in the e-mail is the sole authorised recipient. Please notify the sender
immediately if it has unintentionally reached you and do not read, disclose or use the content
in any way.


  LDS can not assure that the integrity of this communication has been maintained nor that
it is free of errors, virus, interception or interference.

               _____________GMT-5___________________



  >From: "Lou Fox" 
  >Reply-To: "Lou Fox" 
  >To: "Ant Users List" 
  >Subject: using driver: com.microsoft.jdbc.sqlserver.SQLServerDriver 
  >Date: Wed, 4 Sep 2002 16:51:55 -0400 
  >MIME-Version: 1.0 
  >Received: from nagoya.betaversion.org ([192.18.49.131]) by mc4-f6.law16.hotmail.com
with Microsoft SMTPSVC(5.0.2195.5600); Wed, 4 Sep 2002 13:55:35 -0700 
  >Received: (qmail 17431 invoked by uid 97); 4 Sep 2002 20:55:59 -0000 
  >Received: (qmail 17266 invoked by uid 98); 4 Sep 2002 20:55:58 -0000 
  >Mailing-List: contact ant-user-help@jakarta.apache.org; run by ezmlm 
  >Precedence: bulk 
  >List-Unsubscribe: 
  >List-Subscribe: 
  >List-Help: 
  >List-Post: 
  >List-Id: "Ant Users List" 
  >Delivered-To: mailing list ant-user@jakarta.apache.org 
  >X-Antivirus: nagoya (v4218 created Aug 14 2002) 
  >Message-ID: <04cc01c25454$e891a3c0$cb14a8c0@web2207lou2> 
  >References: <20020904183809.93436.qmail@web20415.mail.yahoo.com> 
  >X-Priority: 3 
  >X-MSMail-Priority: Normal 
  >X-Mailer: Microsoft Outlook Express 6.00.2600.0000 
  >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 
  >X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N 
  >Return-Path: ant-user-return-24552-mgainty=hotmail.com@jakarta.apache.org 
  >X-OriginalArrivalTime: 04 Sep 2002 20:55:35.0546 (UTC) FILETIME=[6A7F0DA0:01C25455]

  > 
  >Does anyone have any suggestions as to how I can get the sql task to work 
  >with the SQLServerDriver? 
  > 
  >Here's what my step looks like: 
  >> driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" 
  > url="jdbc:microsoft:sqlserver://JRREPORTDATA:1433" 
  > userid="XX" 
  > password="XXXX" 
  > > 
  > > insert into XXX..Table (field1,field2,field3) 
  > select field1,field2,field3 from XXX..Table_In; 
  > ]]> 
  > 
  >The error message is: 
  >java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error 
  >establishing socket. 
  > 
  > 
  > 
  > 
  >-- 
  >To unsubscribe, e-mail: 
  >For additional commands, e-mail: 


------------------------------------------------------------------------------
  Send and receive Hotmail on your mobile device: Click Here


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message