Yup, it was a socket problem. Got it squared away now.
Thanks.
----- Original Message -----
From: Martin Gainty
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
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 [EMAIL PROTECTED]; run by ezmlm
>Precedence: bulk
>List-Unsubscribe:
>List-Subscribe:
>List-Help:
>List-Post:
>List-Id: "Ant Users List"
>Delivered-To: mailing list [EMAIL PROTECTED]
>X-Antivirus: nagoya (v4218 created Aug 14 2002)
>Message-ID: <04cc01c25454$e891a3c0$cb14a8c0@web2207lou2>
>References: <[EMAIL PROTECTED]>
>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: [EMAIL PROTECTED]
>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
