Posted by Erland Sommarskog on 02/05/07 22:24

(asufty888@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: "ODBC--call failed" Error
• Prev in forum: Re: Stored procedure and SQL Job Agent Task
• Thread view: Re: MS SQL using TSQL via JAVA jdbc

[Reply to this message]