MS SQL using TSQL via JAVA jdbc

[asufty888]

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.

[Erland Sommarskog]

(as*******@gmail.com) writes:

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.

I believe that Datadirect's driver is good. Of course, the price is
radically different than for Microsoft's driver or jTDS.

Then again, if you gets the same syntax errors, maybe the problem is
with your SQL code. Have you checked that it runs OK in Query Analyzer?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[joeNOSPAM]

On Feb 5, 10:15 am, [e-mail] 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.