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:
<sql
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://JRREPORTDATA:1433"
userid="XX"
password="XXXX"
>
<![CDATA[
insert into XXX..Table (field1,field2,field3)
select field1,field2,field3 from XXX..Table_In;
]]>
</sql>
The error message is:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error
establishing socket.
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
