Posted by joeNOSPAM@BEA.com on 02/06/07 15:38

On Feb 5, 10:15 am, asufty...@gmail.com wrote:
> Hello. I am having trouble finding a descent API for executing TSQL
> via JDBC. I have tried the Microsoft driver AND the JDTS driver's but
> get the same syntax errors. I am hoping there is a good solution also
> for executing scripts using the same. Any help is MUCH
> appreciated.Thx.

*No* JDBC driver will 'execute' T-SQL. They simply send it to the
DBMS*.
I suspect you are confusing the syntax of OSQL (eg: with 'GO' to send
SQL)
with actual T-SQL. Show the JDBC code and SQL and error you get.

Joe Weinstein at BEA Systems

* There is a small, well-defined area of JDBC SQL extensions which
has the driver look for specific generic tags in the SQL for some
functions, and replace them with correct DBMS-specific SQL.

[Back to original message]